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

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » Moving Average Crossover

Moving Average Crossover Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
ats33
Posted : Tuesday, September 30, 2008 10:10:10 PM
Registered User
Joined: 10/17/2007
Posts: 15
 I use SMA35, SMA50, SMA75 and EMA8. In downtrend, the order of the MovAvg lines is 8, 35, 50, 75 from the bottom. In uptrend, the order of the MovAvg lines is 8, 35, 50, and 75. from the top. In downtrend, I would like to seach stocks which EMA8 has just completed the crossover of SMA75 from the bottom In uptrend, I would like to search stocks which EMA8 has just completed the crossover of SMA75 from the top. Could you help me with the PCF?
Back to top
Bruce_L
Posted : Wednesday, October 1, 2008 10:55:02 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
 I'm really not sure from your description exactly what you want to find. You describe an order in which the Moving Averages need to be in both a downtrend and an uptrend, but this order does not seem to be part of your requested requirements.

EMA8 xUp SMA75:

XAVC8 > AVGC75 AND XAVGC8.1 <= AVGC75.1

EMA8 xDn SMA75:

XAVC8 < AVGC75 AND XAVGC8.1 >= AVGC75.1

If you want a situation where these crossovers happened between yesterday and today and met the downtrend or uptrend definition yesterday, you could try one of the following:

EMA8 xUp SMA75 and met Downtrend requirements yesterday:

XAVC8 > AVGC75 AND XAVGC8.1 < AVGC35.1 AND AVGC35.1 < AVGC50.1 AND AVGC50.1 < AVGC75.1

EMA8 xDn SMA75 and met Uptrend requirements yesterday:

XAVC8 < AVGC75 AND XAVGC8.1 > AVGC35.1 AND AVGC35.1 > AVGC50.1 AND AVGC50.1 > AVGC75.1

If you want a situation where these crossovers happened between yesterday and today and also the meet the downtrend or uptrend definition today, you could try one of the following:

EMA8 xUp SMA75 and meet Uptrend requirements:

XAVGC8 > AVGC35 AND AVGC35 > AVGC50 AND AVGC50 > AVGC75 AND XAVGC8.1 <= AVGC75.1

EMA8 xDn SMA75 and meet Downtrend requirements:

XAVGC8 < AVGC35 AND AVGC35 < AVGC50 AND AVGC50 < AVGC75 AND XAVGC8.1 >= AVGC75.1

You may wish to review the following:

Moving Average PCF Templates
Things to check if your moving averages don't "seem right" or "seem to match"
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
Back to top
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.