Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

pcf for finding stocks that are OUTSIDE of the bollinger bands Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
barbler
Posted : Monday, June 19, 2006 7:46:37 PM
Registered User
Joined: 2/22/2006
Posts: 29
hi. can you please provide me with the pcf and easy scan for searching for stocks that have reached outside the upper or lower bollinger bands. thanks very much!
barbara
Craig_S
Posted : Monday, June 19, 2006 7:53:29 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
You can always do a channel sort for your bands:

Sort using envelopes, regression channels and Bollinger bands

Or you can build a PCF that is suited to your band settings: Modelling Bollinger Bands (& Standard Deviation) in a TC PCF

- Craig
Here to Help!
Bruce_L
Posted : Monday, June 19, 2006 7:55:42 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
It depends entirely on your Bollinger Band settings. Here's an example Personal Criteria Formula based on a 20-Period Bollinger Band with a 15-Width that can be used as an EasyScan Condition fairly easily:

ABS(C - AVGC20) > 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 + C13^2 + C14^2 + C15^2 + C16^2 + C17^2 + C18^2 + C19^2 - 20 * AVGC20^2) / 19)

You may wish to review the following:

Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
Using EasyScan to find stocks that meet your own criteria
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
barbler
Posted : Tuesday, June 20, 2006 1:16:09 PM
Registered User
Joined: 2/22/2006
Posts: 29
bruce, i am used to using a 20-period with "2 standard deviations". visually when i experiment comparing my investools chart, it seems that if i set it to a 20-width, it matches up. can you explain what the difference between 15 & 20 width would be?
thanks. barbara
Bruce_L
Posted : Tuesday, June 20, 2006 1:18:31 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Please try the following instead:

ABS(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) / 19)

The Width setting was adjusting the Standard Deviation multiplier from 1.5 to 2. Did you get a chance to review the referenced topics and videos? They provide a decent foundation for creating or modifying such formulas on your own (as well as some additional related techniques).

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
barbler
Posted : Tuesday, June 20, 2006 3:42:46 PM
Registered User
Joined: 2/22/2006
Posts: 29
thank you craig and bruce.

craig, the sort in your video works great...but, bruce, can you explain why the second formula you gave me (w/deviation of 2) pulls up just a very few on my watchlist? in other words, i assume the "sort value" are the extremes of outside the upper or lower bollinger bands. is there a way to describe briefly what that extreme is?
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.