selfhigh05 23 posts msg #135873 - Ignore selfhigh05 |
5/12/2017 4:18:29 PM
Should be easy but I can't figure out how to get it to work. I want to put in a column if a stock crossed above CCI(20) -100
I can do a filter with and CCI(20) crossed above -100 but I dont want to filter the results based on that I just want to know if that criteria was meet and put that in a column. That way when I am looking at my filter results and I see a 1 in the CrossedCCI-100 column I know it just did. Best case would be just an True or False or just an X if true. Any help would be appreciated.
|
four 5,087 posts msg #135874 - Ignore four modified |
5/12/2017 4:48:34 PM
/* I want to put in a column if a stock crossed above CCI(20) -100 */
set{cnt, count(cci(20) crossed above -100,1)}
add column cnt /*0 = no, 1 = yes*/
sort column 5 descending /* sort stocks showing cross 1st */
|
selfhigh05 23 posts msg #135876 - Ignore selfhigh05 |
5/12/2017 6:18:24 PM
thanks!, its fitting that I am using in on a modified TRO 5% filter, thanks!
|