Hi

=STDEV(OFFSET($D$6,,,$X$1,1)*SQRT(252)

, where cell X1 contains the number of days


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"energydoc" wrote in message
...
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.