Join Early Retirement Today
Reply
 
Thread Tools Search this Thread Display Modes
Cool Excel addin to pull live stock quotes into a SS
Old 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.
Maurice is offline   Reply With Quote
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!

Old 12-07-2007, 01:50 PM   #2
Thinks s/he gets paid by the post
twaddle's Avatar
 
Join Date: Jun 2006
Posts: 1,378
This is the one I use:

smf_addin : EXCEL Stock Market Functions Add-in
__________________

__________________
twaddle is offline   Reply With Quote
Old 12-07-2007, 02:04 PM   #3
Moderator Emeritus
Rich_by_the_Bay's Avatar
 
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.
Rich_by_the_Bay is offline   Reply With Quote
Old 12-07-2007, 05:56 PM   #4
Thinks s/he gets paid by the post
 
Join Date: Nov 2006
Posts: 2,268
Will this work with Excel '97?
__________________
utrecht is offline   Reply With Quote
Google to the rescue again
Old 12-07-2007, 11:51 PM   #5
Confused about dryer sheets
Infidel's Avatar
 
Join Date: Oct 2007
Posts: 3
Google to the rescue again

Quote:
Originally Posted by Rich_in_Tampa View Post
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
Infidel is offline   Reply With Quote
Old 12-08-2007, 03:20 AM   #6
Recycles dryer sheets
 
Join Date: May 2007
Posts: 290
Quote:
Originally Posted by Infidel View Post
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.
__________________
bpp3 is offline   Reply With Quote
Old 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,753
Quote:
Originally Posted by Infidel View Post
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 ..
kumquat is offline   Reply With Quote
Old 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 View Post
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.
Maurice is offline   Reply With Quote
Old 12-08-2007, 07:48 AM   #9
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
donheff's Avatar
 
Join Date: Feb 2006
Location: Washington, DC
Posts: 8,633
Quote:
Originally Posted by Infidel View Post
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
donheff is offline   Reply With Quote
Old 12-08-2007, 09:03 AM   #10
Give me a museum and I'll fill it. (Picasso)
Give me a forum ...
donheff's Avatar
 
Join Date: Feb 2006
Location: Washington, DC
Posts: 8,633
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
donheff is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Charting Question Telly Other topics 2 04-23-2007 12:00 PM
Live long enough to live forever (book) JJac Health and Early Retirement 10 11-25-2006 08:41 PM
Excel stock quote add-in hlep needed Gonzo Other topics 4 09-01-2006 11:45 AM

 

 
All times are GMT -6. The time now is 03:55 AM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.