Hi all,
One can identify compamies with positive earnings estimate revision using this formula:
CurFYEPSMean/abs(CurFYEPS4WkAgo)
What formula can I use to identify a company with current losses and negative revision, i.e. forecast of widening losses?
How about 2 conditions: CurFYEPSMean < 0 AND CurFYEPSMean < CurFYEPS4WkAgo
To avoid looking at minor changes vs 4 weeks ago, I would try CurFYEPSMean < 1.1 * CurFYEPS4WkAgo
Hi all,
below an example of various sentiments as point-in-time. I choose AVP as example because it should have a broad coverage and it had recent losses.
Joe’s suggestion shows some success, but I found two other parameters that show more variation:
TotRevisions4W
CurFYDnRev4WkAgo
The goal is for my short ranking system to find companies whose losses are widening. I don’t want to confine this to sentiment alone, but to actual financial numbers. There is no negative EPS on p123 as far as I am aware, and only NAs are shown where EPS is missing.
Any other ideas?