I am trying to write a screener for stocks that they had cci(20) value below -200 in the last 14 days. I tried the following code, but results are not correct.
C1= CCI[20](typicalPrice)
C2=lowest[14](C1)< -200
SCREENER [C2]
How to fix this?
Thanks.
This will show ALL the stocks whose CCI was below -200 at least once in the last 14 days:
C1= CCI[20](typicalPrice)
C2=summation[14](C1< -200)
SCREENER [C2]
This will show ALL the stocks whose CCI was below -200 at least 5 times in the last 14 days:
C1= CCI[20](typicalPrice)
C2=summation[14](C1< -200) > 4
SCREENER [C2]
This will show ALL the stocks whose CCI was below -200 every day in the last 14 days (which is likely to never happen):
C1= CCI[20](typicalPrice)
C2=summation[14](C1 < -200) = 14
SCREENER [C2]