Workspaces

Thom Hartle
Oct 12, 2018
Updated: Oct 11, 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
May 03, 2017
Updated: Oct 10, 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
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

Thom Hartle
Sep 22, 2015
Updated: Oct 03, 2019

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

Thom Hartle
Sep 22, 2015
Updated: Oct 03, 2019

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

Thom Hartle
Sep 22, 2015
Updated: Sep 30, 2019

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in market data for crude 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

Thom Hartle
Sep 22, 2015
Updated: Sep 30, 2019

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in market data. There is a Symbols tab where you can enter the symbols and the parameter for decimal formatting.

This dashboard offers a unique format where the current market... more

Thom Hartle
Sep 22, 2015
Updated: Sep 20, 2019

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in live cattle, feeder cattle, and lean hogs market data traded on CME Globex.

The forward curves display today's data. If the last price is outside of the best bid and best... 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