Workspaces

Thom Hartle

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

Thom Hartle

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

Thom Hartle

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

Thom Hartle

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

Thom Hartle

This Microsoft Excel® spreadsheet uses the RTD correlation formula to pull historical correlation values from CQG.

You can enter the symbols for two markets, time frame, and the… more

Thom Hartle

Four new chart types have been added to CQG. This article details the RTD formulas for calling market and study data into Excel using these new chart types. The chart types are:

Heikin-Ashi… more
Thom Hartle

This Microsoft Excel® spreadsheet is a modified version of the Dynamically Ranked SPDR® ETFs Dashboard. This version allows you to enter in the symbols you want using the symbols tab. The top… more

Thom Hartle

This spreadsheet shows you the RTD formulas for pulling historical data into Microsoft Excel® by using dates and time. The sample spreadsheet pulls the closing price and the value of the RSI study… more

Thom Hartle

This Microsoft Excel® dashboard displays volume and open interest data for soybeans, soybean meal, and soybean oil contracts for tracking the rolls. All of the active deliveries for each… more

Thom Hartle

This spreadsheet allows you to pull historical data into Microsoft Excel® using RTD formulas. The sample spreadsheet pulls open, high, low, close, contract volume, contract open interest and one… more