Automatic change the number of days of Stdev

[keis386]

Hi,

In column C is the Standard Deviation of the last 30 days
Is there also a way that I can adjust the number of days automatic
So I mean in cell C3 is the number of days SD (30)
So if I adjust this number the formula changes, see example below:


Formula in cell C32 is =STDEV(B3:B32)*SQRT(252)
But If I change cell C3 to 20 the formula changes to =STDEV(B13:B32)*SQRT(252)

Hope someone can help me,

Thanks

[ben_hensel]

Use the INDIRECT function to build the name of a relative cell reference.

Please Login or Register  to view this content.

[keis386]

Thanks really good!