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 |

BB (Bolinger Band) 2,3 scans Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
mssharma
Posted : Tuesday, January 13, 2015 4:22:50 PM
Registered User
Joined: 9/25/2008
Posts: 3

Hi

I want to create a scan in which stocks trade past BB 2 or 3 setting (2 or 3 Std deviations). For example I have BB (20,3,0) and BB (20,2,0) and CELG breached BB 3 today at $123 and came back down.

Is is easy to set up scan to do this?

 

And as soon as run the scan, I want to see it real time result. Do I need Platinum for this ?

 

Thanks

Bruce_L
Posted : Tuesday, January 13, 2015 4:33:14 PM


Worden Trainer

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

You will in fact need Platinum in order to have full streaming real time data from the consolidated tape to use for scanning.

A Condition Formula for price being above its Bollinger Bands 20,3.00 at any point during the bar can be written as follows.

H > AVGC20 + 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 - 20 * AVGC20 ^ 2) / 20)

A Condition Formula for price being above its Bollinger Bands 20,3.00 currently can be written as follows.

C > AVGC20 + 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 - 20 * AVGC20 ^ 2) / 20)

A Condition Formula for price being above its Bollinger Bands 20,2.00 at any point during the bar can be written as follows.

H > 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)

A Condition Formula for price being above its Bollinger Bands 20,2.00 currently can be written as follows.

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)

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



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
mssharma
Posted : Tuesday, January 13, 2015 11:34:00 PM
Registered User
Joined: 9/25/2008
Posts: 3

Bruce,

Thanks. Formula is working. I am using current value and flipped the sign and equality to get the BB2 and BB3 (negative side). Easy Scans appear to be working. Tested CELG, TIF, TFM. Will post any question if I need more help.

Bruce_L
Posted : Wednesday, January 14, 2015 9:34:30 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.