I am  trying to write a PCF condition to duplicate the indicator "Bollinger Band Width". The conditions I am using are  1)  XAVGC6 and 2)  SD of 1.75. The indicator results seem  to be arrived at by dividing the upper BB by the Lower BB giving a result of .o? which seems to be a percent.. The percent  or number that I am looking for would be a number <= .03 which is the number returned by the Bollinger Band Width indicator.  The following is what I have tried but the scan results are not correct. Can you Help?

XAVGC6 + 1.75 * SQR(ABS(C ^ 1.75 +C1 ^ 1.75 + C2 ^ 1.75
+ C3 ^ 1.75 + C4 ^ 1.75 + C5 ^ 1.75   - 6 * XAVGC6 ^ 1.75) / 6)    /
XAVGC6 - 1.75 * SQR(ABS(C ^ 1.75 +C1 ^ 1.75 + C2 ^1.75
+ C3 ^ 1.75 + C4 ^ 1.75 + C5 ^ 1.75  - 6 * XAVGC6 ^ 1.75) / 6)  <= 1.03

Thanks,

Bruce M

Please try the following instead:

3.5 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 - 6 * AVGC6 ^ 2) / 6) / XAVGC6 <= .03

Understanding MACD

Bruce,

Thanks much. That works as I was expecting. Could you tell me what the "2" represents in

C ^ 2 + C1 ^ 2 etc. ?

Regards and Merry Christmas.

Bruce

^ 2 is raising something to the power of two. So C ^ 2 = C * C.

Hello,

I want to have a condition so that the bollinger bands are "X" distance apart. Can you tell me how to simply do this?

In the case of the Bollinger Bands with a period of 6 and a SD setting of 1.75 given above, the actual distance would the first part of the formula:

3.5 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 - 6 * AVGC6 ^ 2) / 6)

Bruce,

   Please provide me with a pcf like the above  for yesterday's bbw ,  with a period of 5, sd of 2 that can be used in v. 12.

Many thanks,

Don

Please try the following.

4 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 - 5 * AVGC5 ^ 2) / 5)

Bruce,

   Thank you very much.

I was thinking for yesterday's BBW the C^2 would be dropped and a C5^2 would be added.

What am I missing here?

Don

You didn't miss anything, I missed the reference to yesterday.

4 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 - 5 * AVGC5.1 ^ 2) / 5)

Circle the date on your calendar; Bruce missed something.

That breeze you feel behind your back is hell freezing over. :)

Bruce,

  Many thanks for your excellent help.

Bruce,

  I cannot reconcile the pcf indicator using

4 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 - 5 * AVGC5 ^ 2) / 5)

for today's bbw with the values the Worden built in indicator set at 5 period , 2 sd, simple  provides.

It seems that using a multiplier of about 1.5 instead of 4 at the front comes close to approximating the values the built in provides.

Thank you for any help.

Don

The built in indicator devides the width by the value of the centerline.

4 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 - 5 * AVGC5 ^ 2) / 5) / AVGC5

But you seemed to specifically be requesting the version without this adjustment based on the formula you provided and the order various formulas were presented in the topic and the discussion which accompanied these formulas.

Bruce,

   Thank you  for clarifying this.

Everything seems to be working well and making sense now.

Don

You're welcome.