Workspaces

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 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 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
Oct 06, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard has three tabs. The first tab displays today’s market quotes, volume, and open interest data. If the last price is matching the open price, then the open price is highlighted blue. If the last price is... more

Thom Hartle
Sep 21, 2017
Updated: Sep 14, 2018

These two Microsoft Excel® spreadsheets present Globex crude oil market data and forward curves, both current and historical. Two dashboards are available: The first the data includes outrights and exchange-traded calendar spreads using these... more

Thom Hartle
Oct 11, 2017
Updated: Sep 14, 2018

There is an RTD call for depth-of-market (DOM) data for futures markets. You call the DOM data by symbol and queue number. You can pull the bid or ask price, bid or ask volume, and the time of the last update.

The best ask... more

Thom Hartle
Oct 16, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard presents different styles of viewing market and study information. The left-hand side is today's current market data. You can enter symbols and set the number of decimals. The HiLoAlert cell is a user-entered value... more

Thom Hartle
Oct 23, 2017
Updated: Sep 14, 2018

There are numerous Excel samples that walk you through bringing various market data into Excel using RTD formulas. However, there is a lot to look through. One solution is to use the CQG Formula Builder. You can right-click a study, hover your... more

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

This Microsoft Excel® dashboard scans options on the E-mini S&P 500 futures market using the CQG RTD Toolkit for volume and displays strikes ranked by the volume traded for each listed expiry. The scan covers options traded 15 strikes above... more

Thom Hartle
Jan 02, 2018
Updated: Sep 14, 2018

CQG offers an Implied Volatility (ImpVol) study that allows you to pull in historical implied volatility data onto a chart. ImpVol is not the implied volatility of one particular option. CQG uses the outright contract symbol from the... more