calculating ema- strage problem

T

Tuneman

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?
 
Quote from Tuneman:

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?
More...

newEMA = (2/11)*(price-prevEMA)+prevEMA
 
You must log in or register to reply here.
Back
Top