Workspaces

Thom Hartle
May 19, 2015

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

Thom Hartle
May 04, 2015

This Microsoft Excel® dashboard offers an automatic performance ranking of exchange-traded funds (ETFs) that is focused on equity performance by country. This dashboard requires the NYSE enablement.

The top symbol row automatically... more

Thom Hartle
Apr 23, 2015

This Microsoft Excel® spreadsheet presents a 10-by-10 correlation matrix. In addition, a dynamically ranked view of the correlations from the 10-by-10 correlation matrix is displayed as histogram bars. The histogram bars are separated into the... more

Thom Hartle
Apr 20, 2015

This Microsoft Excel® dashboard looks for forty strikes above and below the ATM. Features also include a theoretical value column. If the current best bid is higher than the theoretical value, the best bid is highlighted green. If the best ask is... more

Thom Hartle
Apr 15, 2015

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

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