How to Calculate Exponential Moving Average Indicator using Excel

Поділитися
Вставка
  • Опубліковано 12 гру 2024

КОМЕНТАРІ • 49

  • @rafalvarezsevilla
    @rafalvarezsevilla Рік тому +3

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

  • @SteveTremper
    @SteveTremper 8 місяців тому +2

    Very good explanation! Thanks for keeping it simple.

  • @a.s.p5128
    @a.s.p5128 4 роки тому +1

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

  • @julieanderton1716
    @julieanderton1716 3 роки тому +2

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

  • @sky_wlkerr
    @sky_wlkerr 3 роки тому +2

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

  • @munishkuvadia2080
    @munishkuvadia2080 5 років тому +1

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

  • @1stNoelJensen
    @1stNoelJensen 4 роки тому +3

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

  • @pinkid5793
    @pinkid5793 3 роки тому

    Thankyou for the knowledge sharing...

  • @akhil453
    @akhil453 3 роки тому +1

    Thank you for the crystal clear tutorial! :)

  • @mandanakhorrami9211
    @mandanakhorrami9211 3 місяці тому

    Thank you for your perfect explanation!

  • @harshalkukade8664
    @harshalkukade8664 2 роки тому

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

  • @sutapa1983
    @sutapa1983 3 роки тому

    Great explanation 👍👍

  • @vivekchawla
    @vivekchawla 4 місяці тому

    Helpful video, thank you 🙏🏻

  • @ignite3867
    @ignite3867 2 роки тому +1

    Thanku sir its a gem ❤️

  • @iniquuisorbis4824
    @iniquuisorbis4824 2 роки тому

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

  • @dx31900
    @dx31900 3 роки тому

    very nicely explained.

  • @charlgreyvensteyn8903
    @charlgreyvensteyn8903 4 роки тому

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

  • @guillaume8437
    @guillaume8437 4 роки тому

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

  • @syeda8343
    @syeda8343 3 роки тому +1

    How you make mutlipier as constant tell me plz

  • @sureshsubramani2392
    @sureshsubramani2392 5 років тому

    very helpful. and clear explanation sir. thanks

  • @Macam2macam
    @Macam2macam 2 роки тому

    very understandable. thank you, sir.

  • @kkrarumalla
    @kkrarumalla 5 років тому

    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.

  • @praveenchinni1718
    @praveenchinni1718 3 роки тому

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

  • @The2Farooqs
    @The2Farooqs 4 роки тому +1

    Why did you use 2 in the multiplier formula?

    • @michaeldunn6407
      @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

  • @mingkwan5280
    @mingkwan5280 2 роки тому

    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?

  • @kowtungWee
    @kowtungWee 3 роки тому

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

  • @alexandernicholas1667
    @alexandernicholas1667 Рік тому

    awesome!

  • @kandeepanthanapalar1127
    @kandeepanthanapalar1127 2 роки тому

    Why multiple 2/(t +1)

  • @Rujubhatia
    @Rujubhatia 3 роки тому +4

    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
      @Ks-oj6tc 3 роки тому +1

      Thanks a lot brother.

    • @arsenalfanism
      @arsenalfanism 3 роки тому +1

      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
      @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

  • @makdesi-fm9ds
    @makdesi-fm9ds 27 днів тому

    Which means there will 2 formula, the 0 one, and then the n

  • @tarsemsingh8570
    @tarsemsingh8570 2 роки тому

    Sir plz double top double bottom create in Excel plz

  • @nirpanialive2136
    @nirpanialive2136 2 роки тому +1

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

  • @akshanshsingh4453
    @akshanshsingh4453 Рік тому

    Thanks

  • @psanthohkumar
    @psanthohkumar 3 роки тому

    Thank you.

  • @hasna9677
    @hasna9677 Рік тому

    Thank youuu

  • @girtsosmanis7269
    @girtsosmanis7269 Рік тому

    ty good sir

  • @peritowerner
    @peritowerner 5 років тому

    Very good! Thanks!!

  • @jarjarbinks827
    @jarjarbinks827 3 роки тому +1

    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.

  • @naveenofficial3680
    @naveenofficial3680 4 роки тому

    Wrong value coming.. Trying to calculate monthly close ema

  • @michalbotor
    @michalbotor Рік тому

    thx!

  • @Scalper7244
    @Scalper7244 4 роки тому

    The wrong value coming after this calculation

  • @birbahadur6949
    @birbahadur6949 Рік тому

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

  • @rafalvarezsevilla
    @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

  • @saifriyami4002
    @saifriyami4002 Рік тому

    Thanks