Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 5/27/2005 Posts: 35
|
Hello Support ,
can you help me in writing PCF for detecting :
MACD ( 10 ,30 , 5 ) crossing today above the zero level .
thanks
Ron
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
By crossing do you mean the MACD line crossing its moving average line?
Is your MACD simple or exponential?
- Craig Here to Help!
|
|
Registered User Joined: 5/27/2005 Posts: 35
|
Hi Craig ,
i want to detect when MACD ( 10,30,5 ) Simple is turn to be positive , i have MACD Histogram
and i want to find stocks the just turn positive ( crossing the zero line )
My MACD is ( 10 -Short , 30 Long , Period -5 ) Average type is Simple .
thanks
Ron
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
This should work:
AVG(AVGC10,5)>AVG(AVGC30,5) AND
AVG(AVGC10.1,5)<AVG(AVGC30.1,5)
- Craig Here to Help!
|
|
Registered User Joined: 5/27/2005 Posts: 35
|
Thanks Craig for your help
that what i'm look for
ron
|
|
Registered User Joined: 1/14/2005 Posts: 7
|
Craig:
What would the pcf formula be if it were exponential?
JVG
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
griego,
You would just add an X to each of the AVGs in the formula:
XAVG(XAVGC10,5) > XAVG(XAVGC30,5) AND XAVG(XAVGC10.1,5) < XAVG(XAVGC30.1,5)
You may wish to review the following:
Understanding MACD
PCF Formula Descriptions
How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |