Hello Bruce,

I have found the following cci formulas and would like to modify them for weekly timeframe.

What do I change?

Ash

ALSO  ... If I have each one set as a wtchlist column how do I set the sort order for each? Such as col 1 (cci50) highest to lowest THEN col 2 (cci25) hghest to lowest THEN col 3 (cci5)  lowest to HIGHESTvalue.

Note the last column is opposite sort

I have searched but can only see how to sort via one column not

highest value, highest value, lowest value

Ash

Darn ... forgot to post the formula

Cci 5

(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) + .001)

Cci 25

(H + L + C - AVGH25 - AVGL25 - AVGC25) * 2800 / 3 / (ABS(H + L + C - AVGH25 - AVGL25 - AVGC25) + ABS(H1 + L1 + C1 - AVGH25 - AVGL25 - AVGC25) + ABS(H2 + L2 + C2 - AVGH25 - AVGL25 - AVGC25) + ABS(H3 + L3 + C3 - AVGH25 - AVGL25 - AVGC25) + ABS(H4 + L4 + C4 - AVGH25 - AVGL25 - AVGC25) + ABS(H5 + L5 + C5 - AVGH25 - AVGL25 - AVGC25) + ABS(H6 + L6 + C6 - AVGH25 - AVGL25 - AVGC25) + ABS(H7 + L7 + C7 - AVGH25 - AVGL25 - AVGC25) + ABS(H8 + L8 + C8 - AVGH25 - AVGL25 - AVGC25) + ABS(H9 + L9 + C9 - AVGH25 - AVGL25 - AVGC25) + ABS(H10 + L10 + C10 - AVGH25 - AVGL25 - AVGC25) + ABS(H11 + L11 + C11 - AVGH25 - AVGL25 - AVGC25) + ABS(H12 + L12 + C12 - AVGH25 - AVGL25 - AVGC25) + ABS(H13 + L13 + C13 - AVGH25 - AVGL25 - AVGC25) + .000001)

Cci 50

(H + L + C - AVGH50 - AVGL50 - AVGC50) * 2800 / 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) + .000001)

You can change the time frame setting for the formula in TC2000 version 12.4, but there really isn't a good way do to this in TC2000 version 7.

This is because we would need to manually construct the moving averages in the formulas in TC2000 version 7 and these moving averages are repeated many times in the formula.

I'll give you an example of what this would like like for the CCI5, but I cannot provide similar examples for CCI25 and CCI50.

(4 * (MAXH5 + MINL5 + C) - MAXH5.5 - MINL5.5 - C5 - MAXH5.10 - MINL5.10 - C10 - MAXH5.15 - MINL5.15 - C15 - MAXH5.20 - MINL5.20 - C20) * 1000 / 3 / (ABS(4 * (MAXH5 + MINL5 + C) - MAXH5.5 - MINL5.5 - C5 - MAXH5.10 - MINL5.10 - C10 - MAXH5.15 - MINL5.15 - C15 - MAXH5.20 - MINL5.20 - C20) + ABS(4 * (MAXH5.5 + MINL5.5 + C5) - MAXH5 - MINL5 - C - MAXH5.10 - MINL5.10 - C10 - MAXH5.15 - MINL5.15 - C15 - MAXH5.20 - MINL5.20 - C20) + ABS(4 * (MAXH5.10 + MINL5.10 + C10) - MAXH5 - MINL5 - C - MAXH5.5 - MINL5.5 - C5 - MAXH5.15 - MINL5.15 - C15 - MAXH5.20 - MINL5.20 - C20) + ABS(4 * (MAXH5.15 + MINL5.15 + C15) - MAXH5 - MINL5 - C - MAXH5.5 - MINL5.5 - C5 - MAXH5.10 - MINL5.10 - C10 - MAXH5.20 - MINL5.20 - C20) + ABS(4 * (MAXH5.20 + MINL5.20 + C20) - MAXH5 - MINL5 - C - MAXH5.5 - MINL5.5 - C5 - MAXH5.10 - MINL5.10 - C10 - MAXH5.15 - MINL5.15 - C15) + .00001)