Others titles
- Standard and Poor's 500 Index Data
- S&P 500 Index Data including Dividend, Earnings and P/E Ratio
- Standard and Poor's 500 Index Data 1871 to 2016
Keywords
- S&P 500
- CPI
- P/E Ratio
- Consumer Price Index
- Standard and Poor's 500
- Market Capitalization
- Stock Price Index (SPI)
Standard and Poors 500 Index including Earnings And PE Ratio

This dataset consists of S&P 500 (Standard and Poor’s 500) index data including level, dividend, earnings and P/E (Price Earnings) ratio on a monthly basis since 1871. The S&P 500 (Standard and Poor’s 500) is a free-float, capitalization-weighted index of the top 500 publicly listed stocks in the US (top 500 by market capitalization).
Get The Data
- Research
Non-Commercial,
Share-Alike,
Attribution Free Forever
- Commercial
Commercial Use,
Remix & Adapt,
White Label Log in to download
Description
The Standard & Poor’s 500 Index (S&P 500) is an index of 500 stocks seen as a leading indicator of U.S. equities and a reflection of the performance of the large-cap universe, made up of companies selected by economists. The S&P 500 is a market value weighted index and one of the common benchmarks for the U.S. stock market; other S&P indexes include small-cap companies with market capitalization between $300 million and $2 billion, and an index of mid-cap companies. Investment products based on the S&P 500 include index funds and exchange-traded funds are available to investors.
The S&P 500 is widely regarded as the most accurate gauge of the performance of large-cap American equities. While the S&P 500 focuses on the large-cap sector of the market; it is considered representative of the market because it includes a significant portion of the total value of the market. The 500 companies included in the S&P 500 are selected by the S&P Index Committee, a team of analysts and economists at Standard & Poor’s. These experts consider various factors when determining the 500 stocks that are included in the index, including market size, liquidity and industry grouping.
The S&P 500 has become a preferred index for U.S. stocks, unseating the Dow Jones Industrial Average (DJIA). The S&P 500 is perceived as more representative of the market because it is made of 500 companies, compared to the DJIA’s 30. There is also a major difference in how companies are represented in either index. The S&P 500 uses a market cap methodology, giving a higher weighting to larger companies, whereas the DJIA uses a price weighting methodology which gives more expensive stocks a higher weighting. The market cap ranking is also seen as more representative of real market structure.
The P/E 10 ratio is a valuation measure, generally applied to broad equity indices, that uses real per-share earnings over a 10-year period. The P/E 10 ratio uses smoothed real earnings to eliminate the fluctuations in net income caused by variations in profit margins over a typical business cycle. The ratio was popularized by Yale University professor Robert Shiller, who won the Nobel Prize in Economic Sciences in 2013. It attracted a great deal of attention after Shiller warned that the frenetic U.S. stock market rally of the late-1990s would turn out to be a bubble. The P/E 10 ratio is also known as the “cyclically adjusted PE (CAPE) ratio” or “Shiller PE ratio.”
About this Dataset
Data Info
Date Created | 1870 |
---|---|
Last Modified | 2019-09-01 |
Version | 2019-09-01 |
Update Frequency |
Monthly |
Temporal Coverage |
1871-01-01 to 2018-04-01 |
Spatial Coverage |
United States |
Source | John Snow Labs; Robert Shiller, Yale University; |
Source License URL | |
Source License Requirements |
N/A |
Source Citation |
N/A |
Keywords | S&P 500, CPI, P/E Ratio, Consumer Price Index, Standard and Poor's 500, Market Capitalization, Stock Price Index (SPI) |
Other Titles | Standard and Poor's 500 Index Data, S&P 500 Index Data including Dividend, Earnings and P/E Ratio, Standard and Poor's 500 Index Data 1871 to 2016 |
Data Fields
Name | Description | Type | Constraints |
---|---|---|---|
Date | Date of monthly earnings data | date | required : 1 |
SP_500 | number | required : 1 | |
Dividend | Monthly dividend data is computed from the S&P four-quarter totals for the quarter since 1926, with linear interpolation to monthly figures. Dividend data before 1926 is from Cowles and associates (Common Stock Indexes, 2nd edition), interpolated from annual data. | number | - |
Earnings | Monthly earnings data is computed from the S&P four-quarter totals for the quarter since 1926, with linear interpolation to monthly figures. Earnings data before 1926 is from Cowles and associates (Common Stock Indexes, 2nd edtion), interpolated from annual data. | number | - |
Consumer_Price_Index | Monthly consumer price index to allow conversion to real values. | number | level : Ratiorequired : 1 |
Long_Interest_Rate | 10 year interest rate (gov bonds) | number | level : Ratiorequired : 1 |
Real_Price | Real price | number | required : 1 |
Real_Dividend | Real dividend | number | level : Ratio |
Real_Earnings | Income of an individual or group after taking into consideration the effects of inflation on purchasing power. | number | - |
PE_10_Ratio | Cyclically Adjusted Price Earnings (P/E) Ratio | number | level : Ratio |
Data Preview
Date | SP 500 | Dividend | Earnings | Consumer Price Index | Long Interest Rate | Real Price | Real Dividend | Real Earnings | PE 10 Ratio |
1871-01-01 | 4.44 | 0.26 | 0.4 | 12.46 | 5.32 | 89.0 | 5.21 | 8.02 | |
1871-02-01 | 4.5 | 0.26 | 0.4 | 12.84 | 5.32 | 87.53 | 5.06 | 7.78 | |
1871-03-01 | 4.61 | 0.26 | 0.4 | 13.03 | 5.33 | 88.36 | 4.98 | 7.67 | |
1871-04-01 | 4.74 | 0.26 | 0.4 | 12.56 | 5.33 | 94.29 | 5.17 | 7.96 | |
1871-05-01 | 4.86 | 0.26 | 0.4 | 12.27 | 5.33 | 98.93 | 5.29 | 8.14 | |
1871-06-01 | 4.82 | 0.26 | 0.4 | 12.08 | 5.34 | 99.66 | 5.38 | 8.27 | |
1871-07-01 | 4.73 | 0.26 | 0.4 | 12.08 | 5.34 | 97.8 | 5.38 | 8.27 | |
1871-08-01 | 4.79 | 0.26 | 0.4 | 11.89 | 5.34 | 100.62 | 5.46 | 8.4 | |
1871-09-01 | 4.84 | 0.26 | 0.4 | 12.18 | 5.35 | 99.29 | 5.33 | 8.21 | |
1871-10-01 | 4.59 | 0.26 | 0.4 | 12.37 | 5.35 | 92.71 | 5.25 | 8.08 |