Comment on Greek Interactions

Nakash commented on 01 Apr 2017, 07:57 PM

i am trying my level best to understand this formula =SQRT(1/B$5*SUM(OFFSET(Sheet1!$E$2,MATCH(Sheet1!$N5,Sheet1!$A$2:$A$504,1)-1,0,-B$5)))*SQRT(252), so as to obtain the value for x days for given month. but cant able to achieve so far. i tried the formula you explained in chapter 16. but not getting this value as shown in excel sheet. If you can shown how to obtain relative volatility , it will really helpful. please explain here or mail me. i will really appreciate

View the full comment thread »