formula for losses / downward revision

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?