| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 2/15/2009
Posts: 9
|
what is wrong with the following formula?
PRICE >$5.00
VOLUME>500,000
((AVGC20 + 2 * SQR((20 * (C * C + C1 * C1 + C2 * C2 + C3 * C3 + C4 * C4 + C5 * C5 + C6 * C6 + C7 * C7 + C8 * C8 + C9 * C9 + C10 * C10 + C11 * C11 + C12 * C12 + C13 * C13 + C14 * C14 + C15 * C15 + C16 * C16 + C17 * C17 + C18 * C18 + C19 * C19) - (AVGC20 * 20) * (AVGC20 * 20)) / (20 * 20))) - (AVGC20 - 2 * SQR((20 * (C * C + C1 * C1 + C2 * C2 + C3 * C3 + C4 * C4 + C5 * C5 + C6 * C6 + C7 * C7 + C8 * C8 + C9 * C9 + C10 * C10 + C11 * C11 + C12 * C12 + C13 * C13 + C14 * C14 + C15 * C15 + C16 * C16 + C17 * C17 + C18 * C18 + C19 * C19) - (AVGC20 * 20) * (AVGC20 * 20)) / (20 * 20)))) / AVGC20 <= .06
thanks. MK
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Mostly what would be wrong with the formula is that it isn't a formula. The first two lines look like Scan Conditions while only the portion starting with the third line looks like a Condition Formula:
((AVGC20 + 2 * SQR((20 * (C * C + C1 * C1 + C2 * C2 + C3 * C3 + C4 * C4 + C5 * C5 + C6 * C6 + C7 * C7 + C8 * C8 + C9 * C9 + C10 * C10 + C11 * C11 + C12 * C12 + C13 * C13 + C14 * C14 + C15 * C15 + C16 * C16 + C17 * C17 + C18 * C18 + C19 * C19) - (AVGC20 * 20) * (AVGC20 * 20)) / (20 * 20))) - (AVGC20 - 2 * SQR((20 * (C * C + C1 * C1 + C2 * C2 + C3 * C3 + C4 * C4 + C5 * C5 + C6 * C6 + C7 * C7 + C8 * C8 + C9 * C9 + C10 * C10 + C11 * C11 + C12 * C12 + C13 * C13 + C14 * C14 + C15 * C15 + C16 * C16 + C17 * C17 + C18 * C18 + C19 * C19) - (AVGC20 * 20) * (AVGC20 * 20)) / (20 * 20)))) / AVGC20 <= .06
This seems to work, but it could be shortened quite a bit to:
Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
4 * 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) / 20) / AVGC20 <= .06
The first two lines could be converted into formulas and added to the above as follows in TC2000 version 12 (where volume is reported in actual shares):
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
C > 5 AND V > 500000 AND 4 * 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) / 20) / AVGC20 <= .06
Or in TeleChart as (where volume is reported in blocks of 100 shares):
C > 5 AND V > 5000 AND 4 * 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) / 20) / AVGC20 <= .06
All in all, it would be easier and more efficient in TC2000 version 12 to add Bollinger Bandwidth to the Charts, set the Period to 20, Std Dev to 2 and then click on the BB and select Create Condition | Less Than: .06 to create the Bollinger Band Squeeze Condition. You could then add it to a Scan along with similarly created Conditions for Price and Volume.
Indicators, Sorting & Scanning
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 7/30/2007
Posts: 1,072
|
QUOTE (Bruce_L) Mostly what would be wrong with the formula is that it isn't a formula.
... sounds like a programmer to me!
|
|
|
Guest-1 |