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
Aug 16, 2017
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
Mar 10, 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
Oct 12, 2018
This is an update to the Commitment of Traders COT Dashboards.
These Microsoft Excel® dashboards pulls legacy Commitment of Traders data from the CFTC website. After the latest report is published on Friday, the historical data tables in... more
Mar 30, 2015
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
Feb 21, 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
May 03, 2017
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
Sep 22, 2015
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
Sep 22, 2015
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
Sep 22, 2015
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