StockFetcher Forums · Filter Exchange · CCI Filter<< >>Post Follow-up
thambav44
19 posts
msg #158022
Ignore thambav44
11/12/2021 7:02:04 PM

Hello Fellow Traders,
I am looking for a scan code for CCI(14) where CCI(14) was decreasing from around 100 to just below 0 and then popped back above 0. This basically should pull up stocks that reached a high and then a pull back and then starting to climb back up. I am hoping I explained it well. Thanks in advance for your support.

Have a great weekend all!!!!

xarlor
587 posts
msg #158023
Ignore xarlor
11/12/2021 8:12:29 PM

Protip: Always give us a ticker as an example of the pattern you have in mind.

Here's one way to go about it.

Fetcher[
count(cci(14) 5 days ago > 90,20) > 0
count(cci(14) 1 day ago < 0,3) equals 3
cci(14) crossed above 0

draw cci(14) line at 100
]



thambav44
19 posts
msg #158024
Ignore thambav44
11/12/2021 9:28:04 PM

Thank you Xarlor for the code. Ticker example would be QCLN. If you could tweak it to mimic QCLN would greatly appreciate it. Thanks a lot!!!

redversa721
157 posts
msg #158025
Ignore redversa721
11/12/2021 10:57:28 PM

Somehow for me CCI values are different from yahoo charts . so based on the code by Xarlor, maybe that's why the security is not coming up.

On yahoo finance, cci(14) is less than 0 but am on the road and need to dig into this further.

Fetcher[
symlist (QCLN)
/*
count(cci(7) 5 days ago > 90,20) > 0
count(cci(7) 1 day ago < 0,4) equals 4
cci(7) > 0
*/
draw cci(7) line at 0
draw cci(14) line at 0
add column cci(14)
add column cci(14) 1 days ago
add column cci(14) 2 days ago
add column cci(14) 3 days ago
add column cci(14) 4 days ago
add column cci(14) 5 days ago
add column cci(14) 6 days ago
add column cci(7)
add column cci(7) 1 days ago
add column cci(7) 2 days ago
add column cci(7) 3 days ago
add column cci(7) 4 days ago
add column cci(7) 5 days ago
add column cci(7) 6 days ago
]



xarlor
587 posts
msg #158027
Ignore xarlor
modified
11/13/2021 9:17:57 AM

Both Yahoo Charts and ThinkorSwim show the same as SF for QCLN's CCI(14). It does not touch 0. It only goes to 17.5 before bouncing up.

redversa721
157 posts
msg #158029
Ignore redversa721
modified
11/13/2021 11:18:58 AM

Xarlor. Yeah I was just winging it on Yahoo charts and was also drinking at the hotel..you are right I was able to tie up the CCI values between SF and Yahoo charts and they match up.

using CCi(7) I am able to get QCLN in the output based on Xarlors code.

Fetcher[
market is ETF
volume > 300000


count(cci(7) 5 days ago > 90,20) > 0
count(cci(7) 1 day ago < 0,4) >3
cci(7) > 0

draw cci(7) line at 0
draw cci(14) line at 0

add column cci(7)
add column cci(7) 1 days ago
add column cci(7) 2 days ago
add column cci(7) 3 days ago
add column cci(7) 4 days ago
add column cci(7) 5 days ago
add column cci(7) 6 days ago
sort column 1 descending
]



QCLN is on page 2

redversa721
157 posts
msg #158030
Ignore redversa721
11/13/2021 11:25:32 AM

to limit the values further. slight update

Fetcher[

market is ETF
volume > 300000


count(cci(7) 5 days ago > 90,20) > 0
count(cci(7) 1 day ago < 0,4) >3
cci(7) > 0
cci(7) 2 days ago < 0

draw cci(7) line at 0
draw cci(14) line at 0

add column cci(7)
add column cci(7) 1 days ago
add column cci(7) 2 days ago
add column cci(7) 3 days ago
add column cci(7) 4 days ago
add column cci(7) 5 days ago
add column cci(7) 6 days ago
sort column 1 descending
]



Again I feel like this is over fitting to get the required security. but QCLN comes up here when I add a extra line
cci(7) 2 days ago < 0 which displays only 40 something instead of the 137 from previous code.

thambav44
19 posts
msg #158054
Ignore thambav44
11/18/2021 12:43:17 PM

Thank you Xarlor & redversa for your help on this. Much appreciated.

davesaint86
725 posts
msg #158104
Ignore davesaint86
11/23/2021 4:08:29 PM

Thanks.

Fetcher[


apply to apply to symlist(shy,uvxy,mdy,qqq,vgt,fdn,rpv,iwf,tlt,jnk,ief,schb,scz,usmv,efav,spdw,splv,ntsx,swan,uvxy,svxy,uup,gbtc,ethe,pslv,sgol,sh,psq,iwm,iyt,open)
draw ma(18)
draw ema(9)
draw ema(3)

count(cci(7) 5 days ago > 90,20) > 0
count(cci(7) 1 day ago < 0,4) >3
cci(7) > 0
cci(7) 2 days ago < 0

draw cci(7) line at 0
draw cci(14) line at 0

add column cci(7)
add column cci(7) 1 days ago
add column cci(7) 2 days ago
add column cci(7) 3 days ago
add column cci(7) 4 days ago
add column cci(7) 5 days ago
add column cci(7) 6 days ago
sort column 1 descending
]



shillllihs
6,046 posts
msg #158108
Ignore shillllihs
11/24/2021 2:56:44 PM

Pretty nice filter Dave, You can play one day long only ETFs or wait for a several day dip that doesn’t encroach the high and go long. Several seem to rebound. Tmv Erx have potential. I feel like Ethe Gbtc will drop for a month based on my CCI stuff.

StockFetcher Forums · Filter Exchange · CCI Filter<< >>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 2022 - 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


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.