Calculating the VIX in Excel

相似文件 换一批

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

The VIX has become a popular volatility index that is based on a weighted
average of S&P 500 options that straddle a 30-day maturity. This manner of calculating
the VIX emerged in September of 2003 and is documented with an example by the
CBOE. In this paper, the calculation of the VIX is reproduced in an Excel template to
automate and to some degree simplify the calculation. Further, one can also apply other
option series to calculate a VIX-type analysis for the underlying security which is of great
benefit because the calculation is independent of option pricing model biases.




Calculating the VIX in Excel.pdf (53.69 KB, 需要: 8 个论坛币)

2012-7-28 13:29:29 上传

需要: 8 个论坛币  [购买]

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：Calculating EXCEL latin Calc exce security example popular become manner

三克油