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
Bookmarks