Hey, do you know whether there is a free Excel addon which can retrieve stock data from Yahoo Finance (or other sources)? I would like to retrieve stock data of a specific date. For example, when I input this function "=getclose(MSFT, 2007-01-01)", it will get the closing price of MSFT on 2007 Jan 01. Thanks a lot.
But how can I get stock quote of a particular date? It can only get Today's H/L/C/O. We can't specify what date of H/L/C/O we want.
http://www.gummy-stuff.org/Yahoo-data.htm just one example there is bunch of yahoo excel groups,who use it for trading. i post it somewhere here, on et while ago. just search yahoo
possibly ?... http://www.business-spreadsheets.com/forum.asp?t=40 <img src="http://www.enflow.com/p.gif">
I can only retrieve stock quotes using its specially layout Excel. I would like to retrieve stock quotes anywhere (eg by typing a function). And I can't see it tells me how to retrieve stock quotes of specific date only (not just today).
It seems better, but I can't retrieve stock quotes from anywhere. And how can I retrieve stock quotes of many tickers in a quick way? For example I would like to get the closing price after the first month the stock goes public. But they can't do it.
this is just example for you. i'm pretty sure, that if you modify that macro you can get those quotes. i can do it in 30-45 min, but i'm too lazy. just like you are
http://www.google.com/search?q=exce...s=org.mozilla:en-US:official&client=firefox-a keep in mind that you have to maintain current list of traded stocks, take care splits and dividends,volume after split and many other things. personally- i would pay a small fee for something like Quote Plus, instead of dealing with all that crap.
http://www.filedudes.com/files/Excel_Stock_Quotes.html http://help.lockergnome.com/office/web-quits-working-Yahoo-historical-quotes-ftopict754417.html http://www.mrmarketishuge.com/showthread.php?t=1214 and so on....