Index | Recent Threads | Who's Online | Search

New Thread
This topic has been viewed 52 times and has 1 reply
kumar
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 cool

Warren Buffett — 'Risk comes from not knowing what you're doing'
'Should you find yourself in a chronically leaking boat, energy devoted to changing vessels is likely to be more productive than energy devoted to patching leaks'

Mar 14, 2019 7:37:22 PM       
SpacemanJones
Re: New Low and New High count and SMA(200) count

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")

Mar 14, 2019 8:08:30 PM