Is there Optuma function that will withhold data to selected functions within a script?
The best way to describe this is to show what the OFFSET() function does to a Moving Average.
In the screen shot the Green Line is an unmodified MA(). The Red Line has an Offset of -1 which moves all the data points back by one day.
I am looking for an Optuma Function that calculates a function to a point one day previous. In that way the two Moving Average Plots would overlap each other exactly except for the very last day.
The aim is to create a short list of buys that may trigger with a final buy criterion on the next day.
Fingers crossed someone has an answer.
Cheers, Lester
