Hi,
I’m trying to get some practice creating formulas.
For the Prebuilt Factor: EPS%ChgPYQ
Is this the correct formula:
(EPSExclXor(0,QTR) - EPSExclXor(4,QTR)) / ABS(EPSExclXor(4,QTR))
Thank you for your help!
Hi,
I’m trying to get some practice creating formulas.
For the Prebuilt Factor: EPS%ChgPYQ
Is this the correct formula:
(EPSExclXor(0,QTR) - EPSExclXor(4,QTR)) / ABS(EPSExclXor(4,QTR))
Thank you for your help!
Yes, that’s correct.
You can improve it a little too, if you’d like. This formula gives extremely high numbers to companies with PYQ EPS close to 0, and if the company’s PYQ EPS is actually 0, the result would be N/A. So the logical improvement is to change the denominator to Max(0.05,Abs(EpsExclXor(4,Qtr))). Or you could use a different minimum EPS in there–whatever you think makes the most sense.
That is a brilliant idea!