Registered User Joined: 5/26/2005 Posts: 11
|
I am using the formula below as a PCF for screening for signals with MACD moving up above the zero line. I have tried writing the inverse (with MACD rolling down below 100) and am not getting it right.
Are you able to help with this? thanks, Gwen
(XAVGC12 - XAVGC26) < 0 AND (XAVG(XAVGC12,9) - XAVG(XAVGC26,9)) < 0 AND ((XAVGC12.1 - XAVGC26.1) < (XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9))) AND ((XAVGC12 - XAVGC26) > (XAVG(XAVGC12,9) - XAVG(XAVGC26,9)))
|

 Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Your existing Personal Criteria Formula appears to be testing for the raw MACD to be crossing up through its Trigger Line while both the raw MACD and its Trigger Line are below zero (this does not match your description).
I'm not actually sure for what condition you want your new PCF to test. If you can clarify it further, we can probably help you write the PCF.
You may wish to review the following:
Understanding MACD
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
 Administration
Joined: 9/30/2004 Posts: 9,187
|
What you have above is MACD crossing up through the trigger line when MACD is less than 0. For MACD crossing down through the trigger line when MACD is greater than 0, just reverse all of < and >.
(XAVGC12 - XAVGC26) > 0 AND (XAVG(XAVGC12,9) - XAVG(XAVGC26,9)) > 0 AND ((XAVGC12.1 - XAVGC26.1) > (XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9))) AND ((XAVGC12 - XAVGC26) < (XAVG(XAVGC12,9) - XAVG(XAVGC26,9)))
|