Workspaces

Thom Hartle
Oct 12, 2018
Updated: Sep 09, 2019

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

Thom Hartle
Apr 10, 2018
Updated: Aug 30, 2019

This article walks through the details of using three Microsoft Excel® functions: RANK, COUNTIF, and VLOOUP. These functions are used to build an Excel dashboard that automatically ranks a collection of markets based on percent net change and... more

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
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