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

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,

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.

You're welcome.