How to Calculate Exponential Moving Average Indicator using Excel

No video

How to Calculate Exponential Moving Average Indicator using Excel

Рет қаралды 77,793

Trading Campus

Күн бұрын

Пікірлер: 47

@rafalvarezsevilla Жыл бұрын

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

@a.s.p5128 4 жыл бұрын

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

@SteveTremper 5 ай бұрын

Very good explanation! Thanks for keeping it simple.

@julieanderton1716 3 жыл бұрын

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

@munishkuvadia2080 4 жыл бұрын

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

@skywlker9633 3 жыл бұрын

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

@vivekchawla Ай бұрын

Helpful video, thank you 🙏🏻

@1stNoelJensen 3 жыл бұрын

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

@akhil453 3 жыл бұрын

Thank you for the crystal clear tutorial! :)

@Rujubhatia 3 жыл бұрын

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

@Ks-oj6tc 3 жыл бұрын

Thanks a lot brother.

@arsenalfanism 3 жыл бұрын

No, the formula both of you expressed is the same. Just that you've taken a longer route to it. As per you: EMA dayi = 0.1818 x day 11close + 0.8182 x previous day EMA If we just work it backwards we get: EMA dayi = 0.1818 x day 11close + (1 - 0.1818 ) x previous day EMA = 0.1818 x day 11close + 1 x previous day EMA - 0.1818 x previous day EMA OR = 0.1818 x day 11close - 0.1818 x previous day EMA + 1 x previous day EMA Taking 0.1818 out as common multiplier we get = 0.1818 (day 11close - previous day EMA) + previous day EMA which is the same thing as expressed at start of the video.

@Rujubhatia 3 жыл бұрын

@@arsenalfanism There are 2 weights to be added 1st is 2/11 = which comes to .1818 2nd is 1 - .1818 = .8182 FOR EMA you need to multiply current price with .1818 and remaining weight that is .8182 is to be multiplied by past EMA But...But but my friend here in this video takes past EMA and gives full weight to past EMA Hence mathematically its 0.1818*(current price)+1*(previous EMA) Actually weight has to be distributed as 0.1818 + 0.8182 = 1

@guillaume8437 4 жыл бұрын

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

@pinkid5793 3 жыл бұрын

Thankyou for the knowledge sharing...

@ignite3867 2 жыл бұрын

Thanku sir its a gem ❤️

@charlgreyvensteyn8903 4 жыл бұрын

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

@sureshsubramani2392 4 жыл бұрын

very helpful. and clear explanation sir. thanks

@sutapa1983 3 жыл бұрын

Great explanation 👍👍

@dx31900 3 жыл бұрын

very nicely explained.

@kowtungWee 3 жыл бұрын

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

@Macam2macam 2 жыл бұрын

very understandable. thank you, sir.

@kkrarumalla 4 жыл бұрын

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.

@iniquuisorbis4824 2 жыл бұрын

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

@nirpanialive2136 2 жыл бұрын

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

@harshalkukade8664 2 жыл бұрын

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

@praveenchinni1718 3 жыл бұрын

all KZfaq channels showing same formula but when caluclated value is not matching with charting software, any deviation is there in formula??

@mingkwan5280 Жыл бұрын

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?

@saifriyami4002 11 ай бұрын

Thanks

@syeda8343 2 жыл бұрын

How you make mutlipier as constant tell me plz

@michalbotor Жыл бұрын

thx!

@peritowerner 4 жыл бұрын

Very good! Thanks!!

@psanthohkumar 2 жыл бұрын

Thank you.

@rafalvarezsevilla Жыл бұрын

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

@alexandernicholas1667 Жыл бұрын

awesome!

@Omarlitical 4 жыл бұрын

Why did you use 2 in the multiplier formula?

@michaeldunn6407 4 жыл бұрын

a bit more color around the multiplier is here: www.investopedia.com/ask/answers/122314/what-exponential-moving-average-ema-formula-and-how-ema-calculated.asp but still not all the details