Sunday, May 8, 2011

S&P 500 historical data in excel (monthly)

Daily Open High Low Close Adj Close & Volume data for the S&P 500 index since the index was published in 1950 in excel format.

S&P 500 historical data in excel

This is monthly data.
One can download from the above link. It is neatly arranged in excel and uploaded to google docs. Just choose the following in google docs to save to your computer as an excel sheet.

File>Download As>Excel

If there are any problems downloading the data please leave a comment and I will resolve it.


1 comment:

  1. Hey,
    thanks for the data. from where do you have them?
    I compared the volume data to data from bloomberg, and they are not the same.
    would be very cool if you could clarify that. thanks!