| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 11/13/2004
Posts: 121
|
Would anyone be able to help create PCFs for the following Bollinger confirmed breakout scan? (Bands defaulting to a period of 20 and 2 standard deviations? Any help much appreciated.
Day 1: Bandwidth within 25% of Lowest bandwidth in 6 months AND Close Inside the bands
Day 2: Close above the upper band
Day 3: Close above Day 2's Close
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
While we could do this using RealCode in StockFinder (Real Code for Bollinger Bandwidth low points), it is absolutely not happening in the current version of TeleChart.
We can do:
Day 1: Close Inside the bands
Day 2: Close above the upper band
Day 3: Close above Day 2's Close
C > C1 AND C1 > AVGC20.1 + 2 * SQR(ABS(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 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 19) AND ABS(C2 - AVGC20.2) <= 2 * 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)
But bandwidth within 25% of lowest bandwidth in 6 months results in a Personal Criteria Formula that is way to long to be practical.
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
|
|
Registered User
Joined: 11/13/2004
Posts: 121
|
Thank you so much. This is very helpful. Could I impose on you to create a PCF now that would do the following:
Day 1: Close Inside the bands
Day 2: Close above the upper band
This would allow for catching potential breakouts before being confirmed on Day 3. Any help much appreciated.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
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) AND ABS(C1 - AVGC20.1) <= 2 * SQR(ABS(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 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 19)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 11/13/2004
Posts: 121
|
Thank you so much.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/2/2004
Posts: 1,775
|
QUOTE (Bruce_L) 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) AND ABS(C1 - AVGC20.1) <= 2 * SQR(ABS(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 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 19)
Bruce, I tried to add the formula to my PCFs list twice and each time after I clicked the test button after first copying and pasting the formula above I got a Syntax Error message, TC2007. thanks.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
fpetry,
Please try copying and pasting it again. It doesn't have any syntax errors. I even copied and pasted it from your post instead of the original post and still didn't receive any errors.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 12/2/2004
Posts: 1,775
|
QUOTE (Bruce_L) fpetry,
Please try copying and pasting it again. It doesn't have any syntax errors. I even copied and pasted it from your post instead of the original post and still didn't receive any errors.
Well jeez, it worked this time... I also copied and pasted from my post above. Possible that when I copied twice before that I missed a character or included something extra. Whatever, thank you very much for the PCF and follow up Bruce!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |