Using Forward And Trailing 4-Quarter S&P 500 Earnings Data

 | Oct 21, 2018 12:26AM ET

The above link is a new spreadsheet comparing the “4-quarter trailing” S&P 500 earnings yield and the “forward 4-quarter” S&P 500 earnings yield.

Readers have asked about the 4-quarter trailing S&P 500 EPS earnings yield, but the time was never taken to build and compare the data.

The goal of the comparison was to see if there were any periods where the trailing or forward yields would indicate a “tell” for the S&P 500, possibly for overvaluation purposes or for market direction.

Table 3 calculates the difference between the two earnings yields.

To further complicate the issue, here is Ed Yardeni’s “S&P 500 Earnings Yield” Chart from 10/11/18. (Readers have asked for a chart too.)