Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 11/25/2007 Posts: 28
|
What would be the PCF for the raw MACD (12,26,9) to be between -0.5 and 0.5 and where the MACD lines have crossed at any time during the past 3 days or are now equal?
Tradingfreedom
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following:
ABS(XAVGC12 - XAVGC26) <= .5 AND (SGN(XAVGC12 - XAVGC26 - XAVG(XAVGC12,9) + XAVG(XAVGC26,9)) <> SGN(XAVGC12.1 - XAVGC26.1 - XAVG(XAVGC12.1,9) + XAVG(XAVGC26.1,9)) OR SGN(XAVGC12.1 - XAVGC26.1 - XAVG(XAVGC12.1,9) + XAVG(XAVGC26.1,9)) <> SGN(XAVGC12.2 - XAVGC26.2 - XAVG(XAVGC12.2,9) + XAVG(XAVGC26.2,9)) OR SGN(XAVGC12.2 - XAVGC26.2 - XAVG(XAVGC12.2,9) + XAVG(XAVGC26.2,9)) <> SGN(XAVGC12.3 - XAVGC26.3 - XAVG(XAVGC12.3,9) + XAVG(XAVGC26.3,9)) OR XAVGC12 - XAVGC26 = XAVG(XAVGC12,9) - XAVG(XAVGC26,9))
You may wish to review the following:
Understanding MACD
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
|
|
Registered User Joined: 11/25/2007 Posts: 28
|
Hi Bruce,
Thank you for the formula.
What would be the PCF for the raw MACD (12,26,9) to be between -0.5 and 0.5 and where the MACD lines have crossed today?
Tradingfreedom
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please try the following:
ABS(XAVGC12 - XAVGC26) <= .5 AND SGN(XAVGC12 - XAVGC26 - XAVG(XAVGC12,9) + XAVG(XAVGC26,9)) <> SGN(XAVGC12.1 - XAVGC26.1 - XAVG(XAVGC12.1,9) + XAVG(XAVGC26.1,9))
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |