Registered User Joined: 12/1/2004 Posts: 6
|
HI, I AM INTERESTED IN CREATING A PCF FOR FINDING STOCKS THAT CLOSE TODAY ABOVE BB (20,10) UPPER BAND AND CLOSE 2 DAYS AGO IS BELLOW THE BB (20,10). THANK YOU
MANUEL
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following:
C > AVGC20 + 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) AND C2 < AVGC20.2 + 1 * SQR(ABS(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 + C20 ^ 2 + C21 ^ 2 - 20 * AVGC20.2 ^ 2) / 19)
You may wish to review the following:
Modelling Bollinger Bands (& Standard Deviation) in a TC PCF How to create a Personal Criteria Forumula (PCF) Handy PCF example formulas to help you learn the syntax of PCFs! Personal Criteria Language Function List
-Bruce Personal Criteria Formulas TC2000 Support Articles
|