| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 7/13/2005
Posts: 6
|
Can you pls post a formula that will find stocks with MACD that is about to cross over from POS to NEG and vice-versa. My MACD settings are 12,26,26.
Also, is there a formula that will find cross-overs that happened 1 day ago?
Thanks
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
We cannot scan for anything "about to cross". We don't know if anything WILL cross, we can only know if it did cross.
If you want to find stocks where the MACD is close to zero, I only need to know how close. If you want to find stocks where the MACD is moving towards zoro, I only need to know the number of days it needs to move towards zero.
This PCF will find your MACD crossing zero yesterday. I assume you are using a simple MACD and not a histogram.
(AVGC12.1-AVGC26.1>0 AND AVGC12.2-AVGC26.2<0) OR (AVGC12.1-AVGC26.1<0 AND AVGC12.2-AVGC26.2>0)
- Craig
Here to Help!
|
|
Registered User
Joined: 7/13/2005
Posts: 6
|
Thanks, Craig. But this formula does not return proper results. I am using both simple and histo MACD 12.26.26. Can you pls give me a histo formula?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Please try one of the following:
Simple MACD Histogram (12,26,26) Crossed up through Zero Between Today and Yesterday:
SGN(AVGC12 - AVGC26 - AVG(AVGC12,26) + AVG(AVGC26,26)) - SGN(AVGC12.1 - AVGC26.1 - AVG(AVGC12.1,26) + AVG(AVGC26.1,26)) > 0
Simple MACD Histogram (12,26,26) Crossed up through Zero Between Yesterday and the day before:
SGN(AVGC12.1 - AVGC26.1 - AVG(AVGC12.1,26) + AVG(AVGC26.1,26)) - SGN(AVGC12.2 - AVGC26.2 - AVG(AVGC12.2,26) + AVG(AVGC26.2,26)) > 0
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
The formula provided the proper results for a MACD non-histogram. Now that we know you are using a histogram you should find Bruce's formula matches the MACD you are using.
- Craig
Here to Help!
|
|
|
Guest-1 |