Calculating VIX - like Indexes In Excel

There are two excellent resources on creating your own spreadsheet for calculating VIX or VIX-like volatility index for your product of choice:

1 "Calculating the VIX in Excel" by Tom Arnold and John H. Earl, available for free download from SSRN.

2  Derivatives: Markets, Valuation, and Risk Management (Wiley Finance) has step by step demonstration from Robert Whaley - the person who invented VIX! Book preview (with complete VIX calculation instructions) is available from google books (Appendix 15A)

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Weekly market report

Wall st delivered a mixed bag of news with VIX, VNKY, and VSTOXX and their underlying markets almost unchanged. VXD - volatility index based...

  • Simple Trick to Convert Volatility
    As I am sure all of you know Russia has began a full scale war against my home country Ukraine. Please make no mistake - Putin's goal ...
  • Volatility and Price of a Straddle, Are They The Same?
    Yesterday I found another piece of ignorance on Medium: Stop Watching The VIX, Just Make Your Own tl;dr : Just use ATM straddles 🤦 This is...
  • DVOL Futures
    The biggest news this week is that Deribit is moving ahead with launching futures on their DVOL Bitcoin volatility index. Like with every ne...