Yahoo Data Downloads
Yahoo is probably the easiest source for a wide variety of financial data, but unfortunately Yahoo does not have the best of reputations for data accuracy or reliability.
See this link for a description. The contents are shown below:
Here's a neat way to download stock data from Yahoo, perhaps into a spreadsheet (so you can play with the data): http://finance.yahoo.com/d/quotes.csv?s= a BUNCH of STOCK SYMBOLS separated by "+" &f=a bunch of special tags for example: http://finance.yahoo.com/d/quotes.csv?s=XOM+BBDb.TO+JNJ+MSFT&f=snd1l1yr where some special tags are (thanks to Mike):
http://finance.yahoo.com/d/quotes.csv?s=BBDB.TO+NT.TO+GE+MSFT&f=snl1d1t1ohgdr you'll get something which looks like:
and whereas, to get the data already in a spreadsheet (so you can play it),
you can use (for example): Here's a spreadsheet that'll download the Yahoo data according to the tags that you specify: You just follow steps 1, 2, 3 then 4 (click the button). >And all that info gets ...?
To download the spreadsheet, click on the picture above. See also Portfolio spreadsheet.
If you'd like to play with the 500 S&P stocks, you can use the spreadsheet described here. It also uses some of these tags.
It's now Feb, 2004 and Yahoo has changed the pertinent URL
http://finance.yahoo.com/d/quotes.csv?s= to http://quote.yahoo.com/d/quotes.csv?s= AARGH!
To make the change you can try this:
Note: Any time Yahoo changes youcan try that ritual.
So, there's a spreadsheet that looks like this: Click on the picture to download Of course, ya gotta know the Yahoo option symbols !!
Anyway, having downloaded a bunch of stuff associated with a gaggle of stocks, this spreadsheet will sort them: (Click on the picture to download.)
You download as you'd normally do ... perhaps to check the latest numbers ... THEN, click the Save Data button to save that latest data.
Of course, each sheet must be created ... but there's an Explain sheet that says:
In other words, you may decide which stocks get their data saved, which don't and which added sheets get deleted.
|