Workspaces

Thom Hartle
Feb 07, 2019
Updated: Feb 07, 2019

If you set up a Microsoft Excel® dashboard to monitor options prices and their respective deltas you may see the delta values disappear occasionally in the dashboard. In other words, the value for the options deltas, especially far out of the... more

Thom Hartle
Feb 01, 2019
Updated: Dec 22, 2020

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
Jan 23, 2019
Updated: Jan 23, 2019

After the current trading session ends, many exchanges clear out today’s market data to set up for the preopening posting of orders to the exchange's order book. This includes today’s open, high, low, and close. In effect, the exchange moved... more

Thom Hartle
Sep 24, 2018
Updated: Sep 22, 2022

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
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
Jun 18, 2018
Updated: Dec 22, 2020

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
Updated: 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
Updated: Sep 14, 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
Updated: Sep 22, 2022

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