How do I create a condition that will inform me if a candle forms outside of the bollinger bands for two days in a row?

Thank you for viewing 

What are the complete settings of the Bollinger Bands?

Does the candle need to be completely outside of the Bollinger Bands for both days, close outside of the Bollinger Bands for both days or just have any part ouside the Bollinger Bands for both days?

completely outside of the BB for the two days; open and close outside of the BB

using a 20 2 Bollinger Band

Please try the following Condition Formula if the two bars include the current bar.

(ABS(H - AVGC20) + ABS(L - AVGC20) - ABS(ABS(H - AVGC20) - ABS(L - AVGC20))) / 2 > 2 * 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 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 - 20 * AVGC20 ^ 2) / 20) AND (ABS(H1 - AVGC20.1) + ABS(L1 - AVGC20.1) - ABS(ABS(H1 - AVGC20.1) - ABS(L1 - AVGC20.1))) / 2 > 2 * 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 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 20)

And the following Condition Formula if the two bars exclude the current bar.

(ABS(H1 - AVGC20.1) + ABS(L1 - AVGC20.1) - ABS(ABS(H1 - AVGC20.1) - ABS(L1 - AVGC20.1))) / 2 > 2 * 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 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 20) AND (ABS(H2 - AVGC20.2) + ABS(L2 - AVGC20.2) - ABS(ABS(H2 - AVGC20.2) - ABS(L2 - AVGC20.2))) / 2 > 2 * SQR(ABS(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 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 - 20 * AVGC20.2 ^ 2) / 20)

These formulas check for the entire bar to be outside the Bollinger Bands. If you only need the open and close to be outside the Bollinger Bands, you can replace each instance of H with O and each instance fo L with C instead.

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

Hello Bruce,

Hope you are doing well.I have two questions:

(1) (a.)how do i create a condition that will inform me if a red candlestick closes above the upper bollinger band at an RSI value of 70 and above: conversely when a green candlestick closes below the lower bollinger band at an RSI value of 30 and below? time frame:1min or 5min or 10min or 15min

(2)A formula for 2 consecutive candlestick opening and closing outside the bollinger band for the time frame  1min or 5m or 15min

In both cases the settings of bollinger band is 20,2

There really isn't a way to OR multiple time frames in the same condition or scan. So you would need to have different scans for 1 minute, 5 minute, 10 minute and 15 minute time frames.

A candlestick being red or not depends on your settings. I'm going to guess the color is based on Open vs Close since that is what most candlestick practitioners seem to prefer, but the formula would be different if Color Based On is set to Net Change.

No RSI period was given, so I'm going to guess he period is set to 14. The formula is going to use the plain RSI without Wilder's smoothing. The formula with Wilder's smoothing would be a lot longer.

So with these assumptions and limitations in mind, 1a could be written as follows.

O > C AND C > AVGC20 + 2 * 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 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 - 20 * AVGC20 ^ 2) / 20) AND RSI14 > 70

And 1b could be written as follows.

O < C AND C < AVGC20 - 2 * 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 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 - 20 * AVGC20 ^ 2) / 20) AND RSI14 < 30

And 2 could be written as follows.

ABS(O - AVGC20) + ABS(C - AVGC20) - ABS(ABS(O - AVGC20) - ABS(C - AVGC20)) > 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 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 - 20 * AVGC20 ^ 2) / 20) AND ABS(O1 - AVGC20.1) + ABS(C1 - AVGC20.1) - ABS(ABS(O1 - AVGC20.1) - ABS(C1 - AVGC20.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 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 20)

Thanks bruce.On another issue, the alert I set for the following condition is not firing.

Price history vs bollinger Band  12,3:

"crossing down chan bottom"

"crossing up chan Top"

"Above chan Top"

"Below chan Bottom"

The time frame is 15min.I want an alert that will fire when the price touches or crosses the bollinger band.What should I do.

How do I apply an alert condition to my watchlist?

Also refer me to a resource that contains the synthax for formular writing.

Alert from formular 1a and 1b above are firing before the close of the current period(time frame).Please adjust the formular so that the it fires when the current period ends.

If you want an alert the moment price is first touching or outside of the Bollinger Bands while being completely inside during the previous bar, you could try the following.

(ABS(H - AVGC20) + ABS(L - AVGC20) + ABS(ABS(H - AVGC20) - ABS(L - AVGC20))) / 2 >= 2 * 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 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 - 20 * AVGC20 ^ 2) / 20) AND (ABS(H1 - AVGC20.1) + ABS(L1 - AVGC20.1) + ABS(ABS(H1 - AVGC20.1) - ABS(L1 - AVGC20.1))) / 2 < 2 * 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 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 20)

Waiting until the next bar starts forming for 1a could be written as follows.

O1 > C1 AND C1 > AVGC20.1 + 2 * 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 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 20) AND RSI14.1.1 > 70

And 1b could be written as follows.

O1 < C1 AND C1 < AVGC20.1 - 2 * 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 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 20) AND RSI14.1.1 < 30

The PCF Formula Descriptions topic lists all of the syntax which is valid in the Personal Criteria Formula Language and the Handy PCF example formulas to help you learn the syntax of PCFs! topic has basic examples of this syntax in use.

I'm not quite sure how useful it would be to anybody else, but the Personal Criteria Formulas topic has a list of topics I find useful.

You are generally better off not creating formulas unless absolutely necessary. So I would check out the following videos as well.

Create Conditions from Your Chart (5:25)
Building a Scan with Multiple Conditions (7:29)
Creating Conditions from Your Charts (57:04)
Writing Custom Conditions: The Basics (40:36)
Writing Custom Condtions: Useful Examples (51:30)

Please help me to edit the first formular for bollinger band 12,3 as requested:

(ABS(H - AVGC20) + ABS(L - AVGC20) + ABS(ABS(H - AVGC20) - ABS(L - AVGC20))) / 2 >= 2 * 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 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 - 20 * AVGC20 ^ 2) / 20) AND (ABS(H1 - AVGC20.1) + ABS(L1 - AVGC20.1) + ABS(ABS(H1 - AVGC20.1) - ABS(L1 - AVGC20.1))) / 2 < 2 * 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 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 20)

(ABS(H - AVGC12) + ABS(L - AVGC12) + ABS(ABS(H - AVGC12) - ABS(L - AVGC12))) / 2 >= 3 * 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 ^ 22 - 20 * AVGC12 ^ 2) / 12) AND (ABS(H1 - AVGC12.1) + ABS(L1 - AVGC12.1) + ABS(ABS(H1 - AVGC12.1) - ABS(L1 - AVGC12.1))) / 2 < 3 * 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 - 20 * AVGC12.1 ^ 2) / 12)

Refereing to your post on Monday, April 13, 2015 3:01:44 PM.Please I would like to know at what value the price touches the bollinger band(12,3).Can you write the formula that shows the value in the alert notification?

I can make a formula which returns the value at which this would have triggered, but it could not be used as a condition and wouldn't make an alert return this value.

The following formula assumes price broke the upper Bollinger Band at the upper Bollinger Band or that price broke the upper Bollinger Band at the lower Bollinger Band. It returns this value even if price gapped through the Bollinger Bands. It adds both values together if both the upper and lower Bollinger Bands were broken during the same bar.

ABS((ABS(H1 - AVGC12.1) + ABS(L1 - AVGC12.1) + ABS(ABS(H1 - AVGC12.1) - ABS(L1 - AVGC12.1))) / 2 < 3 * 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 - 12 * AVGC12.1 ^ 2) / 12)) * (ABS(H >= AVGC12 + 3 * 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 - 12 * AVGC12 ^ 2) / 12)) * (AVGC12 + 3 * 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 - 12 * AVGC12 ^ 2) / 12)) + ABS(L <= AVGC12 - 3 * 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 - 12 * AVGC12 ^ 2) / 12)) * (AVGC12 - 3 * 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 - 12 * AVGC12 ^ 2) / 12)))

How do i add the to my chart?

If you want to add it to the chart, you could use the formula as the Formula in a Custom PCF Indicator in the same pane and scale as price.

You would set the Plot Style of the Custom PCF Indicator to Dots and make sure the price indicator is set to calculate scale from price only.

Refering to your post on Friday, April 10, 2015 10:16:42 AM

The (2)  formula is not firing alert.Here I will make my request clearer:

-formula for alert when 2 consecutive bullish candlestick(green) open and close outside the upper  bollinger band 20,2

-formula for alert when 2 consecutive bearish candlestick(red) open and close outside the lower bollinger band 20,2

Please re-write it for me

how do i change the time on the chart to my local time(german time)?

There is no way to change the time frame of the charts in TC2000 to use German time.

The candles being green or red depends on the Color Based On setting of your candlesticks. I'm going to assume you want C > O for green and C < O for red.

Two consecutive candles where the close is above the open and the open is above the top Bollinger Bands 20, 2.00 can be written as follows. Note that this is written so that the it will not trigger until the next bar starts forming so that we know the close of the candle.

C1 > O1 AND O1 > AVGC20.1 + 2 * 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 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 20) AND C2 > O2 AND O2 > AVGC20.2 + 2 * SQR(ABS(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 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 - 20 * AVGC20.2 ^ 2) / 20)

Two consecutive candles where the close is below the open and the open is below the bottom Bollinger Bands 20, 2.00 can be written as follows. The same limitations apply.

C1 < O1 AND O1 < AVGC20.1 - 2 * 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 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 20) AND C2 < O2 AND O2 < AVGC20.2 - 2 * SQR(ABS(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 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 - 20 * AVGC20.2 ^ 2) / 20)

Please write the following formula for me

(1) Alert when a candlestick opens above the bollinger 10,2.The alert should  trigger at the instant of the open.

(2) Alert when a condlestick opens below the bollinger band 10,2. The alert should trgger at the instant of the open

(3) A candlestick(open=O1,high=H1,low=L1,close=C1) have just closed above the bollinger band 10,2. Alert should trigger when the following candlestick opens at and above the high(H1) of the previous candlestick.

(4) A candlestick(open=O1,high=H1,low=L1,close=C1) have just closed below the bollinger band 10,2. Alert should trigger when the following candlestick opens at and below the low(L1) of the previous candlestick.

O  > (9 * AVGC9.1 + O) / 10 + 2 * SQR(ABS(O ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * ((9 * AVGC9.1 + O) / 10) ^ 2) / 10)

O  < (9 * AVGC9.1 + O) / 10 - 2 * SQR(ABS(O ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * ((9 * AVGC9.1 + O) / 10) ^ 2) / 10)

O >= H1 AND L1 > AVGC10.1 + 2 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 10)

O <= L1 AND H1 < AVGC10.1 - 2 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 10)

For (3), L1 can be inside or outside the bollinger band:there should not be any resrtiction on it.C1 must be above the upper bollinger band and O>=H1

For (4),H1 can be inside or outside the bollinger band: there should not be any restriction on it.C1 must be below the lower bollinger band and  O<=L1

Please check to see that these conditions are met in the formulas

Here I thought you had been pretty specific when you listed O1, H1, L1 and C1 in the question and that the closed part just meant the candlestick had closed, not that you were interested in the close of the candlestick. So no, the second two formulas do not check for the close of the candlestick to be above or below the Bollinger Bands, they check for the candlestick to be above or below the Bollinger Bands at the close.

Altering those formulas to what I hope is now the correct interpretation results in the following instead.

O >= H1 AND C1 > AVGC10.1 + 2 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 10)

O <= L1 AND C1 < AVGC10.1 - 2 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 10)

Please write a single indicator formula that will show the following:

(1) the minimum price at which %B >1 for a timeframe.That means at the open of a timeframe,the indicator will show this price and should be constant for that timeframe.The price may or may not get to that minimum price before the timeframe runs out.The same process will be repeated from one timeframe to another

(2)  the maximum price at which %B < 0  for a timeframe.That means at the open of a timeframe,the indicator will show this price and should be constant for that timeframe.The price may or may not get to that maximum  price before the timeframe runs out.The same process will be repeated from one timeframe to another.

Also brief me on how install the indicator.

I refer to my post on Thursday, May 28, 2015 11:03:48 AM, please repeat (1) and (2) for

Bollinger band 10,3

O  > (9 * AVGC9.1 + O) / 10 + 2 * SQR(ABS(O ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * ((9 * AVGC9.1 + O) / 10) ^ 2) / 10)

O  < (9 * AVGC9.1 + O) / 10 - 2 * SQR(ABS(O ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * ((9 * AVGC9.1 + O) / 10) ^ 2) / 10)

The two formulars above are giving false alert.They give alert inside the bollinger band.please correct them

O >= H1 AND C1 > AVGC10.1 + 2 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 10)

O <= L1 AND C1 < AVGC10.1 - 2 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 10)

The two formulars give false alert.They send out alert when C1 is inside the bollinger band and the

conditions O >= H1 and O <= L1 are not obeyed.Please correct the formular

I'm going to try and see why you think some of the previous formulas are wrong before getting to the new requests. Because if my previous interpretations of your requests are not in line with your expectations, then using the same interpretations for subsequent requests would probably not meet your expectations either.

So let's start with:

O > (9 * AVGC9.1 + O) / 10 + 2 * SQR(ABS(O ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * ((9 * AVGC9.1 + O) / 10) ^ 2) / 10)

For opening above the simple Bollinger Bands 10, 2.00. It should be noted that the above formula takes into account where the Bollinger Bands were at the open of the bar. A naive interpretation of the request would compare the open to where the Bollinger Bands end up at the end of the bar.

O > AVGC10 + 2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * AVGC10 ^ 2) / 10)

But just because the open ends up above the Bollinger Bands after the bar is closed doesn't mean they were actually above the Bollinger Bands at the open of the bar. Both the centerline and the width of the channels can be different at the beginning of the bar than at the end of the bar. In fact, the only time they would both be exactly the same is when the open and close are exactly equal.

You can plot a Custom PCF Channel Indicator with the following settings to see what the Bollinger Bands were at the open of the bar instead of the close of the bar.

- Period: 1
- Average Type: Doesn't matter (because the Period is 1).
- Width Multiplier: Match the Std Dev setting in the Bollinger Bands indicator.
- Indicator Line Formula: (9 * AVGC9.1 + O) / 10
- Channel Width Formula: SQR(ABS(O ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * ((9 * AVGC9.1 + O) / 10) ^ 2) / 10)

If this does not appear to resolve or explain what you are seeing as incorrect results noted in your Monday, June 01, 2015 1:22:18 AM ET post, then please provide some specific examples so I can take look.

Once we have that resolved, we can move onto the issues you mention in your Monday, June 01, 2015 1:30:13 AM ET post.

Alert just triggered with the following result from the PCF channel indicator you gave:

Indicator line formula=189,73

The channel width formula=0,04

Open price 189,667(GBP/JPY at 4:30 01.06.2015)

You are right Bruce.But at the time of alert the price was inside the bollinger band when I looked at the chart.The indicator has proved that the formular is right.I think we can move to the next one

OK, let's look at this one next.

O >= H1 AND C1 > AVGC10.1 + 2 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 10)

The first part is pretty straightforward.

O >= H1

It is just checking for the open of the current bar being at or above the high of the previous bar. So it would be a little confusing to me if you are getting results where the open of the current bar is below the high of the previous bar.

The next part is a bit more complicated because the formula for the simple upper Bollinger Band 10, 2.00 is a bit complicated, but the actual comparison is fairly simple. C1 is the close of the previous bar. AVGC10.1 is the centerline at the end of the previous bar. And 2 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 10) is half the width of the Bollinger Band at the end of the previous bar(and is added to the centerline to get the upper Bollinger Band).

So the following should be checking for the close being above the simple upper Bollinger Band 10,2.00 at the close of the previous bar.

C1 > AVGC10.1 + 2 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 10)

At this point my best guess as to why this wouldn't work would be something like a incorrect time frame, a copy and paste issue of some sort or the formula getting edited after it was used.

Try re-creating the Condition Formula. Make sure the time frame of the Condition Formula matches the charts. Then delete it and re-add it where you are using the formula. You need to do this because editing a formula will not change where it is already in use. This is because when you use a formula, you are making a copy which is not linked to the original in any way.

I think it should be a copy and paste issue.The center line in my formula is AVGC20.1. I don't know how that could have happened during copying and pasting.

I will delete and re-add as you said.I think that should resolve the problem.Thank you.We can progress to my next request.

O  > (9 * AVGC9.1 + O) / 10 + 3 * SQR(ABS(O ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * ((9 * AVGC9.1 + O) / 10) ^ 2) / 10)

O  < (9 * AVGC9.1 + O) / 10 - 3 * SQR(ABS(O ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * ((9 * AVGC9.1 + O) / 10) ^ 2) / 10)

O >= H1 AND L1 > AVGC10.1 + 3 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 10)

O <= L1 AND H1 < AVGC10.1 - 3 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 10)

AVGC9.1 + 2 * (SQR(2) * SQR((C1 - AVGC9.1) ^ 2 + (C2 - AVGC9.1) ^ 2 + (C3 - AVGC9.1) ^ 2 + (C4 - AVGC9.1) ^ 2 + (C5 - AVGC9.1) ^ 2 + (C6 - AVGC9.1) ^ 2 + (C7 - AVGC9.1) ^ 2 + (C8 - AVGC9.1) ^ 2 + (C9 - AVGC9.1) ^ 2)) / 3

AVGC9.1 - 2 * (SQR(2) * SQR((C1 - AVGC9.1) ^ 2 + (C2 - AVGC9.1) ^ 2 + (C3 - AVGC9.1) ^ 2 + (C4 - AVGC9.1) ^ 2 + (C5 - AVGC9.1) ^ 2 + (C6 - AVGC9.1) ^ 2 + (C7 - AVGC9.1) ^ 2 + (C8 - AVGC9.1) ^ 2 + (C9 - AVGC9.1) ^ 2)) / 3

Click on the symbol in green at the top of the pane where price is plotted and select Add Plot Here.... Then choose Custom PCF Indicator from the list and use one of the formulas given above as the Formula.

An alternative to this would be to select Add Plot to Chart and choose Custom PCF Channel Indicator from the list. Then edit it to use the following settings.

- Period: 1
- Width Multiplier: 1
- Indicator Line Formula: AVGC9.1
- Channel Width Formula: 2 * (SQR(2) * SQR((C1 - AVGC9.1) ^ 2 + (C2 - AVGC9.1) ^ 2 + (C3 - AVGC9.1) ^ 2 + (C4 - AVGC9.1) ^ 2 + (C5 - AVGC9.1) ^ 2 + (C6 - AVGC9.1) ^ 2 + (C7 - AVGC9.1) ^ 2 + (C8 - AVGC9.1) ^ 2 + (C9 - AVGC9.1) ^ 2)) / 3

Please edit your post on Tuesday, June 02, 2015 1:20:50 PM using the bollinger band 10,3. Sorry to

border you  with my much request.I will take pause after this.

This is going to sound a bit strange, but while I can create a formula for the Bollinger Band 10,3 case, I think it requires the 9 closing prices prior to the current bar to all have the same price for the new price to exactly hit Bollinger Band 10,3 and have either a 1.00 or 0.00 Bollinger Band %B result.

It also seems as if the 9 closing prices prior to the current bar all have the same price, then any price above or below the calculated values will have a value of either 1.00 or 0.00. Price cannot exceed 3 standard deviations from the centerline when the 9 closing prices prior to the current bar all have the same price because the standard deviation line will just get further away from the centerline so it stays equal to price.

Then again, my math could just be wrong as this seems like a rather odd result.

Select Add Plot to Chart and choose Custom PCF Channel Indicator from the list. Then edit it to use the following settings.

- Period: 1
- Width Multiplier: 1
- Indicator Line Formula: AVGC9.1
- Channel Width Formula: (SQR(10) * SQR((C1 - AVGC9.1) ^ 2 + (C2 - AVGC9.1) ^ 2 + (C3 - AVGC9.1) ^ 2 + (C4 - AVGC9.1) ^ 2 + (C5 - AVGC9.1) ^ 2 + (C6 - AVGC9.1) ^ 2 + (C7 - AVGC9.1) ^ 2 + (C8 - AVGC9.1) ^ 2 + (C9 - AVGC9.1) ^ 2)) / 3

sorry to come back so soon.Your post on Wednesday, June 03, 2015 11:17:08 AM gives some concern.The thing is i am a binary option  trader and I like to trade on pullbacks.I will be trading the Non-Farm-Payroll tomorrow.

Back to your post.For the bollinger band 10, what is the highest standard deviation that the price can exceed? please edit your post on Wednesday, June 03, 2015 11:17:08 AM for that standard deviation. I want to take risk as from that point.

If you know a more reliable formular for pullback, please let me know

I cannot find anything mathematically that would prevent price from exceeding 3 Bollinger Bands in general. The only strange thing is in hitting 3 standard devations exactly.

Hitting 3 Bollinger Bands exactly seems to require AVGC9.1 ^ 2 = C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2. This only seems possible when price has closed at exactly the same value for the previous 9 bars.

The other thing is that the solution in this case seems to result in a value of 3 standard deviations no matter how far above or below the maximum or minimum value required to hit 3 standard deviations price goes. Every real number meeting those qualifications would appear to make price be at exactly 3 standard deviations.

This does not mean price cannot hit 4 standard deviations. It just means it can't do so when AVGC9.1 ^ 2 = C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2. The settings of a Custom PCF Channel Indicator for 4 standard deviations would be as follows.

- Period: 1
- Width Multiplier: 1
- Indicator Line Formula: AVGC9.1
- Channel Width Formula: (4 * SQR(70) * SQR((C1 - AVGC9.1) ^ 2 + (C2 - AVGC9.1) ^ 2 + (C3 - AVGC9.1) ^ 2 + (C4 - AVGC9.1) ^ 2 + (C5 - AVGC9.1) ^ 2 + (C6 - AVGC9.1) ^ 2 + (C7 - AVGC9.1) ^ 2 + (C8 - AVGC9.1) ^ 2 + (C9 - AVGC9.1) ^ 2)) / 21

All of the above assumes my math is right in the first place and 3 SD for 10-period Bollinger Bands actually does have these strange properties.

I refer to your post on  Monday, June 01, 2015 12:15:20 PM.Please edit the Custom PCF Channel Indicator  settings to bollinger band 10,3 

The Tuesday, June 02, 2015 11:38:08 AM ET post already has those formulas.