Workspaces

Thom Hartle
Jan 20, 2015
Updated: Apr 16, 2019

These two Microsoft Excel® spreadsheets present market data and forward curves of the Globex Crude Light Oil and ICE Brent Crude Oil contracts. The data includes the outrights, exchange-traded calendar spreads, and synthetic butterfly spreads for... more

Thom Hartle
May 08, 2017
Updated: Apr 15, 2019

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the iShares Core S&P U.S. Growth ETF (symbol: IUSG). The iShares Core S&P U.S. Growth ETF seeks to track the investment results of an index composed of large- and mid-... more

Thom Hartle
Feb 21, 2019
Updated: Apr 05, 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
Jul 27, 2017
Updated: Apr 03, 2019

This Microsoft Excel® spreadsheet tracks the constituents of the DJIA Index (symbol: DJIA).

Throughout the trading session, the thirty individual stocks are dynamically ranked and displayed in the histogram bar chart with their respective... more

Thom Hartle
Nov 21, 2017
Updated: Apr 01, 2019

You can use LocalHour and LocalMinute functions in the RTD formula to pull in the open price for a market using a 5-minute bar at 12:00. This technique was detailed in a previous article here.

If you are pulling in a large amount... more

Thom Hartle
Aug 16, 2018
Updated: Apr 01, 2019
Bring Updating Time-Series Data from Microsoft Excel® Into CQG

The XL Real-Time study is included in CQGIC subscriptions enabled for CQG Trading, or Spreader, as well as CQG Spreader systems. The XL Real-Time Study is available to base CQGIC (... more

Thom Hartle
Feb 01, 2019
Updated: Apr 01, 2019

This Microsoft Excel® dashboard tracks the 104 stocks in the Nasdaq-100 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 shows... more

Thom Hartle
Oct 12, 2018
Updated: Mar 25, 2019

This is an update to the Commitment of Traders COT Dashboards. This update works with the new schedule used by the CFTC due to the recent government shutdown.

The dashboards include Z-Scores. Z-Scores are last value minus the average value... more

Thom Hartle
Mar 18, 2019
Updated: Mar 22, 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: Mar 21, 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