Did you know that there isn't anywhere on the web where you can go and get quarterly data for the S&P 500 before 1988? It's true, or at least it was true, until today!
Prior to today, the only place you could obtain data like the amount of dividends per share (DPS) or earnings per share (EPS) for S&P 500 companies was Standard & Poor, who only makes available the data since 1988 [Excel spreadsheet].
Meanwhile, you can obtain trailing year DPS and EPS data for the S&P 500 and its predecessor indices and component stocks from Yale's Robert Shiller [Excel spreadsheet], or perhaps more easily from our S&P 500 at Your Fingertips tool, which go all the way back to January 1871. Unlike Professor Shiller's spreadsheet, our tool also calculates the rate of return between any two calendar months you select, both with and without the reinvestment of dividends and with and without the effects of inflation.
It's a strange omission, if you think about it, because earnings and dividends are both reported and paid by the quarter!
So we're fixing that situation today. We've used S&P's available quarterly data since 1988 and our trailing year data to work out what the S&P 500's quarterly data would have to be for each quarter going all the way back to 1871-Q1.
You can access our data in the tool below, or if you prefer your data in graphical format, in the charts that appear below our tool:
Now for the charts covering the quarterly data for the S&P 500 and its predecessor indices and component stocks since the first quarter of 1871. Our first chart shows the S&P 500's average price per share in the month ending the quarter in question:
Next, let's look at the dividends per share that were paid out in each quarter from 1871-Q1 through 2012-Q4:
Our third chart reveals the earnings per share that would be reported for each quarter from 1871-Q1 through 2012-Q4:
If you're ever bored and looking for something to do, overlay the data for the price per share chart and the dividends per share chart - you might make a pretty unique discovery!
Update 12 January 2023: Now up to date through 2022, with preliminary earnings data for 2022-Q4. This data should be finalized in April 2023.
Image Source: Northern California Grantmakers
Labels: current, dividends, earnings, SP 500, stock market
Welcome to the blogosphere's toolchest! Here, unlike other blogs dedicated to analyzing current events, we create easy-to-use, simple tools to do the math related to them so you can get in on the action too! If you would like to learn more about these tools, or if you would like to contribute ideas to develop for this blog, please e-mail us at:
ironman at politicalcalculations
Thanks in advance!
Closing values for previous trading day.
This site is primarily powered by:
CSS Validation
RSS Site Feed
JavaScript
The tools on this site are built using JavaScript. If you would like to learn more, one of the best free resources on the web is available at W3Schools.com.
Other Cool Resources
Blog Roll
