Jumat, 15 Februari 2013

Quarterly Data for the S&P 500, Since 1871

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



Tidak ada komentar:

Posting Komentar