Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 3/20/2011 Posts: 25
|
I'm trying to build an Elliott "snapback" indicator; that's when (CCI(50)-CCI(5))>150.
Can you help me build a pcf that measures the dx between CCI(50) and CCI(5), please?
Warm Regards,
John
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The difference between CCI(50) and CCI(5) could be written as:
(H + L + C - AVGH50 - AVGL50 - AVGC50) * 10000 / 3 / (ABS(H + L + C - AVGH50 - AVGL50 - AVGC50) + ABS(H1 + L1 + C1 - AVGH50 - AVGL50 - AVGC50) + ABS(H2 + L2 + C2 - AVGH50 - AVGL50 - AVGC50) + ABS(H3 + L3 + C3 - AVGH50 - AVGL50 - AVGC50) + ABS(H4 + L4 + C4 - AVGH50 - AVGL50 - AVGC50) + ABS(H5 + L5 + C5 - AVGH50 - AVGL50 - AVGC50) + ABS(H6 + L6 + C6 - AVGH50 - AVGL50 - AVGC50) + ABS(H7 + L7 + C7 - AVGH50 - AVGL50 - AVGC50) + ABS(H8 + L8 + C8 - AVGH50 - AVGL50 - AVGC50) + ABS(H9 + L9 + C9 - AVGH50 - AVGL50 - AVGC50) + ABS(H10 + L10 + C10 - AVGH50 - AVGL50 - AVGC50) + ABS(H11 + L11 + C11 - AVGH50 - AVGL50 - AVGC50) + ABS(H12 + L12 + C12 - AVGH50 - AVGL50 - AVGC50) + ABS(H13 + L13 + C13 - AVGH50 - AVGL50 - AVGC50) + ABS(H14 + L14 + C14 - AVGH50 - AVGL50 - AVGC50) + ABS(H15 + L15 + C15 - AVGH50 - AVGL50 - AVGC50) + ABS(H16 + L16 + C16 - AVGH50 - AVGL50 - AVGC50) + ABS(H17 + L17 + C17 - AVGH50 - AVGL50 - AVGC50) + ABS(H18 + L18 + C18 - AVGH50 - AVGL50 - AVGC50) + ABS(H19 + L19 + C19 - AVGH50 - AVGL50 - AVGC50) + ABS(H20 + L20 + C20 - AVGH50 - AVGL50 - AVGC50) + ABS(H21 + L21 + C21 - AVGH50 - AVGL50 - AVGC50) + ABS(H22 + L22 + C22 - AVGH50 - AVGL50 - AVGC50) + ABS(H23 + L23 + C23 - AVGH50 - AVGL50 - AVGC50) + ABS(H24 + L24 + C24 - AVGH50 - AVGL50 - AVGC50) + ABS(H25 + L25 + C25 - AVGH50 - AVGL50 - AVGC50) + ABS(H26 + L26 + C26 - AVGH50 - AVGL50 - AVGC50) + ABS(H27 + L27 + C27 - AVGH50 - AVGL50 - AVGC50) + ABS(H28 + L28 + C28 - AVGH50 - AVGL50 - AVGC50) + ABS(H29 + L29 + C29 - AVGH50 - AVGL50 - AVGC50) + ABS(H30 + L30 + C30 - AVGH50 - AVGL50 - AVGC50) + ABS(H31 + L31 + C31 - AVGH50 - AVGL50 - AVGC50) + ABS(H32 + L32 + C32 - AVGH50 - AVGL50 - AVGC50) + ABS(H33 + L33 + C33 - AVGH50 - AVGL50 - AVGC50) + ABS(H34 + L34 + C34 - AVGH50 - AVGL50 - AVGC50) + ABS(H35 + L35 + C35 - AVGH50 - AVGL50 - AVGC50) + ABS(H36 + L36 + C36 - AVGH50 - AVGL50 - AVGC50) + ABS(H37 + L37 + C37 - AVGH50 - AVGL50 - AVGC50) + ABS(H38 + L38 + C38 - AVGH50 - AVGL50 - AVGC50) + ABS(H39 + L39 + C39 - AVGH50 - AVGL50 - AVGC50) + ABS(H40 + L40 + C40 - AVGH50 - AVGL50 - AVGC50) + ABS(H41 + L41 + C41 - AVGH50 - AVGL50 - AVGC50) + ABS(H42 + L42 + C42 - AVGH50 - AVGL50 - AVGC50) + ABS(H43 + L43 + C43 - AVGH50 - AVGL50 - AVGC50) + ABS(H44 + L44 + C44 - AVGH50 - AVGL50 - AVGC50) + ABS(H45 + L45 + C45 - AVGH50 - AVGL50 - AVGC50) + ABS(H46 + L46 + C46 - AVGH50 - AVGL50 - AVGC50) + ABS(H47 + L47 + C47 - AVGH50 - AVGL50 - AVGC50) + ABS(H48 + L48 + C48 - AVGH50 - AVGL50 - AVGC50) + ABS(H49 + L49 + C49 - AVGH50 - AVGL50 - AVGC50) + .000001) - (H + L + C - AVGH5 - AVGL5 - AVGC5) * 1000 / 3 / (ABS(H + L + C - AVGH5 - AVGL5 - AVGC5) + ABS(H1 + L1 + C1 - AVGH5 - AVGL5 - AVGC5) + ABS(H2 + L2 + C2 - AVGH5 - AVGL5 - AVGC5) + ABS(H3 + L3 + C3 - AVGH5 - AVGL5 - AVGC5) + ABS(H4 + L4 + C4 - AVGH5 - AVGL5 - AVGC5) + .000001)
CCI INDICATOR
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/20/2011 Posts: 25
|
Thanks so much, Bruce, for your prompt reply to my question!
This is such a great service Worden is offering their clients.
|
|
Registered User Joined: 1/3/2010 Posts: 5
|
I would like to use the formula provided in a % True Indicator with the CCI Difference greater than 150.
Adding ">150" to the end of the formula accomplishes this when CCI(5) is less than CCI(50), but does not register a % True indication when CCI(50) is less than CCI(5). Please help me see what I'm missing.
Does TC2000 V.17 allow the formula to be condensed?
Thank you.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
It can be shortened a lot. The big formula above becomes the following.
CCI50 - CCI5
Checking for this being greater than 150:
CCI50 - CCI5 > 150
Checking for this being less than -150:
CCI50 - CCI5 < -150
And checking for the absolute difference between greater than 150 (so either greater than 150 or less than -150):
ABS(CCI50 - CCI5) > 150
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |