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 PCF Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Alpha-Man01
Posted : Friday, September 27, 2013 2:15:42 PM
Registered User
Joined: 7/17/2013
Posts: 2

What formula would I use to scan for stocks who's price intersected the lower Bollinger band X number of periods before?

Thanks.

Bruce_L
Posted : Friday, September 27, 2013 2:20:45 PM


Worden Trainer

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

I would need to know the settings of the Bollinger Band and the value of X to help you create such a forrmula. For example, for a Simple Bollinger Band 20,2.00 of 5 bars ago, a Condition Formula could be written as:

ABS(AVGC20.5 - 2 * SQR(ABS(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 - 20 * AVGC20.5 ^ 2) / 20) - (H5 + L5) / 2) <= (H5 - L5) / 2

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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
AlphaMan01
Posted : Monday, September 30, 2013 9:22:25 AM
Registered User
Joined: 6/27/2013
Posts: 4

What if X = 1 (previous period)? How does the formula change?

 

I plan on creating a recent range to scan for using the OR operator. Once I see X=1, I can take it from there. Took a look at your link, but I"m afraid that didn't help. 

Thanks,

Ron

 

 

Bruce_L
Posted : Monday, September 30, 2013 9:26:53 AM


Worden Trainer

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

If X is 1 instead of 5, you would need to subtract 4 from all of the bars ago parameters.

ABS(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) - (H1 + L1) / 2) <= (H1 - L1) / 2



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
AlphaMan01
Posted : Monday, September 30, 2013 1:19:27 PM
Registered User
Joined: 6/27/2013
Posts: 4

Thanks. However, if I can make one small correction to your two formulas. To show where price crosses the lower BB, it should be: ABS(AVGC20.1 - ... not  ABS(AVGC20.1 +... 

The formulas above are for when price crosses the upper BB.

All the best,

Ron

 

Bruce_L
Posted : Monday, September 30, 2013 1:27:01 PM


Worden Trainer

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

Yes, the first operator in the formulas should be a - sign and not a + for the lower band.



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