I am calculating a rolling historical volatility for a series of commodity
returns, using the following formula =STDEV(D6:D35)*SQRT(252)
I want to be able to type in the # of days back to go (e.g. in the example
above, it is a 30-day rolling stdev) in the cell above the top value. That
is, I want to be able to type "50" into the cell and have the formula update
to STDEV(D6:D55)*SQRT(252) automatically.