| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 12/10/2004
Posts: 25
|
I am trying to write a formula for MACD 12, 26, 9 that was below the line 7 days ago and above the line 2 days ago. Tried many times but always get the syntex answer. Please help.
|
|
Registered User
Joined: 12/10/2004
Posts: 25
|
I am trying to write a formula for MACD 12. 26. 9 that was below the line 7 days ago and above the line 2 days ago. Tried many times but all I get in the syntex response
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
If you mean the raw Exponential MACD versus the zero line:
XAVGC12.7 - XAVGC26.7 < 0 AND XAVGC12.2 - XAVGC26.2 > 0
If you mean its Exponential Moving Average Signal Line versus the zero line:
XAVG(XAVGC12.7,9) - XAVG(XAVGC26.7,9) < 0 AND XAVG(XAVGC12.2,9) - XAVG(XAVGC26.2,9) > 0
If you mean the Exponential MACD Histogram versus the zero line (which is the same as the raw MACD versus its Moving Average Signal Line):
XAVGC12.7 - XAVGC26.7 - XAVG(XAVGC12.7,9) + XAVG(XAVGC26.7,9) < 0 AND XAVGC12.2 - XAVGC26.2 - XAVG(XAVGC12.2,9) + XAVG(XAVGC26.2,9) > 0
If the MACD is Simple instead of Exponential, just get rid of all of the Xs in the Personal Criteria Formula.
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: 12/10/2004
Posts: 25
|
Bruce - wildcat7129. I entered the formula for MACD12.26.9 and it was accepted. Then I went to the criteria and clicked on the MACD and saved. When I went to the Scan Bolt it have me all the 7709 stocks and I didn't have only those stocks that closed above the signal line 2 days ago. Thanks for you help
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
QUOTE (wildcat7129) I entered the formula for MACD12.26.9 and it was accepted.
Which formula? Three were provided directly and there are another three variations that result if your MACD is Simple instead of Exponential.
QUOTE (wildcat7129) Then I went to the criteria and clicked on the MACD and saved. When I went to the Scan Bolt it have me all the 7709 stocks...
Absolutely none of these six Personal Criteria Formulas return all of the stocks when used as an EasyScan Condition.
Using EasyScan to find stocks that meet your own criteria
The first formula currently returns 324 stocks (the simple version returns 418), the second formula currently returns 202 stocks (the simple version returns 265) and the third formula returns 1156 stocks (the simple version returns 1243).
QUOTE (wildcat7129) ...and I didn't have only those stocks that closed above the signal line 2 days ago.
It reads like you need to use the third formula as the PCFs provided were relative to the zero line, not the signal line. The MACD Histogram crossing through zero is the same as the raw MACD crossing through its Moving Average Signal Line.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |