Download free S&P 500 historical data using the spreadsheet I've developed. 10+ years of data. EOD (end of day), end of week, or end of month.
How it works
Yahoo finance allows everyone to download their stock market historical data for free. Available all day, everyday, for stocks going back for over 10 years. It is the best source online. You can choose to download the stock adjusted, or unadjusted for dividends and stock splits. There are only two downsides to it:
1. Yahoo does not have a function to download ALL stocks for the S&P 500 at one time. You have so specify each individual stock for download. Each stock involves at least 5 clicks. Multiply that by 500, and that’s at least 2500 clicks to download all stocks.
2. The data downloaded is not in the required format. Most stock programs require the data in metastock format. Its not hard to do. Simply change the date format, insert the symbol at the start, and remove one of the unnecessary columns. Multiply that by 500 again, and that’s over 2 hours of data manipulation.
Lucky there is a solution. Since this task is very repetitive, its easily automated. I've written a excel spreadsheet macro that will do the task for you. And it’s completely free. I hope my spreadsheet will help other stock traders in the world.
spreadsheet >> S&P 500 historical data
Good luck!