Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

moving average Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
ferriers
Posted : Thursday, August 4, 2016 9:08:55 PM
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

ferriers
Posted : Thursday, August 4, 2016 9:36:55 PM
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

Bruce_L
Posted : Friday, August 5, 2016 10:11:10 AM


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
ferriers
Posted : Friday, August 5, 2016 3:15:48 PM
Registered User
Joined: 12/12/2004
Posts: 60

THANKS  BRUCE

ferriers
Posted : Friday, July 28, 2017 2:46:12 AM
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

Bruce_L
Posted : Friday, July 28, 2017 9:12:32 AM


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
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.