Workspaces

Thom Hartle
Mar 10, 2020
Updated: May 01, 2020

CQG has added the CFTC Commitment of Traders reports to the data feed. Under Exchanges in the CQG Symbol Finder you can find “CFTC Commitment of Traders.”

An easy way to find the market you are interested in is to select CFTC... more

Thom Hartle
Aug 16, 2017
Updated: Apr 29, 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
Jul 27, 2017
Updated: Apr 07, 2020

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
Mar 31, 2020
Updated: Mar 31, 2020

CQG has added United States Department of Agriculture (USDA) data and the World Agricultural Supply and Demand Estimates (WASDE) data to the data feed. Look for the data under the Exchanges list in the CQG Symbol Finder. You can chart the data... 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

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