Workspaces

Thom Hartle
Mar 30, 2015

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

Thom Hartle
Mar 26, 2015

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

Thom Hartle
Mar 19, 2015

This Microsoft Excel® spreadsheet uses RTD formulas to pull today's basic orders and positions information from CQG.

Orders and positions data available include:

Number of filled buy orders Number of filled sell orders Number... more
Thom Hartle
Mar 12, 2015

This Microsoft Excel® spreadsheet offers a unique format where the current market data is displayed as borders around the chart information. The markets are heat-mapped based on percent net change. The heat-mapping is applied to the contract... more

Thom Hartle
Mar 05, 2015

This Microsoft Excel® spreadsheet presents market data and forward curves of the Globex RBOB Gasoline contracts. The data includes the outrights, exchange-traded calendar spreads, and synthetic butterflies. The butterfly spread quotes use CQG's... more

Thom Hartle
Feb 26, 2015

This Microsoft Excel® spreadsheet is an updated version of the CQG-Powered Excel Horizontal DOM Dashboard, which also includes a correlation display. Two histogram charts have been added to each of the three chart displays. These two histogram... more

Thom Hartle
Feb 19, 2015

This Microsoft Excel® spreadsheet presents two views of current market data and two correlation matrices. The market data sections use the symbols entered into the first column. The last quoted price and net change are displayed. In addition, the... more

Thom Hartle
Feb 13, 2015

This Microsoft Excel® spreadsheet presents market data and forward curves of the Euribor, Eurodollar, and Short Sterling contracts. The data includes the outrights and exchange-traded quarterly calendar spreads.

The forward curves... more

Thom Hartle
Feb 06, 2015

This Microsoft Excel® spreadsheet presents market data and forward curves of the Globex heating oil contracts. The data includes the outrights, exchange-traded calendar spreads, and synthetic butterfly. The butterfly spread quotes use CQG's... more

Thom Hartle
Feb 02, 2015

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