No. of Recommendations: 3
How far back can the data go?

I did this with Prof. Shiller's data, kept up to date using Pinnacle.
A bit tricky because Shiller uses "earnings during the reporting time
period ending on the date shown" whereas Pinnacle uses "last 4 quarters of
earnings reported prior to the date shown" from Dow Jones News.
Shiller's data are monthly from 1871, and always a few months late.
Pinnacle's are weekly from January 1936 and updated every Saturday.
Both data sources have a CPI column so real earnings adjustments are easy.

So, basically no problem spotting rollovers in real earnings over many cycles.

I haven't really tried it as a top detector, assuming that by the time
earnings roll over the market already did so.
That's why leading economic indicators use market prices as an input.
But it's worth giving it a whirl.

I highly recommend downloading Prof. Shiller's data and playing around with it.
Go here and get the "available for download, Excel file (xls)" link.
Be sure to use the inflation adjusted figures in column J.

Print the post  


When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.