| 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 619 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.
 
 
 
 
 
 | 
| 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.
 
 
 
 
 
 | 
| xarlor 619 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.
 
 
 
 
 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
 
 
 
 
 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 726 posts
 msg #158104
 - Ignore davesaint86
 | 11/23/2021 4:08:29 PM 
 Thanks.
 
 
 
 
 
 | 
| shillllihs 6,101 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.
 
 
 |