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?
|
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
|