calculating ema- strage problem

Discussion in 'Technical Analysis' started by Tuneman, Jan 10, 2008.

  1. 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?
  2. newEMA = (2/11)*(price-prevEMA)+prevEMA
  3. Tuneman


    im sorry thats what i have. i copied it down wrong