The Motley Fool Discussion Boards

Previous Page

Investing/Strategies / Mechanical Investing


Subject:  Re: Earnings cycle rate of change Date:  10/8/2012  6:46 PM
Author:  mungofitch Number:  239826 of 271127

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.

Copyright 1996-2018 trademark and the "Fool" logo is a trademark of The Motley Fool, Inc. Contact Us