Workspaces

Thom Hartle
Aug 16, 2017
Updated: Mar 23, 2020

This Microsoft Excel® dashboard provides a drop-down menu where you can select the underlying market, such as E-mini S&P 500. The display will then show all front contract option symbols, including weekly and end-of-month options. The... more

Thom Hartle
Mar 12, 2020
Updated: Mar 12, 2020

CQG has added the CFTC Commitment of Traders data to the data feed. You can read about working with COT symbols here.

If you are interested in pulling the latest COT updates and historical data using RTD formulas there are a couple of... more

Thom Hartle
Mar 30, 2015
Updated: Jan 29, 2020

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
May 03, 2017
Updated: Oct 25, 2019

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the Invesco S&P 500® Equal Weight Technology ETF (symbol: RYT). This ETF seeks to replicate, before fees and expenses, the performance of the S&P 500® Equal Weight... more

Thom Hartle
Apr 10, 2018
Updated: Aug 30, 2019

This article walks through the details of using three Microsoft Excel® functions: RANK, COUNTIF, and VLOOUP. These functions are used to build an Excel dashboard that automatically ranks a collection of markets based on percent net change and... more

Thom Hartle
Apr 23, 2015
Updated: Jul 23, 2019

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
Nov 20, 2014
Updated: Jun 17, 2019

In order to smoothly transition from DDE to RTD, CQG provides a tool that converts all DDE-coded spreadsheets into RTD format. This zip file contains the converter for updating DDE coding in Excel to RTD language and includes a DLL necessary to... more

Thom Hartle
Jun 12, 2019
Updated: Jun 12, 2019

Customers using our flagship product, CQG Integrated Client (CQG IC) or QTrader, 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... more

Thom Hartle
Jun 12, 2019
Updated: Jun 12, 2019

Customers using our flagship product, CQG Integrated Client (CQG IC) or QTrader, 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... more

Thom Hartle
Jun 12, 2019
Updated: Jun 12, 2019

Customers using our flagship product, CQG Integrated Client (CQG IC) or QTrader, 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... more