Hello Bruce,

I need some help to create PCFs for BB%B 15 2 that are crossing up 1 and crossing down 0 in vules. Your help is greatly appreicated.

Gary

A Condition Formula for a Simple Bollinger Band %B 15, 2.00 crossing up through 1 can be written as:

(C - AVGC15) / 4 / SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 - 15 * AVGC15 ^ 2) / 15) + .5 > 1 AND (C1 - AVGC15.1) / 4 / SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 - 15 * AVGC15.1 ^ 2) / 15) + .5 <= 1

A Condition Formula for a Simple Bollinger Band %B 15, 2.00 crossing down through 0 can be written as:

(C - AVGC15) / 4 / SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 - 15 * AVGC15 ^ 2) / 15) + .5 < 0 AND (C1 - AVGC15.1) / 4 / SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 - 15 * AVGC15.1 ^ 2) / 15) + .5 >= 0

Modelling Bollinger Bands (& Standard Deviation) in a TC PCF

That said, there is a much easier way to do this in TC2000 version 12.4. Add the Bollinger Band %B indicator to the chart and adjust its settings as desired.

Adding and Moving Indicators

Then click on the Bollinger Band %B indicator and select Create Scan Condition. You would choose Crossing Up Value or Crossing Down Value and set the Crossing Through value to either 1 or 0 depending on what you want.

Create Conditions from Your Chart

Thanks Bruce. It works.

Happy New Year!

You're welcome. Happy New Year!