Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Offset | Excel Worksheet Functions | |||
offset | Excel Worksheet Functions | |||
OFFSET PLEASE HELP! | Excel Discussion (Misc queries) | |||
SUM() and OFFSET() CAUSES #VALUE | Excel Worksheet Functions | |||
SUM(OFFSET)? | Excel Worksheet Functions |