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
Feb 21, 2019
May 03, 2017
This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the Guggenheim 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
Aug 16, 2017
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
Apr 23, 2015
This Microsoft Excel® spreadsheet presents a 10-by-10 correlation matrix. In addition, a dynamically ranked view of the correlations from the 10-by-10 correlation matrix is displayed as histogram bars. The histogram bars are separated into the... more
Oct 12, 2018
This is an update to the Commitment of Traders COT Dashboards. This update works with the new schedule used by the CFTC due to the recent government shutdown.
The dashboards include Z-Scores. Z-Scores are last value minus the average value... more
Jun 25, 2019
Delta Bars or DBars is a MarketDelta study which is used with the MarketDelta Footprint chart.
Delta is the difference between buys and sells. Delta Bars, displayed as candles, are colored based on bids and asks. Using default... more
Mar 18, 2019
This Microsoft Excel® dashboard pulls in the Eurodollar market data traded on the CME Globex platform.
There are three forward curve charts. The first one displays the quarterly contracts forward curves, the second display is... more
Mar 21, 2019
This Microsoft Excel® dashboard pulls in the Euribor market data traded on the ICE platform.
There are three forward curve charts. The first one displays the quarterly contracts forward curves, the second display is the one-year... more
Jun 12, 2019
This Microsoft Excel® dashboard pulls in the Short Sterling market data traded on the ICE platform. There are three forward curve charts. The first chart displays the quarterly contracts forward curves, the second chart displays the one-year... more
Nov 20, 2014
In order to smoothly transition from DDE to RTD, CQG provides a tool that converts all DDE-coded spreadsheets into RTD format. This zip file contains the converter for updating DDE coding in Excel to RTD language and includes a DLL necessary to... more