In this page, you can find a downloadable file with historical price information about companies currently found in the S&P 500 (Standard and Poor’s 500 index). This data can be helpful if you want to engage in stock market investing. We update the page on a daily basis. The S&P is a free-float, capitalization-weighted index of the top 500 publicly listed stocks in the USA and it is one of the most commonly followed equity indices.
Stock market data can be extremely interesting to analyze. The seemingly endless amount of financial data online is often daunting and nearly impossible to navigate especially if you happen to lack any programming skills, making a large and well-structured dataset as well as stock prices on the currently listed companies invaluable.
All of the data we provide displays stock prices derived from Yahoo Finance after the NYSE’s normal close (EST) on a daily basis. It is separated into five excel tabs showing the stock prices at opening and closing as well as their high and low points on that trading day including the volume of stock traded for that particular day.
This detailed dataset lends itself to some very interesting visualizations and analysis possibilities. One can look at simple things like how prices change over time, graph or compare multiple stocks at once, or compare historical returns for different securities. From these data informative stock indicators such as volatility and moving averages can also be very easily calculated.
You can download the up-to-date S&P 500 Excel data for free (provided in XLSX format containing five tabs) in the link below.
Last updated: 07/27/2021 (m/d/y).
Disclaimer: We are not responsible for any losses that may be incurred due to decisions based on data provided on this page.