Workspaces

Thom Hartle
Sep 22, 2015
Updated: Feb 15, 2019

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in WTI Light Sweet Crude Oil market data traded on the ICE exchange.

The dashboard uses a matrix-style presentation with the outrights displayed along the top row and also the... more

Thom Hartle
Feb 12, 2013
Updated: Sep 14, 2018

To access the RTD feature in CQG Trader, please contact your FCM.

This spreadsheet displays the current market data, last price, best bid, and best ask for three crude oil markets: Light Sweet Crude Oil traded on Globex, Brent Crude Oil... more

Thom Hartle
Sep 22, 2015
Updated: Sep 14, 2018

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 are displayed. The forward curves display today's... more

Thom Hartle
Sep 22, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in market data for crude oil traded on CME Globex.

Twelve months of outrights, one-month, and three-month calendar spreads are displayed. The forward curves display today's... more

Thom Hartle
Sep 22, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in Brent Crude Oil and WTI Light Sweet Crude Oil market data traded on the ICE exchange.

The forward curves display today's data. If the last price is outside of the best bid... more

Thom Hartle
Sep 22, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in Brent Crude Oil market data traded on the ICE exchange.

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
Jul 12, 2016
Updated: Sep 14, 2018

This Microsoft Excel® dashboard displays market data for Short Sterling calendar spreads traded on the ICE platform. This monitor uses a matrix-style format. The outrights are displayed along the top row and at the start of each row. The best bid... more

Thom Hartle
Jul 12, 2016
Updated: Sep 14, 2018

This Microsoft Excel® dashboard displays market data for Short Sterling calendar spreads traded on the ICE platform. This monitor uses a matrix-style format. The outrights are displayed along the top row and at the start of each row. The best bid... more

Thom Hartle
Oct 06, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard has three tabs. The first tab displays today’s market quotes, volume, and open interest data. If the last price is matching the open price, then the open price is highlighted blue. If the last price is... more

Thom Hartle
Sep 21, 2017
Updated: Sep 14, 2018

These two Microsoft Excel® spreadsheets present Globex crude oil market data and forward curves, both current and historical. Two dashboards are available: The first the data includes outrights and exchange-traded calendar spreads using these... more