| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 2/23/2006
Posts: 20
|
How do I change a PCF for a daily scan to a weekly scan.
Example: This is Bollinger Inside Keltner Today. Can I make it work on Weekly charts?
(AVGH20 + AVGL20 + AVGC20) / 3 + 1.5 * (AVGH20 - AVGL20) > AVGC20 + 2 * SQR(((C - AVGC20) ^ 2 + (C1 - AVGC20) ^ 2 + (C2 - AVGC20) ^ 2 + (C3 - AVGC20) ^ 2 + (C4 - AVGC20) ^ 2 + (C5 - AVGC20) ^ 2 + (C6 - AVGC20) ^ 2 + (C7 - AVGC20) ^ 2 + (C8 - AVGC20) ^ 2 + (C9 - AVGC20) ^ 2 + (C10 - AVGC20) ^ 2 + (C11 - AVGC20) ^ 2 + (C12 - AVGC20) ^ 2 + (C13 - AVGC20) ^ 2 + (C14 - AVGC20) ^ 2 + (C15 - AVGC20) ^ 2 + (C16 - AVGC20) ^ 2 + (C17 - AVGC20) ^ 2 + (C18 - AVGC20) ^ 2 + (C19 - AVGC20) ^ 2) / 19)
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following:
11 * (MAXH5 + MAXH5.5 + MAXH5.10 + MAXH5.15 + MAXH5.20 + MAXH5.25 + MAXH5.30 + MAXH5.35 + MAXH5.40 + MAXH5.45 + MAXH5.50 + MAXH5.55 + MAXH5.60 + MAXH5.65 + MAXH5.70 + MAXH5.75 + MAXH5.80 + MAXH5.85 + MAXH5.90 + MAXH5.95) - 7 * (MINL5 + MINL5.5 + MINL5.10 + MINL5.15 + MINL5.20 + MINL5.25 + MINL5.30 + MINL5.35 + MINL5.40 + MINL5.45 + MINL5.50 + MINL5.55 + MINL5.60 + MINL5.65 + MINL5.70 + MINL5.75 + MINL5.80 + MINL5.85 + MINL5.90 + MINL5.95) - 4 * (C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95) > 240 * SQR(ABS(C ^ 2 + C5 ^ 2 + C10 ^ 2 + C15 ^ 2 + C20 ^ 2 + C25 ^ 2 + C30 ^ 2 + C35 ^ 2 + C40 ^ 2 + C45 ^ 2 + C50 ^ 2 + C55 ^ 2 + C60 ^ 2 + C65 ^ 2 + C70 ^ 2 + C75 ^ 2 + C80 ^ 2 + C85 ^ 2 + C90 ^ 2 + C95 ^ 2 - (C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95) ^ 2 / 20) / 19)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 2/23/2006
Posts: 20
|
It seems to work good, thanks. It looks like you need to change alot to convert a daily PCF to a weekly PCF. This one tells me that the Bollinger was inside the Keltner yesterday and above the Keltner today. Could you please try to convert this to a weekly PCF?
AVGC20) ^ 2 + (C5 - AVGC20) ^ 2 + (C6 - AVGC20) ^ 2 + (C7 - AVGC20) ^ 2 + (C8 - AVGC20) ^ 2 + (C9 - AVGC20) ^ 2 + (C10 - AVGC20) ^ 2 + (C11 - AVGC20) ^ 2 + (C12 - AVGC20) ^ 2 + (C13 - AVGC20) ^ 2 + (C14 - AVGC20) ^ 2 + (C15 - AVGC20) ^ 2 + (C16 - AVGC20) ^ 2 + (C17 - AVGC20) ^ 2 + (C18 - AVGC20) ^ 2 + (C19 - AVGC20) ^ 2) / 19) AND (AVGH20.1 + AVGL20.1 + AVGC20.1) / 3 + 1.5 * (AVGH20.1 - AVGL20.1) > AVGC20.1 + 2 * SQR(((C20 - AVGC20.1) ^ 2 + (C1 - AVGC20.1) ^ 2 + (C2 - AVGC20.1) ^ 2 + (C3 - AVGC20.1) ^ 2 + (C4 - AVGC20.1) ^ 2 + (C5 - AVGC20.1) ^ 2 + (C6 - AVGC20.1) ^ 2 + (C7 - AVGC20.1) ^ 2 + (C8 - AVGC20.1) ^ 2 + (C9 - AVGC20.1) ^ 2 + (C10 - AVGC20.1) ^ 2 + (C11 - AVGC20.1) ^ 2 + (C12 - AVGC20.1) ^ 2 + (C13 - AVGC20.1) ^ 2 + (C14 - AVGC20.1) ^ 2 + (C15 - AVGC20.1) ^ 2 + (C16 - AVGC20.1) ^ 2 + (C17 - AVGC20.1) ^ 2 + (C18 - AVGC20.1) ^ 2 + (C19 - AVGC20.1) ^ 2) / 19)
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Your formula does not seem to be complete, but please try the following:
11 * (MAXH5 + MAXH5.5 + MAXH5.10 + MAXH5.15 + MAXH5.20 + MAXH5.25 + MAXH5.30 + MAXH5.35 + MAXH5.40 + MAXH5.45 + MAXH5.50 + MAXH5.55 + MAXH5.60 + MAXH5.65 + MAXH5.70 + MAXH5.75 + MAXH5.80 + MAXH5.85 + MAXH5.90 + MAXH5.95) - 7 * (MINL5 + MINL5.5 + MINL5.10 + MINL5.15 + MINL5.20 + MINL5.25 + MINL5.30 + MINL5.35 + MINL5.40 + MINL5.45 + MINL5.50 + MINL5.55 + MINL5.60 + MINL5.65 + MINL5.70 + MINL5.75 + MINL5.80 + MINL5.85 + MINL5.90 + MINL5.95) - 4 * (C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95) < 240 * SQR(ABS(C ^ 2 + C5 ^ 2 + C10 ^ 2 + C15 ^ 2 + C20 ^ 2 + C25 ^ 2 + C30 ^ 2 + C35 ^ 2 + C40 ^ 2 + C45 ^ 2 + C50 ^ 2 + C55 ^ 2 + C60 ^ 2 + C65 ^ 2 + C70 ^ 2 + C75 ^ 2 + C80 ^ 2 + C85 ^ 2 + C90 ^ 2 + C95 ^ 2 - (C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95) ^ 2 / 20) / 19) AND 11 * (MAXH5.5 + MAXH5.10 + MAXH5.15 + MAXH5.20 + MAXH5.25 + MAXH5.30 + MAXH5.35 + MAXH5.40 + MAXH5.45 + MAXH5.50 + MAXH5.55 + MAXH5.60 + MAXH5.65 + MAXH5.70 + MAXH5.75 + MAXH5.80 + MAXH5.85 + MAXH5.90 + MAXH5.95 + MAXH5.100) - 7 * (MINL5.5 + MINL5.10 + MINL5.15 + MINL5.20 + MINL5.25 + MINL5.30 + MINL5.35 + MINL5.40 + MINL5.45 + MINL5.50 + MINL5.55 + MINL5.60 + MINL5.65 + MINL5.70 + MINL5.75 + MINL5.80 + MINL5.85 + MINL5.90 + MINL5.95 + MINL5.100) - 4 * (C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100) > 240 * SQR(ABS(C5 ^ 2 + C10 ^ 2 + C15 ^ 2 + C20 ^ 2 + C25 ^ 2 + C30 ^ 2 + C35 ^ 2 + C40 ^ 2 + C45 ^ 2 + C50 ^ 2 + C55 ^ 2 + C60 ^ 2 + C65 ^ 2 + C70 ^ 2 + C75 ^ 2 + C80 ^ 2 + C85 ^ 2 + C90 ^ 2 + C95 ^ 2 + C100 ^ 2 - (C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95 + C100) ^ 2 / 20) / 19)
The basic conversion process involves expanding the Moving Averages and is fairly straightforward, but I re-arranged the original daily formula slightly to reduce the number of Moving Averages and make the resulting weekly formula shorter.
AVGC20 converts to (C + C5 + C10 + C15 + C20 + C25 + C30 + C35 + C40 + C45 + C50 + C55 + C60 + C65 + C70 + C75 + C80 + C85 + C90 + C95) / 20
AVGH20 converts to (MAXH5 + MAXH5.5 + MAXH5.10 + MAXH5.15 + MAXH5.20 + MAXH5.25 + MAXH5.30 + MAXH5.35 + MAXH5.40 + MAXH5.45 + MAXH5.50 + MAXH5.55 + MAXH5.60 + MAXH5.65 + MAXH5.70 + MAXH5.75 + MAXH5.80 + MAXH5.85 + MAXH5.90 + MAXH5.95) / 20
AVGL20 converts to (MINL5 + MINL5.5 + MINL5.10 + MINL5.15 + MINL5.20 + MINL5.25 + MINL5.30 + MINL5.35 + MINL5.40 + MINL5.45 + MINL5.50 + MINL5.55 + MINL5.60 + MINL5.65 + MINL5.70 + MINL5.75 + MINL5.80 + MINL5.85 + MINL5.90 + MINL5.95) / 20
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 2/23/2006
Posts: 20
|
Works good. Thanks for your help!
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 2/23/2006
Posts: 20
|
What is the 11* at the begining of your formula for?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
That's just a result of re-arranging your original daily formula. The basic steps were as follows:
(AVGH20 + AVGL20 + AVGC20) / 3 + 1.5 * (AVGH20 - AVGL20) > AVGC20 + 2 * SQR(((C - AVGC20) ^ 2 + (C1 - AVGC20) ^ 2 + (C2 - AVGC20) ^ 2 + (C3 - AVGC20) ^ 2 + (C4 - AVGC20) ^ 2 + (C5 - AVGC20) ^ 2 + (C6 - AVGC20) ^ 2 + (C7 - AVGC20) ^ 2 + (C8 - AVGC20) ^ 2 + (C9 - AVGC20) ^ 2 + (C10 - AVGC20) ^ 2 + (C11 - AVGC20) ^ 2 + (C12 - AVGC20) ^ 2 + (C13 - AVGC20) ^ 2 + (C14 - AVGC20) ^ 2 + (C15 - AVGC20) ^ 2 + (C16 - AVGC20) ^ 2 + (C17 - AVGC20) ^ 2 + (C18 - AVGC20) ^ 2 + (C19 - AVGC20) ^ 2) / 19)
Combine the AVGC20s in the SD:
(AVGH20 + AVGL20 + AVGC20) / 3 + 1.5 * (AVGH20 - AVGL20) > 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)
Substract AVGC20 from both sides:
(AVGH20 + AVGL20 + AVGC20) / 3 + 1.5 * (AVGH20 - AVGL20) - 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)
Multiply both sides by 120:
40 * (AVGH20 + AVGL20 + AVGC20) + 180 * (AVGH20 - AVGL20) - 120 * AVGC20 > 240 * 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)
Combine similar terms:
220 * AVGH20 - 140 * AVGL20 - 80 * AVGC20 > 240 * 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)
Expand the Moving Averages:
220 * (H + H1 + H2 + H3 + H4 + H5 + H6 + H7 + H8 + H9 + H10 + H11 + H12 + H13 + H14 + H15 + H16 + H17 + H18 + H19) / 20 - 140 * (L + L1 + L2 + L3 + L4 + L5 + L6 + L7 + L8 + L9 + L10 + L11 + L12 + L13 + L14 + L15 + L16 + L17 + L18 + L19) / 20 - 80 * (C + C1 + C2 + C3 + C4 + C5 + C6 + C7 + C8 + C9 + C10 + C11 + C12 + C13 + C14 + C15 + C16 + C17 + C18 + C19) / 20 > 240 * 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 * ((C + C1 + C2 + C3 + C4 + C5 + C6 + C7 + C8 + C9 + C10 + C11 + C12 + C13 + C14 + C15 + C16 + C17 + C18 + C19) / 20)^2) / 19)
Do the division:
11 * (H + H1 + H2 + H3 + H4 + H5 + H6 + H7 + H8 + H9 + H10 + H11 + H12 + H13 + H14 + H15 + H16 + H17 + H18 + H19) - 7 * (L + L1 + L2 + L3 + L4 + L5 + L6 + L7 + L8 + L9 + L10 + L11 + L12 + L13 + L14 + L15 + L16 + L17 + L18 + L19) - 4 * (C + C1 + C2 + C3 + C4 + C5 + C6 + C7 + C8 + C9 + C10 + C11 + C12 + C13 + C14 + C15 + C16 + C17 + C18 + C19) > 240 * 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 - (C + C1 + C2 + C3 + C4 + C5 + C6 + C7 + C8 + C9 + C10 + C11 + C12 + C13 + C14 + C15 + C16 + C17 + C18 + C19) ^ 2 / 20) / 19)
You can now create a weekly formula by making the appropriate weekly substitutions for the daily values (which will give you the formula in my Friday, April 21, 2006 12:11:17 PM post).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |