Workspaces

Thom Hartle
Feb 21, 2019
Updated: Aug 20, 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: Aug 20, 2019

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

Thom Hartle
Aug 16, 2017
Updated: Aug 12, 2019

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
Apr 23, 2015
Updated: Jul 23, 2019

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

Thom Hartle
Oct 12, 2018
Updated: Jul 12, 2019

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

Thom Hartle
Jun 25, 2019
Updated: 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

Thom Hartle
Mar 18, 2019
Updated: Jun 24, 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

Thom Hartle
Mar 21, 2019
Updated: Jun 24, 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

Thom Hartle
Jun 12, 2019
Updated: Jun 24, 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

Thom Hartle
Nov 20, 2014
Updated: Jun 17, 2019

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