It puts up to 200 stock symbols on each of several sheets and you download to each sheet in turn. Since Yahoo has a limit on the number of stock symbols you can use, there's another spreadsheet (Yahoo2.xls) here that gets around that limitation.Of course, ya gotta know the Yahoo option symbols !! So, there's a spreadsheet that looks like this: Note: Any time Yahoo changes youcan try that ritual.Īfter getting e-mail from R.K., I discover that Yahoo has option data, too ** That's the most important part of the ritual. Look for a statement containing the phrase:.Right-click on the Download button that calls the macro.It's now Mar, 2007 and Yahoo has changed the pertinent URL again. It's now Feb, 2004 and Yahoo has changed the pertinent URL If you'd like to play with the 500 S&P stocks, you can use the spreadsheet described The data associated with such a stock won't look good. To download the spreadsheet, click on the picture above.ĭata is downloaded in. You will also want to reformat the columns so that prices don't display as dates (so you know what you're getting), then click the Download Data button. You just have to identify the Yahoo Symbols, stick in the Yahoo Tags that define the info you want,

Here's a spreadsheet that'll download the Yahoo data according to the tags that you specify: Whereas, to get the data already in a spreadsheet (so you can play it),

Percent Change From 50-day Moving Averageįor example, if y'all copy and paste this URL into your browser address: Percent Change From 200-day Moving Average Where some special tags are (thanks to Mike):Įrror Indication (returned for symbol changed / invalid) Here's a neat way to download stock data from Yahoo, perhaps into a spreadsheetĪ BUNCH of STOCK SYMBOLS separated by '+' &f= a bunch of special tags

Yahoo data download Downloading Yahoo data thanks to M.Kishinevsky and M.

Download finance yahoo com