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

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

Thanks so much, Bruce, for your prompt reply to my question!

This is such a great service Worden is offering their clients.

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.

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