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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
Registered User Joined: 8/23/2013 Posts: 245
|
thanks for all your help bruce
|
|
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
|
|
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
|
|
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!
|
|
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
|
|
Registered User Joined: 10/7/2004 Posts: 794
|
Thank you and Happy Thanksgiving to you and yours!
|
|
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
|
|
Registered User Joined: 4/19/2013 Posts: 15
|
Greetings, you may do so through a PCF me an oscillator indicating differential Bollinger Bands. thanks
|
|
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
|
|
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
|
|
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
|
|
Registered User Joined: 4/19/2013 Posts: 15
|
Bruce grateful
|
|
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
|
|
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
|
|
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
|
|
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
|
|
Guest-1 |