This is to get the value of the five-day moving average, but I don't know what you mean by "the last value"
What is the value of K-line after completion? If yes, only the value of the average of the last five days can be taken: REF(MA(CLOSE, 5),1); This is a constant value, and the current MA(CLOSE, 5) in the disk is always changing.