so I am trying to have excel calculate the 10 period ema on a 10 min graph. It totally deviates from the graph though I take a look at a 10 min graph, see the last ema input it into excel, and then use this to calculate the current ema (prev. ema - price)*(2/11)+ price then every 10 mins, the current ema becomes the prev. one. I cannot figure out what is wrong with my calculation. Can anyone help?