ExcelBanter - Offset

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Offset (https://www.excelbanter.com/excel-worksheet-functions/158737-offset.html)

Hi! In column A I have a series of returns and in column B I want to
calculate the standard deviation. This is no problem. The problem is that
sometimes I want to calculate the standard deviation for 10 days rolling
return (ie 10 rows) and sometimes for a 100 days rolling return. How can I
write a formula that does this? I have a named range where I enter the number
of days that I want to use in the standard deviation calculation. Please
help!

Assuming data in A2 down
think you could try this in say, B2:
=STDEV(OFFSET(A2,,,Days))
where Days would be a named cell for the input: 10 or 100, etc
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arne Hegefors" wrote:
Hi! In column A I have a series of returns and in column B I want to
calculate the standard deviation. This is no problem. The problem is that
sometimes I want to calculate the standard deviation for 10 days rolling
return (ie 10 rows) and sometimes for a 100 days rolling return. How can I
write a formula that does this? I have a named range where I enter the number
of days that I want to use in the standard deviation calculation. Please
help!