| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
 Gold Customer
Joined: 1/28/2005
Posts: 97
|
can you adjust these for me so that they show a maximum of 2 days outside the bollinger band settings, rather than the 1 they are currently identifying?
C > AVGC10 + .8 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * AVGC10 ^ 2) / 9) AND C1 <= AVGC10.1 + .8 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 9)
and
C < AVGC10 - .8 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * AVGC10 ^ 2) / 9) AND C1 >= AVGC10.1 - .8 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 9)
thanks in advance
|
|
Gold Customer
Joined: 1/28/2005
Posts: 97
|
also, can u show me a pcf for the the same bollinger band settings, but the has two consequtive closes within the bollinger bands, on a 1 day, weekly, and monthly chart please.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (financialbillionairemagician) C > AVGC10 + .8 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * AVGC10 ^ 2) / 9) AND C1 <= AVGC10.1 + .8 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 9)
Please try the following instead:
C > AVGC10 + .8 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * AVGC10 ^ 2) / 9) AND C2 <= AVGC10.2 + .8 * SQR(ABS(C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 - 10 * AVGC10.2 ^ 2) / 9)
QUOTE (financialbillionairemagician) C < AVGC10 - .8 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * AVGC10 ^ 2) / 9) AND C1 >= AVGC10.1 - .8 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 9)
Please try the following instead:
C < AVGC10 - .8 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * AVGC10 ^ 2) / 9) AND C2 >= AVGC10.2 - .8 * SQR(ABS(C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 - 10 * AVGC10.2 ^ 2) / 9)
QUOTE (financialbillionairemagician) also, can u show me a pcf for the the same bollinger band settings, but the has two consequtive closes within the bollinger bands, on a 1 day, weekly, and monthly chart please.
Please try the following:
Daily:
ABS(C - AVGC10) <= .8 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 - 10 * AVGC10 ^ 2) / 9) AND ABS(C1 - AVGC10.1) <= AVGC10.1 + .8 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 - 10 * AVGC10.1 ^ 2) / 9)
Weekly:
ABS(C - (C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45) / 10) <= .8 * SQR(ABS(C ^ 2 + C5 ^ 2 + C10 ^ 2 + C15 ^ 2 + C20 ^ 2 + C25 ^ 2 + C30 ^ 2 + C35 ^ 2 + C40 ^ 2 + C45 ^ 2 - 10 * ((C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45) / 10) ^ 2) / 9) AND ABS(C5 - (C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50) / 10) <= .8 * SQR(ABS(C5 ^ 2 + C10 ^ 2 + C15 ^ 2 + C20 ^ 2 + C25 ^ 2 + C30 ^ 2 + C35 ^ 2 + C40 ^ 2 + C45 ^ 2 + C50 ^ 2 - 10 * ((C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50) / 10) ^ 2) / 9)
Monthly:
ABS(C - (C + C21 + C42 + C63 + C84 + C105 + C126 + C147 + C168 + C189) / 10) <= .8 * SQR(ABS(C ^ 2 + C21 ^ 2 + C42 ^ 2 + C63 ^ 2 + C84 ^ 2 + C105 ^ 2 + C126 ^ 2 + C147 ^ 2 + C168 ^ 2 + C189 ^ 2 - 10 * ((C + C21 + C42 + C63 + C84 + C105 + C126 + C147 + C168 + C189) / 10) ^ 2) / 9) AND ABS(C21 - (C21 + C42 + C63 + C84 + C105 + C126 + C147 + C168 + C189 + C210) / 10) <= .8 * SQR(ABS(C21 ^ 2 + C42 ^ 2 + C63 ^ 2 + C84 ^ 2 + C105 ^ 2 + C126 ^ 2 + C147 ^ 2 + C168 ^ 2 + C189 ^ 2 + C210 ^ 2 - 10 * ((C21 + C42 + C63 + C84 + C105 + C126 + C147 + C168 + C189 + C210) / 10) ^ 2) / 9)
You may wish to review the following:
Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |