Workspaces

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

Stan Yabroff
Jan 30, 2020
Updated: Jan 30, 2020

The pac files available below for download represent equity sectors. ;Each sector is composed of specific Exchange Traded Funds (ETF). Each EFT contains a portfolio of the individual equities that are currently held as part of that specific ETF... 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
Feb 21, 2019
Updated: Oct 28, 2019

This Microsoft Excel® dashboard tracks the 506 stocks in the S&P 500 index using CQG’s Level function. The Level function plots two lines, which identify the highest and lowest price levels attained over a defined period. The chart below... 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
Sep 22, 2015
Updated: Oct 03, 2019

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in market data for natural gas traded on CME Globex.

Twelve months of outrights, one-month, and three-month calendar spreads are displayed. The forward curves display today's... more

Thom Hartle
Sep 22, 2015
Updated: Oct 03, 2019

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

Thom Hartle
Sep 22, 2015
Updated: Oct 03, 2019

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in market data for heating oil traded on CME Globex.

The dashboard uses a matrix-style presentation with the outrights displayed along the top row and also the first contract... more

Thom Hartle
Sep 22, 2015
Updated: Sep 30, 2019

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in market data for crude oil traded on CME Globex.

The dashboard uses a matrix-style presentation with the outrights displayed along the top row and also the first contract... more

Thom Hartle
Sep 22, 2015
Updated: Sep 30, 2019

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in market data. There is a Symbols tab where you can enter the symbols and the parameter for decimal formatting.

This dashboard offers a unique format where the current market... more