Software

Ask something
Question Locked

Historical Stock Data

0 helpful
4 replies

by susan_cecala

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Does any one know how to download Historical stock data from Yahoo Finance or MSN ? Any script that I can use to automate the process would be good.

I have a list of stock quote which I need to download the pass 3 to 5 years historical data to perform further analysis, preferably the data is in csv or xls format.

Thanks,
Susan

4 replies

by lllllllmmmmmmm

Yahoo has changed its url for downloads: It is now
http://finance.yahoo.com/d/quotes.csv?s= (an so on)

In addition to the date range scheme thaqt William D provided, yahoo has provided additional parameters, which can be found at:
http://www.dividendgrowth.org/FundamentalAnalysis/YahooData.htm

An example url would be: URL = http://finance.yahoo.com/d/quotes.csv?s=GE+T+ZRAN+AGIX+COP+CDV+MSFT&f=nl1vhgd1

Options can also be downloaded using Yahoo's options codes.

See also http://gummy-stuff.org/index.html
a FANTASTIC quantitative invesment site with an incredible collection of free algorithms and XL spreadsheets.

This discussion is closed to new replies.