This video article describes how you can calculate the MACD Indicator in Microsoft Excel. I believe the MACD is a particularly useful indicator on the weekly chart and can help to create a long-term trading strategy.
EMA Factor =2/(periods+1)
EMA =((current + previous average)*EMA Factor) + previous average
Trade Entry =IF(L39>0,IF(L38<0,”trade”,””),””)
The SuperTrend Indicator is a great way to identify the current market trend. The indicator…
My name is Mark Ursell, and I am a full-time individual trader and investor. I am continually working on developing new trading strategies and improving my existing strategies. I have developed a series of Excel backtest models, and you can learn more about them on this site.