Registered User
Joined: 1/21/2014
Posts: 15
|
hello
I have a MACD (12,26,9) in the chart; the line is above the EMA 9
I would like to add on the column the diffecre betwen the two lines
for example macd 12,26 -EMA 9 =0.10
can someone help me with the formula?
i want to have how many points between the two lines
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The formula as a net difference is as follows.
MACD12.26 - XAVG(MACD12.26, 9)
The formula for a percent difference is as follows.
100 * (MACD12.26 / XAVG(MACD12.26, 9) - 1)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|