Political Calculations
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: , , ,



<< Home
Unexpectedly Intriguing!

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

Teens, Young Adults and President Obama's Minimum ...

How Many Pages Long Is the U.S. Income Tax Code in...

China Surpasses U.S. in International Trade

Dividends and Stock Prices: Welcome Back to the Cu...

Modeling U.S. Households Since 1900

The Danger of Leveraging Returns

The 100th Anniversary of U.S. Income Taxes

Stagnation Dominates U.S. Employment Situation

Dividends, Recessions and Records

New Jobless Claims: Totally Expected and What to E...

Elsewhere on the Web

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

The S&P 500 at Your Fingertips

The Distribution of Income for 2010: Individuals

Should You Trade in Your Gas Guzzler?

What Are the Chances Your Marriage Will Last?

Tipping Around the World

What's Your Body Fat Percentage?

The Odds of Dying, Again!

Gas Prices, the Unemployment Rate, and Desperation

Hauser's Law

The Real Story Behind "Rising" U.S. Income Inequality

Quick Index

First Time Visitor to Political Calculations?

On the Moneyed Midways

A Lot, But Not All, of Our Tools

U.S. GDP Temperature Gauge

Political Calculations' GDP Temperature Gauge, 2013Q1 First Estimate Political Calculations' U.S. GDP Temperature Gauge provides a means to quickly evaluate the growth rate of the U.S. economy against the backdrop of how the economy has performed since 1980, with the "temperature" color spectrum ranging from a recessionary "cold" (purple) through an expansionary "hot" (red).

The GDP Temperature Gauge presents both the annualized GDP growth rate as reported by the U.S. Bureau of Economic Analysis reports for a one-quarter period and also as averaged over a two quarter period, which smooths out the volatility seen in the one-quarter data and provides a better indication of the relative strength of the U.S. economy over time.

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

ZunZun - Exceptional regression analysis tool.
Wolfram Integrator - Solve integrals. Do calculus!
Create a Graph - Easy-to-use basic graph-making tool.
Many Eyes - Data visualization extraordinaire!
Wolfram Alpha - Computational knowledge engine.
Khan Academy - Math & science video mini-lectures!
Picasion - Animate images.


Archives
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
July 2008
August 2008
September 2008
October 2008
November 2008
December 2008
January 2009
February 2009
March 2009
April 2009
May 2009
June 2009
July 2009
August 2009
September 2009
October 2009
November 2009
December 2009
January 2010
February 2010
March 2010
April 2010
May 2010
June 2010
July 2010
August 2010
September 2010
October 2010
November 2010
December 2010
January 2011
February 2011
March 2011
April 2011
May 2011
June 2011
July 2011
August 2011
September 2011
October 2011
November 2011
December 2011
January 2012
February 2012
March 2012
April 2012
May 2012
June 2012
July 2012
August 2012
September 2012
October 2012
November 2012
December 2012
January 2013
February 2013
March 2013
April 2013
May 2013

Blog Roll

Bloodhoundblog
Budgets Are Sexy
Cafe Hayek
Carpe Diem
Core77
Coyote Blog
Craig Harper
Darwin's Finance
Digerati Life, The
Division of Labour
Dough Roller, The
Eclectecon
Econlog
Economics Roundtable
EconomicsUK
Environmental Economics
Escape from Cubicle Nation
Execupundit
FiscalGeek
Get Rich Slowly
Gongol
Good Financial Cents
HR Bartender
Hot Air
i4cp Productivity
Innocent Bystanders
Innovation and Growth
Instapundit
Intangible Economy
I've Paid Twice for This Already
Joanne Jacobs
Kaus Files
Len Penzo dot Com
Making Ripples
Market Power
Mechonomics
Mighty Bargain Hunter
Monevator
My Dollar Plan
New Economist
Newmark's Door
Nina Simosko
Physorg
Private Sector Development
Real Clear Politics
Richard Fernandez
Roger L. Simon
Rowan Manahan
Sound Politics
SOX First
Sports Economist, The
squawkfox
Three Star Leadership
Tim Worstall
Townhall
Trusted Advisor
Uncommon Misperceptions
voluntaryXchange
WILLisms
Winterspeak

Market Links

Big Picture, The
Crackerjack Finance
CXO Advisory Group
Disciplined Approach to Investing
Dividend Guy, The
Doug Short
Evidence Investing
Fat Pitch Financials
FX Investment Strategies
Oilprice

Charities We Support

American Red Cross
Children's Heart Foundation
Salvation Army
SMA Foundation

Recommended Reading

Kindle Paperwhite 3G - Best e-reader!
Angel in the Whirlwind
Bailout Nation
Cartoon Guide to Statistics
A Comprehensive Guide to the Peloponnesian War
The Complete Personal Memoirs of Ulysses S. Grant
The Count of Monte Cristo
Ender's Game
Gardner's Art Through the Ages
Empire of Wealth
How to Make Presentations to Councils and Boards
Juran's Quality Handbook
Marks' Standard Handbook
The Second World War
Stocks for the Long Run
Why Smart Executives Fail

Recommended Viewing

The Tudors: The Complete Series

Recently Shopped

Kindle Fire HD 8.9" 4G LTE Wireless 32 GB
Snap Circuits Jr. SC-100
Nerf Vortex Praxis
Sony BRAVIA 40" LED HDTV
2540 Series Docking Station
New Balance MX623
Dunham Men's Waterproof Oxford
TN360 Black Toner Cartridge
The Dangerous Book for Boys
Air Swimmer Remote Control Inflatable Flying Shark
Fisher-Price Little People Lil Pirate Ship

Seeking Alpha Certified