Workspaces

Thom Hartle
Oct 12, 2018

This is an update to the Commitment of Traders COT Dashboards. The CFTC release reports on Saturday 9/29/2018, not Friday 9/28/2018. This update fixes that issue and also includes a new tab of 1-year, 2-year and 3-year Z-Scores of the Large Non-... more

Thom Hartle
Sep 24, 2018

This Microsoft Excel® spreadsheet pulls 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 ask, then the mid... more

Thom Hartle
Aug 16, 2018
Bring Updating Time-Series Data from Microsoft Excel® Into CQG

Included with the CQG Trading enablement for Integrated Client and QTrader is the Xl Time Series Study. Customers can now build models in Excel and import the model outputs on a real-... more

Thom Hartle
Jul 06, 2018

This Microsoft Excel® dashboard has two parts: the top half pulls the forward curves for soybeans, corn, and wheat traded on the CME Globex platform and the bottom half pulls the USDA Crop Progress Reports by date. The USDA reports are... more

Thom Hartle
Jun 18, 2018

This Microsoft Excel® dashboard presents two charts of the Nasdaq-100 futures contract and market data for the one hundred stocks that are constituents of the Nasdaq 100 Index.

The chart in the top left corner displays... more

Thom Hartle
Jun 07, 2018

You can easily hide things unnecessary items in Microsoft Excel® to open up more screen real estate. All of my published CQG-powered Excel dashboards show you an image. You may have also noticed that the Excel ribbon, formula bar, and column/row... more

Thom Hartle
May 21, 2018

This is an updated post detailing new features in the original dashboards from a previous post. The three downloadable Microsoft Excel® dashboards present a unique view of four markets. Each overlay chart displays 5-minute percent net change... more

Thom Hartle
May 07, 2018

This Microsoft Excel® spreadsheet pulls in market data for NFX WTI Crude Oil Penultimate Financial (symbol: NTQ) and NFX Brent Crude (symbol: BFQ), both traded on the NASDAQ OMX Futures Exchange (NFX).

The forward curves display... more

Thom Hartle
Apr 10, 2018

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
Mar 21, 2018

This article introduces a collection of RTD formulas that returns time values instead of market or study values.

CQG provides the time of the highest high and the time of the lowest low from the current session via RTD:

... more