Excel

Workspaces

Customers using our flagship product, CQG Integrated Client (CQG IC), have access to a new study called Algo Orders. Using a proprietary algorithm, this indicator of trading activity detects and exposes hidden volume (iceberg orders) on the... more

Workspaces

Customers using our flagship product, CQG Integrated Client (CQG IC), have access to a new study called Algo Orders. Using a proprietary algorithm, this trading activity indicator detects and exposes hidden volume (iceberg orders) on the market.... more

Workspaces

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in natural gas market data traded on the CME Globex exchange. It uses a matrix style presentation with the outrights displayed along the top row and also the first contract listed for... more

Events

View this webinar to learn about the new CQG Toolkit for Excel. Backed by CQG's WebAPI, this add-in allows you to pull real-time market information and your orders and positions data via the Internet into Excel.

Director of Product... more

Workspaces

This Microsoft Excel® spreadsheet is an updated version of the CQG-Powered Excel Horizontal DOM Dashboard, which also includes a set of candlestick bars of today's performance for a portfolio of markets. The data is percentage adjusted, enabling... more

Workspaces

This Microsoft Excel® spreadsheet is a dynamically ranked performance dashboard of the top and bottom twenty performing SPDR®​ ETFs traded on the NYSE exchange. One hundred and twenty-two ETFs are tracked throughout the trading day. The top... more

Workspaces

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

Workspaces

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

Workspaces

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

Workspaces

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