 |
Cool Excel addin to pull live stock quotes into a SS
12-07-2007, 01:47 PM
|
#1
|
Full time employment: Posting here.
Join Date: Oct 2007
Location: New York
Posts: 898
|
Cool Excel addin to pull live stock quotes into a SS
I posted this deep in another thread, but thought I'd give its own thread so more people could see it.
Its an excel addin from Microsoft that retreives live quotes (ok, 20 min delay) from MSN Moneycentral and pulls them into your spreadsheet. There's even a button its adds to the task bar to update them (they do not update automatically with each calc of the spreadsheet)
An example is as follows:
=MSNStockQuote("MSFT","Last Price","US")
would bring in the last trade for Microsoft.
=MSNStockQuote("/USDEUR","Last Price","US")
brings in the EURUSD exchange rate.
The addin can be downloaded here:
http://www.microsoft.com/downloads/d...displaylang=en
__________________
Money's just something you need in case you don't die tomorrow.
|
|
|
 |
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!
Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!
You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!
|
12-07-2007, 01:50 PM
|
#2
|
Thinks s/he gets paid by the post
Join Date: Jun 2006
Posts: 1,697
|
|
|
|
12-07-2007, 02:04 PM
|
#3
|
Moderator Emeritus
Join Date: Feb 2006
Location: San Francisco
Posts: 8,827
|
Google spreadsheets does that an also pulls in a ton of other data. Plus you can access it from anywhere (just be careful what you put in there for security's sake). It exports as an xls file as well.
__________________
Rich
San Francisco Area
ESR'd March 2010. FIRE'd January 2011.
As if you didn't know..If the above message contains medical content, it's NOT intended as advice, and may not be accurate, applicable or sufficient. Don't rely on it for any purpose. Consult your own doctor for all medical advice.
|
|
|
12-07-2007, 05:56 PM
|
#4
|
Thinks s/he gets paid by the post
Join Date: Nov 2006
Posts: 2,288
|
Will this work with Excel '97?
|
|
|
Google to the rescue again
12-07-2007, 11:51 PM
|
#5
|
Confused about dryer sheets
Join Date: Oct 2007
Posts: 3
|
Google to the rescue again
Quote:
Originally Posted by Rich_in_Tampa
Google spreadsheets does that an also pulls in a ton of other data. Plus you can access it from anywhere (just be careful what you put in there for security's sake). It exports as an xls file as well.
|
Eureka! That is totally cool! I've used Google spreadsheets but did not know they had that function. I'm an open source/free software guy (I mean really, who would *pay* good money for software?), but was not able to find such a function for the otherwise superb OpenOffice suite ( OpenOffice.org: Home). But since Google can do this, I'm now set. Thanks!
__________________
The way by which you may get money almost without exception leads downward. -- Thoreau
|
|
|
12-08-2007, 03:20 AM
|
#6
|
Recycles dryer sheets
Join Date: May 2007
Posts: 290
|
Quote:
Originally Posted by Infidel
I'm an open source/free software guy (I mean really, who would *pay* good money for software?), but was not able to find such a function for the otherwise superb OpenOffice suite ( OpenOffice.org: Home).
|
OpenOffice does have a generic web query function, which can be used for the same purpose. More flexible, though probably takes a bit longer to learn how to use.
|
|
|
12-08-2007, 06:54 AM
|
#7
|
Thinks s/he gets paid by the post
Join Date: Nov 2005
Location: North of Montana
Posts: 2,765
|
Quote:
Originally Posted by Infidel
I'm an open source/free software guy (I mean really, who would *pay* good money for software?), but was not able to find such a function for the otherwise superb OpenOffice suite ( OpenOffice.org: Home).
|
Check this site's thread Financial Webring Forum :: View topic - Downloading stock feeds in to Excel - a how-to guide PCmag
Poster rails gives advice to OpenOffice users. It works in my OOCalc spreadsheet.
__________________
There are two kinds of people in the world: those who can extrapolate conclusions from insufficient data and ..
|
|
|
12-08-2007, 07:18 AM
|
#8
|
Full time employment: Posting here.
Join Date: Oct 2007
Location: New York
Posts: 898
|
Quote:
Originally Posted by utrecht
Will this work with Excel '97?
|
I wouldn't think so (at least the one from MSFT that I linked to). It says 2002/2003.
__________________
Money's just something you need in case you don't die tomorrow.
|
|
|
12-08-2007, 07:48 AM
|
#9
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Feb 2006
Location: Washington, DC
Posts: 10,758
|
Quote:
Originally Posted by Infidel
Eureka! That is totally cool! I've used Google spreadsheets but did not know they had that function. I'm an open source/free software guy (I mean really, who would *pay* good money for software?), but was not able to find such a function for the otherwise superb OpenOffice suite ( OpenOffice.org: Home). But since Google can do this, I'm now set. Thanks!
|
I have a basic script in Open Office Calc that pulls down the latest quote for all my holdings. I like the idea of Google Docs since it would be accessible anywhere so I may set one of those up too.
__________________
Every man is, or hopes to be, an Idler. -- Samuel Johnson
|
|
|
12-08-2007, 09:03 AM
|
#10
|
Give me a museum and I'll fill it. (Picasso) Give me a forum ...
Join Date: Feb 2006
Location: Washington, DC
Posts: 10,758
|
I uploaded my OO sheet to GoogleDocs and replaced my formulas with Google's. Works great. Thanks for the tip. It was also easy to add entries for return to date and a weighted average return to date for my funds.
__________________
Every man is, or hopes to be, an Idler. -- Samuel Johnson
|
|
|
 |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Thread Tools |
Search this Thread |
|
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
» Recent Threads
|
|
|
|
|
|
|
|
|
|
|
|
|
» Quick Links
|
|
|