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

###### Oct 12, 2015

*Updated: Oct 18, 2018*

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... 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

###### Jan 02, 2018

*Updated: Sep 14, 2018*

CQG offers an Implied Volatility (ImpVol) study that allows you to pull in historical implied volatility data onto a chart. ImpVol is not the implied volatility of one particular option. CQG uses the outright contract symbol from the... more