Revisions ( number of ) compared to prior periods

Universe = SP 500

NextFYEPSMean > NextFYEPS1WkAgo

Is it possible to compare the Number of Companies within the SP 500
that met the above rule currently,
in comparison to how many met the same rule
4 weeks ago, or any period of the past ?

currently, how many companies have had earnings revisions upward?

4 weeks ago, how many companies have had earnings revisions upward?

if possible, can it then be expressed in a ratio ?

thanks…

You can use P123 Custom Series tool. I created it for you.
Please check out this: SP500_EarningsRev_4W
https://www.portfolio123.com/app/series/summary/2469?mt=8

If shows the percentage of S&P500 companies. If you want the absolute number, use this formula:
UnivCnt(“NextFYEPSMean > NextFYEPS1WkAgo”)

very nice.

thank you !

can this be used in Buy Rules of a simultation

with the Percentage being greater than XX ?

(UnivCnt(“NextFYEPSMean > NextFYEPS1WkAgo”)/UnivCnt(“true”))

thanks…

you can use it this way for example:
Close(0,GetSeries(“SP500_EarningsRev_4W”)) > xxx

Ned, further to your private message:

  1. create a series for every aspect you would like to analyze: For example, if you want to analyze S&P 500 Healthcare, then use S&P 500 in the custom series starting universe. And add further criteria: so the custom series would look like this:
    (UnivCnt(“NextFYEPSMean > NextFYEPS1WkAgo And GICS(35)”/UnivCnt(“GICS(35)”))
    Save with name “SP500_GICS35_EarningsRev_4W+”

  2. In the buy rules, substract the series and set a threshold:
    Close(0,GetSeries(“SP500_GICS35_EarningsRev_4W+”)) -Close(0,GetSeries(“SP500_GICS35_EarningsRev_4W-”)) > xxx
    So basically, if earnings revision upward minus downward exceed a certain threshold, buy.

There are more elegant solutions, like already calculating the difference in the series itself, etc. You need to try out.

GICS Full description here: https://www.portfolio123.com/doc/doc_detail.jsp?factor=GICS&popUpFullDesc=1