| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/7/2004
Posts: 33
|
How would I write a PCF showing
MA4 crossing MA8,
and than both crossing MA20?
Finally, could one run those stocks against a PCF finding MACD34,144,14 and MACD19,39,9 both crossing 0?
Many thanks.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 74
|
Dear REBubbler,
Are you looking for simple moving averages or exponential? Also, which direction are you looking for? Do you want the short to cross up or down through the long? Do you want the MACD to cross up or down through zero?
|
|
Registered User
Joined: 10/7/2004
Posts: 33
|
Simple MAs, crossing up.
MACD crossing up through zero.
(two PCFs)
Would it be a gigantic effort to reverse it too- having it show the downside?
Thanks, Jared
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
REBubbler,
I actually have some more questions, but I'll start with what I have now:
SMA4 xUp SMA8:
AVGC4 > AVGC8 AND AVGC4.1 <= AVGC8.1
SMA4 xUp SMA20:
AVGC4 > AVGC20 AND AVGC4.1 <= AVGC20.1
SMA8 xUp SMA20:
AVGC8 > AVGC20 AND AVGC8.1 <= AVGC20.1
Exponential MACD Histogram 34,144,14 xUp Zero:
XAVGC34 - XAVGC144 - XAVG(XAVGC34,14) + XAVG(XAVGC144,14) > 0 AND XAVGC34.1 - XAVGC144.1 - XAVG(XAVGC34.1,14) + XAVG(XAVGC144.1,14) <= 0
Exponential MACD Histogram 19,39,9 xUp Zero:
XAVGC19 - XAVGC39 - XAVG(XAVGC19,9) + XAVG(XAVGC39,9) > 0 AND XAVGC19.1 - XAVGC39.1 - XAVG(XAVGC19.1,9) + XAVG(XAVGC39.1,9) <= 0
SMA4 xDown SMA8:
AVGC4 < AVGC8 AND AVGC4.1 >= AVGC8.1
SMA4 xDown SMA20:
AVGC4 < AVGC20 AND AVGC4.1 >= AVGC20.1
SMA8 xDown SMA20:
AVGC8 < AVGC20 AND AVGC8.1 >= AVGC20.1
Exponential MACD Histogram 34,144,14 xDown Zero:
XAVGC34 - XAVGC144 - XAVG(XAVGC34,14) + XAVG(XAVGC144,14) < 0 AND XAVGC34.1 - XAVGC144.1 - XAVG(XAVGC34.1,14) + XAVG(XAVGC144.1,14) >= 0
Exponential MACD Histogram 19,39,9 xDown Zero:
XAVGC19 - XAVGC39 - XAVG(XAVGC19,9) + XAVG(XAVGC39,9) < 0 AND XAVGC19.1 - XAVGC39.1 - XAVG(XAVGC19.1,9) + XAVG(XAVGC39.1,9) >= 0
Does the SMA4 need to cross SMA8 prior to SMA4 and SMA8 crossing SMA20?
Do SMA4 and SMA8 need to cross SMA20 at the same time?
Over what period can this sequence of events occur?
Would checking for the first time SMA4 and SMA8 are both above (or below in the reverse case) SMA20 work (it is a much shorter formula)?
Do both MACDs need to cross zero at the time?
If not, over what period can this occur?
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Moving Average PCF Templates
Things to check if your moving averages don't "seem right" or "seem to match"
Understanding MACD
Handy PCF example formulas to help you learn the syntax of PCFs!
PCF Formula Descriptions
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 33
|
Bruce- thank you for your extensive work (!)
In answer to your questions:
>>Would checking for the first time SMA4 and SMA8 are both above (or below in the reverse case) SMA20 work (it is a much shorter formula)? >> the answer is yes. shorter is better.
>>Do both MACDs need to cross zero at the same sic. time>> I would say yes, or very closely thereabouts- this would be a rare occurance I would think, esp. in view of the earlier SMAs being crossed.
Again, thanks for your effort.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try the following:
xUps:
Moving Averages:
AVGC4 > AVGC8 AND AVGC4 > AVGC20 AND AVGC8 > AVGC20 AND NOT(AVGC4.1 > AVGC20.1 AND AVGC8.1 > AVGC20.1)
MACDs:
XAVGC34 - XAVGC144 - XAVG(XAVGC34,14) + XAVG(XAVGC144,14) > 0 AND XAVGC34.1 - XAVGC144.1 - XAVG(XAVGC34.1,14) + XAVG(XAVGC144.1,14) <= 0 AND XAVGC19 - XAVGC39 - XAVG(XAVGC19,9) + XAVG(XAVGC39,9) > 0 AND XAVGC19.1 - XAVGC39.1 - XAVG(XAVGC19.1,9) + XAVG(XAVGC39.1,9) <= 0
xDowns:
Moving Averages:
AVGC4 < AVGC8 AND AVGC4 < AVGC20 AND AVGC8 < AVGC20 AND NOT(AVGC4.1 < AVGC20.1 AND AVGC8.1 < AVGC20.1)
MACDs:
XAVGC34 - XAVGC144 - XAVG(XAVGC34,14) + XAVG(XAVGC144,14) < 0 AND XAVGC34.1 - XAVGC144.1 - XAVG(XAVGC34.1,14) + XAVG(XAVGC144.1,14) >= 0 AND XAVGC19 - XAVGC39 - XAVG(XAVGC19,9) + XAVG(XAVGC39,9) < 0 AND XAVGC19.1 - XAVGC39.1 - XAVG(XAVGC19.1,9) + XAVG(XAVGC39.1,9) >= 0
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 33
|
Bruce, many thanks for your prodigous effort (!) It is much appreciated. The MAs show up perfectly. I am not so sure about the MACDs - maybe I am looking at them incorrectly - but I will work with it (them). You have given me a huge leg up. THANKS AGAIN.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |