Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Bollinger Bandwidth Formula Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
MoreAces
Posted : Monday, September 2, 2013 10:06:04 AM
Registered User
Joined: 8/23/2013
Posts: 245

Bruce - What is the Built in Formula for Bollinger Bandwidth (what i want to do is copy the basic formula and multiple the plot - what i see on my charts is a big variation of the line movement but the value in most of the range is 0.01 -

 

I wish to multiple the plot so that is plots from 0.00 to maybe 0.15 so that i can scan for movement more precisely

Bruce_L
Posted : Tuesday, September 3, 2013 8:31:59 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Bollinger Bandwidth subtracts the Lower Bollinger Band from the Upper Bollinger Band and divides the result by the centerline of the Bollinger Bands. You would multiply this by 100 to express it as a percentage instead of as a ratio.

An Indicator Formula in the case of Simple Bollinger Bands 20, 2.00 would be:

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) / AVGC20

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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
MoreAces
Posted : Tuesday, September 3, 2013 10:58:08 AM
Registered User
Joined: 8/23/2013
Posts: 245

so replace the 4 * with 100* (at the beginning) or put brackets around the entire thing (xxvzxkvx) * 100

 

 

Bruce_L
Posted : Tuesday, September 3, 2013 11:01:04 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

You can replace the 4 with 400 at the beginning or put brackets around the entire thing and multiply by 100. Either method should work just fine.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
diceman
Posted : Tuesday, September 3, 2013 1:48:25 PM
Registered User
Joined: 1/28/2005
Posts: 6,049

QUOTE (Bruce_L)

An Indicator Formula in the case of Simple Bollinger Bands 20, 2.00 would be:

 

Can I have one for a setting of 5, 1.00.

 

 

Thanks

 

 

Bruce_L
Posted : Tuesday, September 3, 2013 2:07:13 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Please try the following Indicator Formula to replicate Simple Bollinger Bandwidth 5, 1.00:

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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
MoreAces
Posted : Tuesday, September 3, 2013 3:48:45 PM
Registered User
Joined: 8/23/2013
Posts: 245

thanks for all your help bruce

diceman
Posted : Wednesday, September 4, 2013 12:52:59 PM
Registered User
Joined: 1/28/2005
Posts: 6,049

QUOTE (Bruce_L)

Please try the following Indicator Formula to replicate Simple Bollinger Bandwidth 5, 1.00:

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

 

That doesnt match the built in indicator.

 

That being said I asked for the wrong thing.

Actually wanted percent B with setting 5, 1.00.

 

 

Thanks

 

Bruce_L
Posted : Wednesday, September 4, 2013 1:03:23 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Please try the following Indicator Formula to replicate Simple Bollinger Bands %B 5, 1.00:

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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Quiktdr
Posted : Tuesday, November 26, 2013 11:25:18 AM
Registered User
Joined: 10/7/2004
Posts: 794

I have been using AVGC13 - 1.5 * 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 - 13 * AVGC13 ^ 2) / 12)  and if I wanted the 5 1.5 would it be    AVGC5 -1.5 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 - 5  * AVGC5 ^ 2) / 4)           Thank you in advance!

Bruce_L
Posted : Tuesday, November 26, 2013 11:34:38 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

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

Will return the value of the Lower Bollinger Band 5,15 in TC2000 version 7, while:

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

Will return the value of the Lower Bollinger Band 5, 1.50 in TC2000 version 12.3.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Quiktdr
Posted : Tuesday, November 26, 2013 1:15:22 PM
Registered User
Joined: 10/7/2004
Posts: 794

Thank you and Happy Thanksgiving to you and yours!

yurinc
Posted : Saturday, June 7, 2014 9:01:15 PM
Registered User
Joined: 4/19/2013
Posts: 15

saludos, puede hacerlo a través de un PCF mí un oscilador indicando las Bandas de Bollinger diferenciales. gracias

yurinc
Posted : Saturday, June 7, 2014 9:03:13 PM
Registered User
Joined: 4/19/2013
Posts: 15

Greetings, you may do so through a PCF me an oscillator indicating differential Bollinger Bands. thanks

Bruce_L
Posted : Monday, June 9, 2014 12:31:33 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

What are the settings of your Bollinger Bands?

Are you interested in one of the Bollinger Bands in particular?

Are you maybe interested in the Bollinger Bands %B or Bollinger BandWidth indicators instead of the Bollinger Bands themselves?



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
yurinc
Posted : Monday, June 9, 2014 2:14:07 PM
Registered User
Joined: 4/19/2013
Posts: 15

Hi Bruce, I'm interested in the standard bollinger band 20, 2, and get your differential that would come to do by subtracting the upper bollinger band least the lower bollinger band and directed me as an oscillator, thanks for your support

Bruce_L
Posted : Monday, June 9, 2014 2:19:38 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The difference between the upper and lower Bollinger Bands 20, 2.00 can be calculated using the following Indicator Formula:

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)

To plot this as an indicator on the chart in TC2000 version 12.4, select Add Plot to Chart (the green + in the upper left of the chart) and choose Custom PCF Indicator from the list. You can start typing Custom PCF Indicator after selecting Add Plot to Chart to quickly bring it to the top of the list to make it easier to find and select.

Adding and Moving Indicators (7:19)

The click on the Custom PCF Indicator and select Edit. You will then use Indicator Formula given above as the Formula in the Custom PCF Indicator.

This will be similar to the Bollinger BandWidth indicator which is included in the program with the exception of not being divided by the value of centerline of the Bollinger Bands.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
yurinc
Posted : Tuesday, June 10, 2014 11:51:14 AM
Registered User
Joined: 4/19/2013
Posts: 15

Bruce grateful

rickbw
Posted : Wednesday, June 10, 2015 11:29:34 AM
Registered User
Joined: 10/10/2004
Posts: 30

Any chance of   getting the fomula for 30, 3 bandwidth please?  I searched but cannot find one.  Thx

Bruce_L
Posted : Wednesday, June 10, 2015 11:50:25 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

Please try the following Indicator Formula to replicate the simple Bollinger Bandwidth 30,3.00 indicator in TC2000.

6 * 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 + C20 ^ 2 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 - 30 * AVGC30 ^ 2) / 30) / AVGC30



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
rickbw
Posted : Wednesday, June 10, 2015 1:24:24 PM
Registered User
Joined: 10/10/2004
Posts: 30

Bruce, When I load that formula, I get 0.  I tried it on multiple symbols.  Is there a formla for 30,3 upper band?  I could then work with that,  thx for your help

Bruce_L
Posted : Wednesday, June 10, 2015 1:31:05 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The formula will given in my Wednesday, June 10, 2015 11:50:25 AM ET post should always have a value greater than zero unless all of the closing prices in the most recent 30 bars are exactly the same. The value may be small (and may round to 0.00 if displayed with two digits past the decimal for example), but the value should be greater than zero.

An Indicator Formula for the simple Upper Bollinger Band 30, 3.00 can be written as follows.

AVGC30 + 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 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 - 30 * AVGC30 ^ 2) / 30)

An Indicator Formula for the simple Lower Bollinger Band 30, 3.00 can be written as follows.

AVGC30 - 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 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 - 30 * AVGC30 ^ 2) / 30)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.