| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
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!
|
|
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
|
|
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
|
|
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
|
|
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?
|
|
|
Guest-1 |