I'm using the Coppock Curve on a monthly chart. What I'm need is a pcf % true indicator, that would take the value of the Coppock Curve this month and compare it to the value 2 months ago and return true if the current month was greater than 2 months ago.

Thanks

Please try the following monthly Condition Formula:

10 * (C / C14 + C / C11) + 9 * (C1 / C15 + C1 / C12) > 2 * (C2 / C16 + C2 / C13 + C3 / C17 + C3 / C14 + C4 / C18 + C4 / C15 + C5 / C19 + C5 / C16 + C6 / C20 + C6 / C17 + C7 / C21 + C7 / C18 + C8 / C22 + C8 / C19 + C9 / C23 + C9 / C20 + C10 / C24 + C10 / C21) + C11 / C25 + C11 / C22

Is this the formula for the current month only and if so what would I need to add additionally for it to scan 2 or even 3 months back?

thanks Bruce

No, the Condition Formula is not just for the current month. It has a > sign in he middle which is used to compare the current month to two months ago. The reason the formula is relatively short is that any duplicated terms which were in both months were combined.

The longer version of this formula which has the full calculations for the Coppock Curve during the current bar and for two bars ago could be written as:

100 * (10 * (C / C14 + C / C11) + 9 * (C1 / C15 + C1 / C12) + 8 * (C2 / C16 + C2 / C13) + 7 * (C3 / C17 + C3 / C14) + 6 * (C4 / C18 + C4 / C15) + 5 * (C5 / C19 + C5 / C16) + 4 * (C6 / C20 + C6 / C17) + 3 * (C7 / C21 + C7 / C18) + 2 * (C8 / C22 + C8 / C19) + C9 / C23 + C9 / C20 - 110) / 55 > 100 * (10 * (C2 / C16 + C2 / C13) + 9 * (C3 / C17 + C3 / C14) + 8 * (C4 / C18 + C4 / C15) + 7 * (C5 / C19 + C5 / C16) + 6 * (C6 / C20 + C6 / C17) + 5 * (C7 / C21 + C7 / C18) + 4 * (C8 / C22 + C8 / C19) + 3 * (C9 / C23 + C9 / C20) + 2 * (C10 / C24 + C10 / C21) + C11 / C25 + C11 / C22 - 110) / 55

So to change any number of months back I would just need to change the 2 correct?

3 months back would be

10 * (C / C14 + C / C11) + 9 * (C1 / C15 + C1 / C12) > 3 * (C2 / C16 + C2 / C13 + C3 / C17 + C3 / C14 + C4 / C18 + C4 / C15 + C5 / C19 + C5 / C16 + C6 / C20 + C6 / C17 + C7 / C21 + C7 / C18 + C8 / C22 + C8 / C19 + C9 / C23 + C9 / C20 + C10 / C24 + C10 / C21) + C11 / C25 + C11 / C22

or is the formula more complicated going back further?

It is more complicated than just change the 2 to a 3 in the first formula.

If you want to try and change it on your own, start with the longer formula given in my other post. You would need to change everything after the > sign in the middle of the formula.

This portion represents the current month:

100 * (10 * (C / C14 + C / C11) + 9 * (C1 / C15 + C1 / C12) + 8 * (C2 / C16 + C2 / C13) + 7 * (C3 / C17 + C3 / C14) + 6 * (C4 / C18 + C4 / C15) + 5 * (C5 / C19 + C5 / C16) + 4 * (C6 / C20 + C6 / C17) + 3 * (C7 / C21 + C7 / C18) + 2 * (C8 / C22 + C8 / C19) + C9 / C23 + C9 / C20 - 110) / 55

This portion represents two months ago:

100 * (10 * (C2 / C16 + C2 / C13) + 9 * (C3 / C17 + C3 / C14) + 8 * (C4 / C18 + C4 / C15) + 7 * (C5 / C19 + C5 / C16) + 6 * (C6 / C20 + C6 / C17) + 5 * (C7 / C21 + C7 / C18) + 4 * (C8 / C22 + C8 / C19) + 3 * (C9 / C23 + C9 / C20) + 2 * (C10 / C24 + C10 / C21) + C11 / C25 + C11 / C22 - 110) / 55

See how all the numbers after the Cs in the formula are two greater in the two months ago version than in the current version? This is the bars ago parameter. Everything would need to be 3 greater instead of 2 greater for the second half of the formula to represent 3 bars ago.

100 * (10 * (C / C14 + C / C11) + 9 * (C1 / C15 + C1 / C12) + 8 * (C2 / C16 + C2 / C13) + 7 * (C3 / C17 + C3 / C14) + 6 * (C4 / C18 + C4 / C15) + 5 * (C5 / C19 + C5 / C16) + 4 * (C6 / C20 + C6 / C17) + 3 * (C7 / C21 + C7 / C18) + 2 * (C8 / C22 + C8 / C19) + C9 / C23 + C9 / C20 - 110) / 55 > 100 * (10 * (C3 / C17 + C3 / C14) + 9 * (C4 / C18 + C4 / C15) + 8 * (C5 / C19 + C5 / C16) + 7 * (C6 / C20 + C6 / C17) + 6 * (C7 / C21 + C7 / C18) + 5 * (C8 / C22 + C8 / C19) + 4 * (C9 / C23 + C9 / C20) + 3 * (C10 / C24 + C10 / C21) + 2 * (C11 / C25 + C11 / C22) + C12 / C26 + C12 / C23 - 110) / 55

Thanks so much for your help on this.

You're welcome.