I have a program which averages out previous points in a form of an Exponential Moving Average. Please see the pic below where the jumpy light blue line is 'smoothed' by the yellow line:
What I want is the yellow line extending to the left hand side of the chart to come up with a new value at 0 on the X axis like this:
Can anyone help with the forumale to produce the ?? figure on the Y axis, based on previous points to the right. This will need to be turned into code and there may be up to 20 previous X,Y points on the graph. I am sure this doesn't matter though as we just want the formula based on previous points?
Much appreciated if anyone can help?