Hi all
I have made excel sheet for calculating EMA.Values in the sheet are of Nifty spot.Those who do not have Real time charts can use these sheet.Just around 3:15 pm enter the value and you will get all emas.Hope this will help.Correct me if any thing you find wrong in the sheet.Thanks.
I have made excel sheet for calculating EMA.Values in the sheet are of Nifty spot.Those who do not have Real time charts can use these sheet.Just around 3:15 pm enter the value and you will get all emas.Hope this will help.Correct me if any thing you find wrong in the sheet.Thanks.
I don't know EMA formula. I just saw what you have plugged in xls file.
Till now, I was under impression that formula will take last 3days value for calculating 3EMA (&15days value for 15EMA). But it seems you are considering only last two days while calculating EMA.
I am bit confused about logic. Appreciate your advice.