Implied Volatility Smile Dashboards

These Microsoft Excel® spreadsheets determine the at-the-money option and display a table of thirty strikes above and below the at-the-money. The tables consist of market data and the implied volatilities for each of the sixty-one strikes. The volume columns are heat mapped. The histogram bar charts are implied volatility and open interest by strike price for calls and puts. You can hover your mouse over the histogram bars and a tooltip will open. You can enter a wildcard, such as "?1" or a month with a two-digit year, such as Z15.

Make sure to lower your Excel RealTimeData (RTD) throttle to 50 milliseconds or lower. Learn how to do that here.

Requires CQG Integrated Client or CQG QTrader.




Trading and investment carry a high level of risk, and CQG, Inc. does not make any recommendations for buying or selling any financial instruments. We offer educational information on ways to use our sophisticated CQG trading tools, but it is up to our customers and other readers to make their own trading and investment decisions or to consult with a registered investment advisor. The opinions expressed here are solely those of the author and do not reflect the opinions of CQG, Inc. or its affiliates.