Workspaces

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