I am using this CCI formula for calculating 14 day CCI for today.

(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)

How do I get the 14 day CCI for previous day?

Thx,

B

You need to add 1 to all of the bars ago parameters:

(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)

Thanks for the quick response Bruce. Appreciate it. I just tried it and worked like a charm. Thank you again.

WOuld the following be the formula for CCI 7. I tried it but the values don't seem to match.

(H + L + C - AVGH7 - AVGL7 - AVGC7) * 2800 / 3 / (ABS(H + L + C - AVGH7 - AVGL7 - AVGC7) + ABS(H1 + L1 + C1 - AVGH7 - AVGL7 - AVGC7) + ABS(H2 + L2 + C2 - AVGH7 - AVGL7 - AVGC7) + ABS(H3 + L3 + C3 - AVGH7 - AVGL7 - AVGC7) + ABS(H4 + L4 + C4 - AVGH7 - AVGL7 - AVGC7) + ABS(H5 + L5 + C5 - AVGH7 - AVGL7 - AVGC7) + ABS(H6 + L6 + C6 - AVGH7 - AVGL7 - AVGC7) + .000001)

May be something wrong with the number 2800 / 3 ?

Your are correct in that 2800 / 3 is the issue. It needs to be period * 200 / 3. So the actual formula would be:

(H + L + C - AVGH7 - AVGL7 - AVGC7) * 1400 / 3 / (ABS(H + L + C - AVGH7 - AVGL7 - AVGC7) + ABS(H1 + L1 + C1 - AVGH7 - AVGL7 - AVGC7) + ABS(H2 + L2 + C2 - AVGH7 - AVGL7 - AVGC7) + ABS(H3 + L3 + C3 - AVGH7 - AVGL7 - AVGC7) + ABS(H4 + L4 + C4 - AVGH7 - AVGL7 - AVGC7) + ABS(H5 + L5 + C5 - AVGH7 - AVGL7 - AVGC7) + ABS(H6 + L6 + C6 - AVGH7 - AVGL7 - AVGC7) + .000001)

Hello,

I need a PCF for the CCI 6 hitting bottom and then rising for 2 days

Kurt

A Condition Formula for CCI6 increasing during the two most recent bars but decreasing two bars ago could be written as:

(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) > (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) AND (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) > (H2 + L2 + C2 - AVGH6.2 - AVGL6.2 - AVGC6.2) * 1200 / 3 / (ABS(H2 + L2 + C2 - AVGH6.2 - AVGL6.2 - AVGC6.2) + ABS(H3 + L3 + C3 - AVGH6.2 - AVGL6.2 - AVGC6.2) + ABS(H4 + L4 + C4 - AVGH6.2 - AVGL6.2 - AVGC6.2) + ABS(H5 + L5 + C5 - AVGH6.2 - AVGL6.2 - AVGC6.2) + ABS(H6 + L6 + C6 - AVGH6.2 - AVGL6.2 - AVGC6.2) + ABS(H7 + L7 + C7 - AVGH6.2 - AVGL6.2 - AVGC6.2) + .000001) AND (H2 + L2 + C2 - AVGH6.2 - AVGL6.2 - AVGC6.2) * 1200 / 3 / (ABS(H2 + L2 + C2 - AVGH6.2 - AVGL6.2 - AVGC6.2) + ABS(H3 + L3 + C3 - AVGH6.2 - AVGL6.2 - AVGC6.2) + ABS(H4 + L4 + C4 - AVGH6.2 - AVGL6.2 - AVGC6.2) + ABS(H5 + L5 + C5 - AVGH6.2 - AVGL6.2 - AVGC6.2) + ABS(H6 + L6 + C6 - AVGH6.2 - AVGL6.2 - AVGC6.2) + ABS(H7 + L7 + C7 - AVGH6.2 - AVGL6.2 - AVGC6.2) + .000001) <(H3 + L3 + C3 - AVGH6.3 - AVGL6.3 - AVGC6.3) * 1200 / 3 / (ABS(H3 + L3 + C3 - AVGH6.3 - AVGL6.3 - AVGC6.3) + ABS(H4 + L4 + C4 - AVGH6.3 - AVGL6.3 - AVGC6.3) + ABS(H5 + L5 + C5 - AVGH6.3 - AVGL6.3 - AVGC6.3) + ABS(H6 + L6 + C6 - AVGH6.3 - AVGL6.3 - AVGC6.3) + ABS(H7 + L7 + C7 - AVGH6.3 - AVGL6.3 - AVGC6.3) + ABS(H8 + L8 + C8 - AVGH6.3 - AVGL6.3 - AVGC6.3) + .000001)

Thanks Bruce

You're welcome.