New Low and New High count and SMA(200) count

P123 Staff/P123 experts,

Please, help

  1. How to get
    a. number of 52 weeks high stocks and
    b. number of 52 weeks low stocks in SP500 universe and Russel 2000 universe.

  2. How to get number of Stocks closed under 200 day moving average Close(0) < SMA(200)
    in SP500 universe and Russel 2000 universe.

Thank you
Kumar :sunglasses:

hi kumar,

Using the Custom Series tool, I think this will give the universe count of the 52 wk high or low in selected universe:
UnivCnt(“Close(0)>=HighVal(252)”)
UnivCnt(“Close(0)<=LowVal(252)”)

I think using this should give the universe percent of stocks below the 200MA
UnivCnt(“close(0)<SMA(200)”)/UnivCnt(“TRUE”)