Unexpectedly Intriguing!
February 15, 2013

Quarterly Calendar - Source: NCG.org
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:

Year and Quarter for S&P 500 Data
Input Data Year Quarter
Select Year and Quarter

Historic Quarterly Stock Market Data
Estimated Results Values
Average Price per Share in Month Ending Quarter
Quarterly Dividends per Share
Quarterly Earnings per Share

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:

S&P 500 Average Monthly Index Value in Month Ending Quarters, 1871-Q1 to 2012-Q4

Next, let's look at the dividends per share that were paid out in each quarter from 1871-Q1 through 2012-Q4:

S&P 500 Quarterly Dividends per Share, 1871-Q1 to 2012-Q4

Our third chart reveals the earnings per share that would be reported for each quarter from 1871-Q1 through 2012-Q4:

S&P 500 Quarterly Dividends per Share, 1871-Q1 to 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 16 February 2013: Speaking of which, it certainly would be a lot easier to make that discovery if we also made the Quarterly S&P 500 Data Since 1871-Q1 available to you in spreadsheet form!

Image Source: Northern California Grantmakers


Labels: , , ,

About Political Calculations



blog advertising
is good for you

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.com

Thanks in advance!

Recent Posts

Applications

This year, we'll be experimenting with a number of apps to bring more of a current events focus to Political Calculations - we're test driving the app(s) below!

Most Popular Posts
Quick Index

Site Data

This site is primarily powered by:

This page is powered by Blogger. Isn't yours?

Visitors since December 6, 2004:

CSS Validation

Valid CSS!

RSS Site Feed

AddThis Feed Button

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

Market Links
Charities We Support
Recommended Reading
Recommended Viewing
Recently Shopped

Seeking Alpha Certified

Archives
Legal Disclaimer

Materials on this website are published by Political Calculations to provide visitors with free information and insights regarding the incentives created by the laws and policies described. However, this website is not designed for the purpose of providing legal, medical or financial advice to individuals. Visitors should not rely upon information on this website as a substitute for personal legal, medical or financial advice. While we make every effort to provide accurate website information, laws can change and inaccuracies happen despite our best efforts. If you have an individual problem, you should seek advice from a licensed professional in your state, i.e., by a competent authority with specialized knowledge who can apply it to the particular circumstances of your case.