Download free S&P 500 historical data using the spreadsheet I’ve developed. It provides the subscribing EP’s own orders and trade tickers as well as the changes of best bid/ask prices during the day for each stock for downloading by subscribing EPs. Our stock data is compatible with most of the leading charting packages including: MetaStock ®, Omnitrader ®, SuperCharts , Advanced GET , TradeStation , AIQ , EzyChart , and many more. EODData brings you quality stock quotes and historical charting data to help set a solid foundation for your investment decisions. EODData is a leading provider of quality historical market data with easy to use download facilities at exceptional prices.
Sure, you can look at my post about Freely Available Financial Data Unfortunately, even using the trick about the Yahoo CSV URL will only allow you to download 200 at a time, and it is tough to do correctly. I’ll show you in this post how to download historical prices for every S&P 500 stock using two programs: R and Excel. By pausing intermittently, the requests become smaller chunks, and it can download all of the tickers.
Using this method, you can download historical data for any securities with data on Yahoo Finance or Google Finance. I’ve shown you how to download the historical adjusted close prices for every stock in the S&P 500 Index, probably saving you lots and lots of time. After the first time using this process, you’ll have everything figured out and ready to go and will only have to wait for the data to download. There is no doubt that the CAPE ratio for the US stock market is high by historical standards. The market remains at a level around 25, as it is today and this implies that returns will be lower than historical averages.
Using Shiller’s estimates it stands around 26 today, clearly above the historical average of about 17. What a higher CAPE means is that you are paying more for the same earnings. If we assume the same number just for simplicity, a higher CAPE means that investors should expect a lower return if they buy the stock market today compared to an average year in the past. One is that returns in all other assets are also lower than historical averages. In that sense, the stock market is not expensive, it is prices in a way that is consistent with historical levels.
This is certainly the case today where interest rates on bonds are at very low historical levels and it is difficult to foresee a large increase in the coming years. A quick calculation using current bond interest rates would tell us that the stock market at a 25 CAPE ratio offers a risk premium over bonds that is similar to what the stock market offered when the CAPE ratio was 17 (around 6-7%).