Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 1/31/2013 Posts: 7
|
Hi,
I need help on PCF for the following:
Today's MACD (12,26) is equal or larger than its Exponential Moving Average (9)
both are on a daily closing price basis.
Thanks in advance!
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following:
XAVGC12 - XAVGC26 > XAVG(XAVGC12,9) - XAVG(XAVGC26,9)
Understanding MACD
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 1/31/2013 Posts: 7
|
Works great! Thanks Bruce!
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 8/19/2010 Posts: 4
|
I am trying to write a simple PCF but am not sure I'm getteing the right results
Standard MACD today is below 0 line. Cross over above exponential 9 is happening today. Is this correct?
(XAVGC12-XAVGC26)<0
and
(XAVGC12 - XAVGC26 >= XAVG(XAVGC12,9) - XAVG(XAVGC26,9))
and
(XAVGC12.1 - XAVGC26.1 < XAVG(XAVGC12.1,9.1) - XAVG(XAVGC26.1,9.1))
Thanks for your help!
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You don't want or need the 9.1s in the formula. the bars ago parameter is handled in the XAVGC portion of the XAVG() function.
XAVGC12 < XAVGC26 AND XAVGC12 - XAVGC26 >= XAVG(XAVGC12,9) - XAVG(XAVGC26,9) AND XAVGC12.1 - XAVGC26.1 < XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 8/19/2010 Posts: 4
|
Thanks!
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |