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”,””),””)