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 ...
  • Intuitive Understanding Of VIX Formula
    Many investors are looking at VIX and VSTOXX indexes as a leading indicators of volatility in equity markets, however many are confused by t...
  • 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...