Dear All,
I have a strange problem
please find the below data which has to be updated every time a close price of any stock is updated.
However, as shown (only for nderstanding) i want the Latest EMA to be put in last EMA when ever i update the CLose Price and then calculate the Lastest EMA.
This calculation should be in a Single row (i showed in 3 rows for understanding).

Can any one propose a solution how can this be done.
Last EMA Close Price Latest EMA
11 100 111
111 101 212
212 102 314