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 ?
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+”
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.