Can anybody help me with this? I would like to look back to see when the the moving average of close is less than the current bar's value of close. That is, I am looking for the last value of MA(C,30) that is less than the value of C at a given bar. In essence, I want to hold the value of Close constant for each bar and compare it to the array MA(C,30). Using the following:
x = valuewhen(C < MA(C,30),MA(C,30)); gives a value of the moving average where the value of C at that bar was less than the moving average (i.e. it compares C and the moving average at the same bar). I can use LastValue(C) to get the most current value, but of course, can't backtest it.
