Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 12/12/2004 Posts: 60
|
IS there a pcf for the 20day , 50day and a 10day moving average in a up trend for 26 weeks thanks
|
|
Registered User Joined: 12/12/2004 Posts: 60
|
Is there a pcf for the 20 day ,200 day ,50 day and 10 day moving average in a up trend for 26 weeks
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following Condition Formula. It checks for the linear regression slope to be positive for all four moving averages over the last 26 weeks withthe current moving average being at the high over those 26 weeks.
How to create and save a Condition (PCF) Formula
25 * (AVGC10 - AVGC10.125) + 23 * (AVGC10.5 - AVGC10.120) + 21 * (AVGC10.10 - AVGC10.115) + 19 * (AVGC10.15 - AVGC10.110) + 17 * (AVGC10.20 - AVGC10.105) + 15 * (AVGC10.25 - AVGC10.100) + 13 * (AVGC10.30 - AVGC10.95) + 11 * (AVGC10.35 - AVGC10.90) + 9 * (AVGC10.40 - AVGC10.85) + 7 * (AVGC10.45 - AVGC10.80) + 5 * (AVGC10.50 - AVGC10.75) + 3 * (AVGC10.55 - AVGC10.70) + AVGC10.60 > AVGC10.65 AND AVGC10 = MAX(AVGC10,126) AND 25 * (AVGC20 - AVGC20.125) + 23 * (AVGC20.5 - AVGC20.120) + 21 * (AVGC20.10 - AVGC20.115) + 19 * (AVGC20.15 - AVGC20.110) + 17 * (AVGC20.20 - AVGC20.105) + 15 * (AVGC20.25 - AVGC20.100) + 13 * (AVGC20.30 - AVGC20.95) + 11 * (AVGC20.35 - AVGC20.90) + 9 * (AVGC20.40 - AVGC20.85) + 7 * (AVGC20.45 - AVGC20.80) + 5 * (AVGC20.50 - AVGC20.75) + 3 * (AVGC20.55 - AVGC20.70) + AVGC20.60 > AVGC20.65 AND AVGC20 = MAX(AVGC20,126) AND 25 * (AVGC50 - AVGC50.125) + 23 * (AVGC50.5 - AVGC50.120) + 21 * (AVGC50.10 - AVGC50.115) + 19 * (AVGC50.15 - AVGC50.110) + 17 * (AVGC50.20 - AVGC50.105) + 15 * (AVGC50.25 - AVGC50.100) + 13 * (AVGC50.30 - AVGC50.95) + 11 * (AVGC50.35 - AVGC50.90) + 9 * (AVGC50.40 - AVGC50.85) + 7 * (AVGC50.45 - AVGC50.80) + 5 * (AVGC50.50 - AVGC50.75) + 3 * (AVGC50.55 - AVGC50.70) + AVGC50.60 > AVGC50.65 AND AVGC50 = MAX(AVGC50,126) AND 25 * (AVGC200 - AVGC200.125) + 23 * (AVGC200.5 - AVGC200.120) + 21 * (AVGC200.10 - AVGC200.115) + 19 * (AVGC200.15 - AVGC200.110) + 17 * (AVGC200.20 - AVGC200.105) + 15 * (AVGC200.25 - AVGC200.100) + 13 * (AVGC200.30 - AVGC200.95) + 11 * (AVGC200.35 - AVGC200.90) + 9 * (AVGC200.40 - AVGC200.85) + 7 * (AVGC200.45 - AVGC200.80) + 5 * (AVGC200.50 - AVGC200.75) + 3 * (AVGC200.55 - AVGC200.70) + AVGC200.60 > AVGC200.65 AND AVGC200 = MAX(AVGC200,126)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 12/12/2004 Posts: 60
|
THANKS BRUCE
|
|
Registered User Joined: 12/12/2004 Posts: 60
|
Is there a pcf for the 20 day 50 day 200 day and 10 day moving average in a down trend for 26 weeks
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following.
25 * (AVGC10 - AVGC10.125) + 23 * (AVGC10.5 - AVGC10.120) + 21 * (AVGC10.10 - AVGC10.115) + 19 * (AVGC10.15 - AVGC10.110) + 17 * (AVGC10.20 - AVGC10.105) + 15 * (AVGC10.25 - AVGC10.100) + 13 * (AVGC10.30 - AVGC10.95) + 11 * (AVGC10.35 - AVGC10.90) + 9 * (AVGC10.40 - AVGC10.85) + 7 * (AVGC10.45 - AVGC10.80) + 5 * (AVGC10.50 - AVGC10.75) + 3 * (AVGC10.55 - AVGC10.70) + AVGC10.60 < AVGC10.65 AND AVGC10 = MIN(AVGC10,126) AND 25 * (AVGC20 - AVGC20.125) + 23 * (AVGC20.5 - AVGC20.120) + 21 * (AVGC20.10 - AVGC20.115) + 19 * (AVGC20.15 - AVGC20.110) + 17 * (AVGC20.20 - AVGC20.105) + 15 * (AVGC20.25 - AVGC20.100) + 13 * (AVGC20.30 - AVGC20.95) + 11 * (AVGC20.35 - AVGC20.90) + 9 * (AVGC20.40 - AVGC20.85) + 7 * (AVGC20.45 - AVGC20.80) + 5 * (AVGC20.50 - AVGC20.75) + 3 * (AVGC20.55 - AVGC20.70) + AVGC20.60 < AVGC20.65 AND AVGC20 = MIN(AVGC20,126) AND 25 * (AVGC50 - AVGC50.125) + 23 * (AVGC50.5 - AVGC50.120) + 21 * (AVGC50.10 - AVGC50.115) + 19 * (AVGC50.15 - AVGC50.110) + 17 * (AVGC50.20 - AVGC50.105) + 15 * (AVGC50.25 - AVGC50.100) + 13 * (AVGC50.30 - AVGC50.95) + 11 * (AVGC50.35 - AVGC50.90) + 9 * (AVGC50.40 - AVGC50.85) + 7 * (AVGC50.45 - AVGC50.80) + 5 * (AVGC50.50 - AVGC50.75) + 3 * (AVGC50.55 - AVGC50.70) + AVGC50.60 < AVGC50.65 AND AVGC50 = MIN(AVGC50,126) AND 25 * (AVGC200 - AVGC200.125) + 23 * (AVGC200.5 - AVGC200.120) + 21 * (AVGC200.10 - AVGC200.115) + 19 * (AVGC200.15 - AVGC200.110) + 17 * (AVGC200.20 - AVGC200.105) + 15 * (AVGC200.25 - AVGC200.100) + 13 * (AVGC200.30 - AVGC200.95) + 11 * (AVGC200.35 - AVGC200.90) + 9 * (AVGC200.40 - AVGC200.85) + 7 * (AVGC200.45 - AVGC200.80) + 5 * (AVGC200.50 - AVGC200.75) + 3 * (AVGC200.55 - AVGC200.70) + AVGC200.60 < AVGC200.65 AND AVGC200 = MIN(AVGC200,126)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |