Serving the Quantitative Finance Community

 
User avatar
cplxphil
Topic Author
Posts: 0
Joined: June 6th, 2009, 10:04 pm

Where to find .XLS files of historical stock prices

January 18th, 2010, 2:15 am

Hi all,I'm trying to find historical stock prices like the ones on Yahoo Finance for stocks; I'd like to find them in .XLS format, if possible. (Really, any file format would work; .cvs, .txt, whatever, just something that isn't web-based.) Yahoo Finance almost works, but I'm looking for 10-20 years of history per stock (where applicable), and for some reason when I try to view beyond about 2-3 years the data cuts off on the Yahoo service.Does anyone know of a good source of this data? I'm trying to code an automated analysis tool for certain equities, but I can't do this without the historical data for the stocks in question.Thanks for any help anyone can provide.-Phil
 
User avatar
acastaldo
Posts: 14
Joined: October 11th, 2002, 11:24 pm

Where to find .XLS files of historical stock prices

January 18th, 2010, 3:43 am

QuoteOriginally posted by: cplxphilfor some reason when I try to view beyond about 2-3 years the data cuts off on the Yahoo service.Perhaps a bug in your code? It should be possible to retrieve more than 2 years of data from Yahoo Finance (which is a good choice for a free data source BTW). Many people have written code to do this and some of it is even publically available.
 
User avatar
cplxphil
Topic Author
Posts: 0
Joined: June 6th, 2009, 10:04 pm

Where to find .XLS files of historical stock prices

January 18th, 2010, 3:56 am

No, I accessed the file manually, not with a program. I could find data dating back to 1993 on Google Finance for (for example) CHIO. But, when I looked at the Yahoo finance spreadsheet for the same stock, it would only give me back to April 25, 2007. Oddly, though, I could go back to 1986 for MSFT on Yahoo Finance.
 
User avatar
cplxphil
Topic Author
Posts: 0
Joined: June 6th, 2009, 10:04 pm

Where to find .XLS files of historical stock prices

January 18th, 2010, 7:58 pm

Nevermind, it was apparently something wrong with Google finance, or just something I don't get. The company I was looking at was founded in 2006, yet for some reason Google had data available on it dating back to 1993. Maybe a different company had the same symbol, or something?