How to Calculate MACD Indicator using Excel

[@pyolin9173]

Sir, I don't know how to express my feeling, but thank you very much. You have saved my life!

[@priyanshuraturi5186]

WHY ?? and why you wanted to calculate MACD in excel

[@samantha1021]

Great video. But, need to see the formula in F37. How to calculate the EMA-9? Not using the simple average as in F36, but for the remaining observations. How do you incorporate the closing price?

[@rafalvarezsevilla]

you made my life so much easier!!

[@priyanshuraturi5186]

WHY ?? and why you wanted to calculate MACD in excel

[@sanres]

i donno why but indians always helpful when i have math and programming problems lol.

[@canaldeteste5610]

Thanks.
Greetings from Brasil.

[@chandrakbaxi2091]

hi.. where do you get Close price while calculating 9 days EMA signal line from MACD line?

[@ruwanmanage1061]

This is very simple and nice explanation

[@shekharmahamuni6322]

How do they calculate MACD in MT4 platform? Could you please explain? The parameters and formula they have given in MT4 help is as follows :
" The MACD is calculated by subtracting the value of a 26-period exponential moving average from a 12-period exponential moving average. A 9-period dotted simple moving average of the MACD (the signal line) is then plotted on top of the MACD.
MACD = EMA(CLOSE, 12)-EMA(CLOSE, 26)
SIGNAL = SMA(MACD, 9)
Where:
EMA - the Exponential Moving Average;
SMA - the Simple Moving Average;
SIGNAL - the signal line of the indicator "

[@anitamagik]

I can appreciate the order these are written in

[@priyanshuraturi5186]

WHY ?? and why you wanted to calculate MACD in excel

[@hasben0]

Well done!! great explanation/example.

[@davidyomtobian8505]

Thanks for creating this!

[@GabrielsTears]

Thank you. You gave the part that others leave out that is critical to accurate calculation.

[@amathushara]

Excellent

[@snehadamodaran8865]

Can someone help with signal formula, does "of" mean multiplication? [in 9 EMA of MACD]

[@NiranshaDHutch]

great one

[@ashissaha7334]

Thanks a lot.

[@lazamlazam2539]

good

[@mahendralama9489]

bravo

[@mohammadgolamtoyab1954]

Thank you

[@ArshadMPG]

could you provide this excel to me