Workspaces

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
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
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
Feb 21, 2019
Updated: Apr 18, 2022

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