If you use RTD formulas for data from the options markets, then Excel will pull data using your settings in CQG, such as the options model you have selected. An RTD formula for implied volatility will pull the Implied Volatility (IV) for the... more

# Workspaces

###### May 19, 2015

*Updated: May 15, 2019*

This Microsoft Excel® dashboard uses the CQG RTD OptVal formula to calculate implied volatility, theoretical value, delta, and the Greeks using data inputs from other RTD formulas.

For example, the implied volatility calculation is... more

###### Sep 26, 2014

*Updated: Sep 14, 2018*

This Microsoft Excel® dashboard displays the first two months' expiries of the KOSPI 200 options. Last price, net change, percent net change, implied volatility using Black-Scholes, and today's and yesterday's volume data are automatically... more

###### Feb 02, 2015

*Updated: Sep 14, 2018*

This Microsoft Excel® spreadsheet presents frequency distribution analysis of historical implied volatility (IV) data.

CQG offers its own historical options implied volatility index for popularly traded options on futures. The symbol... more

###### Mar 26, 2015

*Updated: Sep 14, 2018*

Options offer a wide variety of strategies for traders. CQG provides a powerful options analytics package. A number of the analytics tools, such as theoretical value, implied volatility, and the Greeks, provide market information that can be... more

###### Apr 15, 2015

*Updated: Aug 25, 2016*

You can use Microsoft Excel® and data from CQG to expand the features of your own market display dashboards. This powerful combination can be tailored to your specific needs. This article shows you how to build an Excel dashboard and provides a... more