Workspaces

Aug 18, 2017
Updated: Aug 23, 2017

Welcome to CQG. Here is some important information to get you started. If you need help logging on, review these steps.

Main Window

Once you have logged on, you see the main window.

You may want to familiarize yourself with the... more

Thom Hartle
Aug 16, 2017
Updated: Apr 26, 2022

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
Aug 15, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard scans the VIX (CBOE) options market for volume and displays the strikes ranked by the volume traded for each expiry listed. The scan covers options traded 15 strikes above and below the at-the-money option. The... more

Thom Hartle
Aug 10, 2017
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet tracks the front month contracts of the PowerShares® DB Commodity Index (symbol: DBC) holdings. The actual ETF holds deferred contracts. More information about ETF can be found here.

The PowerShares DB... more

Thom Hartle
Aug 07, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard displays the cash indices available from the Hang Seng Indexes Company.

The quote displays are divided into four sections. The first section is the cash Hang Seng Indices. Net percent change is heat mapped.... more

Thom Hartle
Aug 01, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard scans the options on futures for the H-shares Index (HHI) and ranks the traded volume for each expiry out to nine expirations. The scan covers options traded ten strikes above and below the at-the-money option... more

Thom Hartle
Jul 27, 2017
Updated: Apr 09, 2021

This Microsoft Excel® spreadsheet tracks the constituents of the DJIA Index (symbol: DJIA).

Throughout the trading session, the thirty individual stocks are dynamically ranked and displayed in the histogram bar chart with their respective... more

Thom Hartle
Jul 25, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard scans the Hang Seng Index market options on futures and ranks the traded volume for each expiry out to eleven expirations. The scan covers options traded ten strikes above and below the at-the-money option. The top... more

Thom Hartle
Jul 20, 2017
Updated: Sep 14, 2018

In this article, we outline how to pull historical market data into Excel while excluding data from days when the market was in a holiday session.

Holiday sessions are trading dates, but not clearing dates. Holiday session data is... more

Thom Hartle
Jun 30, 2017
Updated: Sep 14, 2018

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the SPDR® S&P® Bank ETF (symbol: KBE).

Throughout the trading session, the individual stocks are dynamically ranked. The main display shows the top and bottom... more