| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 7/23/2005
Posts: 128
|
Hi guys
I did a search for MACD Pcfs and found some useful stuff, but could someone create pcfs for the following for me please.
1. Personal Criteria Formula for the Exponential MACD 12,26,9 Signal Line crossing DOWN through zero.
2. Personal Criteria Formula for the Exponential MACD 12,26,9 Signal Line moving DOWN while below zero.
3. Personal Criteria Formula for the raw MACD 12,26 crossing DOWN through its 9-Period Exponential Moving Average Signal line while moving DOWN below zero as follows:
Thanks for your help guys
jay
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (fantastic4) Personal Criteria Formula for the Exponential MACD 12,26,9 Signal Line crossing DOWN through zero.
XAVG(XAVGC12,9) - XAVG(XAVGC26,9) < 0 AND XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9) >= 0
QUOTE (fantastic4) Personal Criteria Formula for the Exponential MACD 12,26,9 Signal Line moving DOWN while below zero.
XAVG(XAVGC12,9) - XAVG(XAVGC26,9) < XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9) AND XAVG(XAVGC12,9) - XAVG(XAVGC26,9) < 0
QUOTE (fantastic4) Personal Criteria Formula for the raw MACD 12,26 crossing DOWN through its 9-Period Exponential Moving Average Signal line while moving DOWN below zero as follows:
XAVGC12 - XAVGC26 < XAVG(XAVGC12,9) - XAVG(XAVGC26,9) AND XAVGC12.1 - XAVGC26.1 >= XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9) AND XAVGC12 - XAVGC26 < XAVGC12.1 - XAVGC26.1 AND XAVGC12 - XAVGC26 < 0
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: 7/23/2005
Posts: 128
|
Hi Bruce
thanks for that, much appreciated, one last item, instead of creating three separete pcfs and then three separete scans for the above, is it possible to combine the above threes pcfs into one to create one scan that give me all the stocks, if so how do i do that please.
Thanks
jay
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Assuming that you want a list that contains any stock that returned True for any of the Personal Criteria Formulas, you could put them in parentheses and connect them with ORs:
(XAVG(XAVGC12,9) - XAVG(XAVGC26,9) < 0 AND XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9) >= 0) OR (XAVG(XAVGC12,9) - XAVG(XAVGC26,9) < XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9) AND XAVG(XAVGC12,9) - XAVG(XAVGC26,9) < 0) OR (XAVGC12 - XAVGC26 < XAVG(XAVGC12,9) - XAVG(XAVGC26,9) AND XAVGC12.1 - XAVGC26.1 >= XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9) AND XAVGC12 - XAVGC26 < XAVGC12.1 - XAVGC26.1 AND XAVGC12 - XAVGC26 < 0)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 7/23/2005
Posts: 128
|
Thanks so much for that bruce
have a great day
Jay
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |