StockFetcher Forums · Filter Exchange · Need help with filter please<< >>Post Follow-up
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!



StockFetcher Forums · Filter Exchange · Need help with filter please<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2018 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus