Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 3/12/2005 Posts: 123
|
I was hoping you can help with creating a PCF for TC2000 V.7. I would like to create a PCF that has a 5 period bollinger band with a 1 standard deviation (5,1), and identifies when the percent B is 0.1 or less. Thanks
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following:
(C - AVGC5) / 2 / SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 - 5 * AVGC5 ^ 2) / 4) + .5 <= .1
Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/12/2005 Posts: 123
|
Thanks Bruce. The above PCF is identifying many stocks that are greater than .1, even above the upper band of the 5-period bollinger band?
|
|
Registered User Joined: 3/12/2005 Posts: 123
|
Please disregard the above post. I just reinstalled TC2000 due to installing a new operating system and didn't correctly update PCFs. The code you provided works well. If you don't mind, how would I create a scan for %B to be multipe consecutive days below .1, i.e., 4 days in a row? Thanks
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following:
(C - AVGC5) / 2 / SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 - 5 * AVGC5 ^ 2) / 4) + .5 <= .1 AND (C1 - AVGC5.1) / 2 / SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 - 5 * AVGC5.1 ^ 2) / 4) + .5 <= .1 AND (C2 - AVGC5.2) / 2 / SQR(ABS(C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 - 5 * AVGC5.2 ^ 2) / 4) + .5 <= .1 AND (C3 - AVGC5.2) / 2 / SQR(ABS(C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 - 5 * AVGC5.3 ^ 2) / 4) + .5 <= .1
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/12/2005 Posts: 123
|
Thank you!
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |