How to Calculate Exponential Moving Average Indicator using Excel

ty good sir

Thanks

Worst explanation.

Thanks

GLAT HAI SMOOTHNING FACTOR AAEGA MULTIPLIER KI JAGAH IN EMA FORMULA< smothening factor is 1- multiplier

thx!

Thank youuu

i modified this like following, so that when the previous cell is empty, it fills in the SimpleMovingAverage automatically:

=IF(PreviousEMA=0;ThisDaysSMA;(CLOSE-EMAPreviousDay)*(2/(TimePeriod+1))+EMAPrevious)
Also, i chose the cell above as headline to display the time period, and formatted with a custom format:
# "Day EMA"
So when you change the number in the Headline, your calculation also adjusts accordingly. This Parameter is also linked to the SimpleMovingAverage, so they always keep in synch

oh wow finally someone explains all this stuff in a logical easy to understand way!!!

awesome!

so its a bit unfair to compare it to the SMA and WMA since EMA uses the present value unlike sma and wma where only uses the past values?

Why multiple 2/(t +1)

Sir plz double top double bottom create in Excel plz

wrong calculation see at time 7.28 you said 10 sma not EMA

very understandable. thank you, sir.

Thanku sir its a gem ❤️

do you support trading view chart 📉📈?
or chartIQ charts are supported for API integration?

how can u make the formula dynamic incase you want to adjust the "day" parameter quickly?

How you make mutlipier as constant tell me plz

Thank you.

very nicely explained.

Thanks, very helpful to see the equation in in a spreadsheet & to understand that the initial EMA is the SMA.

Thank you for the crystal clear tutorial! :)

Tradingview doesn't use close-1, but uses the same value of close as ema in the formula.

Thankyou for the knowledge sharing...

thank you for this helpful video, perfect :)) greetings from Turkey:)

Your formula is wrong: actual formula is
Weight (Current) = 2/(no. of days MA +1)
Weight (MA) = 100% - Weight(Current)
In your example
Weight (MA) = 100-18.18= 81.82
Now
EMA dayi= .1818 x day 11close + .8182 x previous day EMI

in your formula you dont have Weight MA
then you have .1818 x previous day close which is wrong

Great explanation 👍👍

Why didn't you write anything in the description part?
At least you could have added the formula and an example of Excel file link.

Thank you very much, you solve my question!! Thank you!!

Thank you for sharing this! It was understandable and very usable!

The wrong value coming after this calculation

Thank you very much. I know now how to calculate it. Good work

Awesome ! Very clearly explained.....found this after wasting tym on so mamy videos.....worth it

Wrong value coming.. Trying to calculate monthly close ema

Woow, the very same result!!! The first video I saw was just a strange calculation and got wrong. Thank you dear!

Why did you use 2 in the multiplier formula?

Very good! Thanks!!

very helpful. and clear explanation sir. thanks

Hi there!
Thank you for sharing it.
Could you please show us how to calculate SMMA 13 and offset it to 8 bar into the future?
Thank you.

Very helpful. Thank you very much. Was struggling to understand without seeing an example