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 Band Width Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
yazz
Posted : Monday, August 20, 2012 6:02:13 PM
Registered User
Joined: 9/20/2010
Posts: 16

How do I create a PCF for:

Number = ((Upper BB Value - Lower BB Value)/(Lower BB Value)) * 100 

 

Thanks

StockGuy
Posted : Tuesday, August 21, 2012 6:27:58 PM

Administration

Joined: 9/30/2004
Posts: 9,187

I don't know the formula but if you add Bollinger Bandwidth to your chart you can click and select "Create Scan Conition" if you want to use in a scan or "Show Values in Watchlist" if you want to use as a sort column.

yazz
Posted : Wednesday, August 22, 2012 12:02:41 PM
Registered User
Joined: 9/20/2010
Posts: 16

I did not communicate clearly about the PCF. What I want is PCF for :

(Upper BB Value - Lower BB Value)/Lower BB Value

 

I appreciate you taking the time,

 

Thanks,

 

Yazz

Bruce_L
Posted : Tuesday, August 28, 2012 8:46:25 AM


Worden Trainer

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

We would need to know the Period and Std Dev settings of your Bollinger Bands to create an Indicator Formula for this. For example, if you have a Period of 20 and a Std Dev of 2.00, the first formula would be:

100 * ((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)) / (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)) - 1)

And the second formula would be:

((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)) / (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)) - 1)

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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
yazz
Posted : Tuesday, August 28, 2012 9:30:47 AM
Registered User
Joined: 9/20/2010
Posts: 16

Bruce,

Thank you for your help.

 

yazz

Bruce_L
Posted : Tuesday, August 28, 2012 10:16:26 AM


Worden Trainer

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

You're welcome.



-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.