Scanning and ranking by ATR%

tedkirke

I would like to
1 - create a scan of ATR(14) divided by price to show the ATR% of selected stocks in a column in the SUMMARY.
Then I would like to
2 - rank them them by [ATR(14)/close] from HI to LO.....so Utilities would be low at around 2% while juniors and 2x ETF's might be above 5-8%
How do I build than syntax to get it to show the ATR% in a column on the SUMMARY?
I would also like to create (or include) another scan which would show ATR(3) > ATR(14)...to identify upward expansion of volatility.
Bollinger Bands only take the close into account so range expansion prior to rising close prices doesn't get captured.
Thank you kindly.

markd

You can get calculated values only by including a rank by statement. The scan engine returns symbols, not values, so the only way to see those values is by including a rank by statement in the scan. Also note that once you save the symbols to a list, the rank by values are lost.

[group is sp500] // or whatever you want.

rank by [ATR(14)/close]

This seems to work even though the syntax checker says it's not syntactically correct. However, I did not verify the results.

The second scan would go like this, and returns symbols only

[group is sp500]

and [ATR(3) > ATR(14)]