Cool Excel addin to pull live stock quotes into a SS

[Maurice]

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

[twaddle]

This is the one I use:

smf_addin : EXCEL Stock Market Functions Add-in

[Rich_by_the_Bay]

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.

[utrecht]

Will this work with Excel '97?

[Infidel]

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!

[bpp3]

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.

[kumquat]

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.

[Maurice]

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.

[donheff]

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.

[donheff]

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.