Dima, Google finance. Click on historical prices near the top right corner of the chart. Then select the date range and make sure to click update before downloading to a spreadsheet. Regards, Max maxdama.com
thanks Max...but it seems the prices cannot be downloaded all at once in excel format...(((( or is there a way to do this? thanks!
Dima, Click "download to spreadsheet" next to the update button. Open that file with Excel . The file will be in csv format which Excel has no problems with. Regards, Max
Max, thanks..but i see no button like that..here is an example page I am looking on: http://finance.google.com/finance/historical?q=INDEXDJX:.DJI Please give me the link wher you see this button... thanks!!! Dima
Dima, Sorry about that, you are totally right. I guess you can only get historical data for ETF's, stocks, etc and not the indexes on Google finance (try SPY to see for yourself). What a useless exception. Yahoo finance can give you historical data too. After you enter a symbol on yahoo finance, on the left blue column near the top there is a link "Historical Prices". Click on that and then go to the bottom of the table and there is a text link "Download to Spreadsheet". I just tested it for ^DJI and it works fine. The reason I didn't direct you to yahoo in the first place is because their data is sometimes messy, with dividends embedded in the columns (scroll down to see) so it's a pain to clean up. I guess that won't be a problem with ^DJI though. If you want an explanation with screenshots there's an old entry on maxdama.com that clearly shows how to get historical data from Google. Regards, Max
BlueOcean, See my previous post for the process to download historic data from Yahoo. If you are asking whether Excel can open a csv file, yes it can, just open it normally. Regards, Max
if you want a free api for working with historical data as bars, checkout http://tradelink.googlecode.com eg you can do: // grab daily data from google BarList bl = new BarList("IBM"); bl.DayFromGoogle(); // print daily range for every trading day available foreach (Bar bar in bl) Console.WriteLine("DayRange: "+bar.High-bar.Low);
For anyone who has used both Google historical data and Yahoo historical data, how do they compare in terms of accuracy and completeness?