| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 5/12/2009
Posts: 13
|
I haven't seen this one posted. I want to make a search for stocks with the CCI 6 day bouncing under the 100 line while the CCI 14 is bouncing up off the 0 line. How would I write that?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
I can write Personal Criteria Formulas for CCI6 and CCI14, but I don't know what you mean by "bouncing under" and "bouncing up" (I need unambiguous objective definitions to be able to help you):
Current CCI6:
(H + L + C - AVGH6 - AVGL6 - AVGC6) * 1200 / 3 / (ABS(H + L + C - AVGH6 - AVGL6 - AVGC6) + ABS(H1 + L1 + C1 - AVGH6 - AVGL6 - AVGC6) + ABS(H2 + L2 + C2 - AVGH6 - AVGL6 - AVGC6) + ABS(H3 + L3 + C3 - AVGH6 - AVGL6 - AVGC6) + ABS(H4 + L4 + C4 - AVGH6 - AVGL6 - AVGC6) + ABS(H5 + L5 + C5 - AVGH6 - AVGL6 - AVGC6) + .000001)
Previous CCI6:
(H1 + L1 + C1 - AVGH6.1 - AVGL6.1 - AVGC6.1) * 1200 / 3 / (ABS(H1 + L1 + C1 - AVGH6.1 - AVGL6.1 - AVGC6.1) + ABS(H2 + L2 + C2 - AVGH6.1 - AVGL6.1 - AVGC6.1) + ABS(H3 + L3 + C3 - AVGH6.1 - AVGL6.1 - AVGC6.1) + ABS(H4 + L4 + C4 - AVGH6.1 - AVGL6.1 - AVGC6.1) + ABS(H5 + L5 + C5 - AVGH6.1 - AVGL6.1 - AVGC6.1) + ABS(H6 + L6 + C6 - AVGH6.1 - AVGL6.1 - AVGC6.1) + .000001)
Current CCI14:
(H + L + C - AVGH14 - AVGL14 - AVGC14) * 2800 / 3 / (ABS(H + L + C - AVGH14 - AVGL14 - AVGC14) + ABS(H1 + L1 + C1 - AVGH14 - AVGL14 - AVGC14) + ABS(H2 + L2 + C2 - AVGH14 - AVGL14 - AVGC14) + ABS(H3 + L3 + C3 - AVGH14 - AVGL14 - AVGC14) + ABS(H4 + L4 + C4 - AVGH14 - AVGL14 - AVGC14) + ABS(H5 + L5 + C5 - AVGH14 - AVGL14 - AVGC14) + ABS(H6 + L6 + C6 - AVGH14 - AVGL14 - AVGC14) + ABS(H7 + L7 + C7 - AVGH14 - AVGL14 - AVGC14) + ABS(H8 + L8 + C8 - AVGH14 - AVGL14 - AVGC14) + ABS(H9 + L9 + C9 - AVGH14 - AVGL14 - AVGC14) + ABS(H10 + L10 + C10 - AVGH14 - AVGL14 - AVGC14) + ABS(H11 + L11 + C11 - AVGH14 - AVGL14 - AVGC14) + ABS(H12 + L12 + C12 - AVGH14 - AVGL14 - AVGC14) + ABS(H13 + L13 + C13 - AVGH14 - AVGL14 - AVGC14) + .000001)
Previous CCI14:
(H1 + L1 + C1 - AVGH14.1 - AVGL14.1 - AVGC14.1) * 2800 / 3 / (ABS(H1 + L1 + C1 - AVGH14.1 - AVGL14.1 - AVGC14.1) + ABS(H2 + L2 + C2 - AVGH14.1 - AVGL14.1 - AVGC14.1) + ABS(H3 + L3 + C3 - AVGH14.1 - AVGL14.1 - AVGC14.1) + ABS(H4 + L4 + C4 - AVGH14.1 - AVGL14.1 - AVGC14.1) + ABS(H5 + L5 + C5 - AVGH14.1 - AVGL14.1 - AVGC14.1) + ABS(H6 + L6 + C6 - AVGH14.1 - AVGL14.1 - AVGC14.1) + ABS(H7 + L7 + C7 - AVGH14.1 - AVGL14.1 - AVGC14.1) + ABS(H8 + L8 + C8 - AVGH14.1 - AVGL14.1 - AVGC14.1) + ABS(H9 + L9 + C9 - AVGH14.1 - AVGL14.1 - AVGC14.1) + ABS(H10 + L10 + C10 - AVGH14.1 - AVGL14.1 - AVGC14.1) + ABS(H11 + L11 + C11 - AVGH14.1 - AVGL14.1 - AVGC14.1) + ABS(H12 + L12 + C12 - AVGH14.1 - AVGL14.1 - AVGC14.1) + ABS(H13 + L13 + C13 - AVGH14.1 - AVGL14.1 - AVGC14.1) + ABS(H14 + L14 + C14 - AVGH14.1 - AVGL14.1 - AVGC14.1) + .000001)
Since you mentioned the zero line, it should probably be noted that you can tell if the CCI is above or below zero without knowing the actual Value because the denominator is never going to be negative. For example, you can check for CCI14 with:
Current CCI14 Above Zero:
H + L + C > AVGH14 + AVGL14 + AVGC14
Current CCI14 Below Zero:
H + L + C < AVGH14 + AVGL14 + AVGC14
Previous CCI14 Above Zero:
H1 + L1 + C1 > AVGH14.1 + AVGL14.1 + AVGC14.1
Previous CCI14 Below Zero:
H1 + L1 + C1 < AVGH14.1 + AVGL14.1 + AVGC14.1
You may wish to review the following:
CCI INDICATOR
How to create a Personal Criteria Forumula (PCF)
Using EasyScan to find stocks that meet your own criteria
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 5/12/2009
Posts: 13
|
The CCI 14 day needs to touch but not go below the 0 and then bounce up the next day.
The CCI 6 needs to have been above the 100 then gone below and on the same day as the above, needs to be back above the 100.
Does that make sense? Not being a code writer I am not sure how to use what you sent. Thanks for any help you can give.
Wayne
|
|
Registered User
Joined: 1/28/2005
Posts: 6,049
|
"I haven't seen this one posted. I want to make a search for stocks with the CCI 6 day bouncing under the 100 line while the CCI 14 is bouncing up off the 0 line. How would I write that?"
"The CCI 14 day needs to touch but not go below the 0 and then bounce up the next day."
The only way something can "touch" is to equal.
Maybe you should think: was above/then below/then above again.
Thanks
diceman
|
|
|
Guest-1 |