Formula for Average EPS annual growth over last 2-3 quarters?

Research
1

How do i create a Stock Formula node that represents the Average EPS Annual Growth over last 2-3 quarters
i.e. something like - Average ((EPS0-EPS4), (EPS1-EPS5), (EPS2-EPS6))

If not possible, what’s a close proxy? Just using current EPS Annual Growth doesn’t reflect a consistent 6-9month trend.

thanks
Kirk

2

Your formula will get the absolute change YoY. You get there a lot simpler with the following:

LoopSum(“EPSExclXor(CTR,QTR,ZERONA)-EPSExclXor(CTR+4,ZERONA)”,3,0,1)/3

Which means sum the the YoY changes in earnings for the last 3 periods, starting at 0, and moving in 1 period increments.

… Or you could always go with good old fashioned compound annual percent change over the last 6 quarterly period, stated as:

(EPSExclXor(0,QTR,KEEPNA)/EPSExclXor(5,QTR,ZERONA))^(4/6)-1