Registered User Joined: 5/4/2006 Posts: 15
|
OK.
I have a scan that is doing what i want thanks to the help in this forum.
It does what I want, but too well.
I have a number of conditions, with the final trigger being the MACD turning direction. The other conditions tend to continue to be true after the MACD trigger.
The scan continues to show the ticker after the trigger as long as the conditions are true, but I would prefer that it only show in the list for a short period of time when the final MACD trigger is initially true.
I was thinking about the final MACD trigger being down or flat prior to turning up for example, but have no idea how to code it.
Any thoughts or sugggestions on how to correct this?.
Thanks in advance.
|

 Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
What is the exact format of your current MACD turning direction Condition? How was it created? Did you create a Condition Formula or click on MACD and select Create Scan Condition?
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Registered User Joined: 5/4/2006 Posts: 15
|
All conditions were created with the latter - Clcik MACD and create condition". I then stacked mutiple conditions for the bulk of my scan.The last scan was similarly created using the same method, but the MACD rises sharply, with the slider at the default speed on the slider with a period of 1.
Another question has come up. I want to use the MACD 12-26-9. I want to use the difference between the MACD and the average line. To get the MACD, I use (XAVGC12-XAVC26), I think.
How do I get the average line?
How do I get both numbers for yesterday, 2 days ago?
Thanks
|

 Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
An Indicator Formula for the raw Exponential MACD 12,26 is:
XAVGC12 - XAVGC26
The same formula for 1-bar ago would be:
XAVGC12.1 - XAVGC26.1
And for 2-bars ago would be:
XAVGC12.2 - XAVGC26.2
An Indicator Formula for 9-Period Exponential Moving Average of the Exponential MACD 12,26 is:
XAVG(XAVGC12,9) - XAVG(XAVGC26,9)
The same formula for 1-bar ago would be:
XAVG(XAVGC12.1,9) - XAVG(XAVGC26.1,9)
And for 2-bars ago would be:
XAVG(XAVGC12.2,9) - XAVG(XAVGC26.2,9)
An Indicator Formula for the Exponential MACD Histogram 12,26,9 would be the difference between the MACD and its Moving Average Signal Line:
XAVGC12 - XAVGC26 - XAVG(XAVGC12,9) + XAVG(XAVGC26,9)
The same formula for 1-bar ago would be:
XAVGC12.1 - XAVGC26.1 - XAVG(XAVGC12.1,9) + XAVG(XAVGC26.1,9)
And for 2-bars ago would be:
XAVGC12.2 - XAVGC26.2 - XAVG(XAVGC12.2,9) + XAVG(XAVGC26.2,9)
Understanding MACD
-Bruce Personal Criteria Formulas TC2000 Support Articles
|