Workspaces

Thom Hartle
Apr 27, 2017

This Microsoft Excel® spreadsheet presents Eurodollar market data​. The data includes ten years of quarterly contracts for outrights and exchange-traded three-month and six-month calendar spreads.

Quarterly contracts are color-... more

Thom Hartle
Apr 17, 2017

This Microsoft Excel® spreadsheet presents Globex crude oil market data and forward curves. The data includes outrights, exchange-traded calendar spreads, and butterfly spreads. The exchange-traded calendar spreads include the following... more

Thom Hartle
Dec 06, 2016

CQG Integrated Client and CQG QTrader customers can pull the time the high and low occurred during today’s session into a Microsoft Excel® spreadsheet using these RTD formulas:

=RTD("CQG.RTD", ,"ContractData", "EP", "... more

Thom Hartle
Nov 17, 2016

Pull historical spread data into Microsoft Excel® using RTD formulas with this sample spreadsheet. It not only pulls open, high, low, and close values into Excel, but also a study, the simple moving average of the spread.

... more
Thom Hartle
Oct 28, 2016

This Microsoft Excel® dashboard offers four charts displaying seventy-five open, high, low, and close bars of a spread. The spread symbols are entered into Excel on the symbols tab and the time frame is set for the charts. The RTD formulas... more

Thom Hartle
Feb 22, 2016

This Microsoft Excel® dashboard displays both outrights and individual three-month calendar spreads and their individual legs for tracking the rolls. The markets covered are the Globex-traded Eurodollar together with the ICE-traded Euribor and... more

Thom Hartle
Feb 18, 2016

This Microsoft Excel® dashboard displays individual Euribor 3-month calendar spreads and their individual legs for tracking the rolls. All of the active deliveries for each individual symbol are displayed in a single dashboard detailing market... more

Thom Hartle
Feb 16, 2016

This Microsoft Excel® dashboard displays market data for RBOB Gasoline spreads traded on the CME Globex platform. This monitor uses a matrix style format. The outrights are along the top row and the start of each row. The best bid and best ask... more

Thom Hartle
Feb 11, 2016

This Microsoft Excel® dashboard displays individual Short Sterling three-month calendar spreads and their individual legs for tracking the rolls. All of the active deliveries for each individual symbol are displayed in a single dashboard... more

Thom Hartle
Feb 09, 2016

This Microsoft Excel® dashboard displays market data for heating oil spreads traded on the CME Globex platform. This monitor uses a matrix style format. The outrights are along the top row and the start of each row. The best bid and best ask are... more