Workspaces

Thom Hartle
May 09, 2022
Updated: May 11, 2022

Monitoring market data in Excel may be enhanced by including Forward Curve charts. However, there are issues with Excel charting and the purpose of this post is to offer solutions using Excel functions.

For example, if the “Last Trade” for... 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
Feb 12, 2013
Updated: Sep 27, 2022

To access the RTD feature in CQG Trader, please contact your FCM. (CQG Trader RTD only works with 32-bit Excel).

This spreadsheet displays the current last, best bid, and best ask prices for Soybeans, Corn, and Wheat traded on Globex as... more

Thom Hartle
Feb 12, 2013
Updated: Apr 14, 2022

To access the RTD feature in CQG Trader, please contact your FCM. (CQG Trader RTD only works with 32-bit Excel).

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