Workspaces

Thom Hartle
Apr 23, 2015
Updated: Jul 23, 2019

This Microsoft Excel® spreadsheet presents a 10-by-10 correlation matrix. In addition, a dynamically ranked view of the correlations from the 10-by-10 correlation matrix is displayed as histogram bars. The histogram bars are separated into the... more

Thom Hartle
Nov 20, 2014
Updated: Jun 17, 2019

In order to smoothly transition from DDE to RTD, CQG provides a tool that converts all DDE-coded spreadsheets into RTD format. This zip file contains the converter for updating DDE coding in Excel to RTD language and includes a DLL necessary to... more

Thom Hartle
May 19, 2015
Updated: May 15, 2019

This Microsoft Excel® dashboard uses the CQG RTD OptVal formula to calculate implied volatility, theoretical value, delta, and the Greeks using data inputs from other RTD formulas.

For example, the implied volatility calculation is... more

Thom Hartle
May 04, 2015
Updated: May 15, 2019

This Microsoft Excel® dashboard offers an automatic performance ranking of exchange-traded funds (ETFs) that is focused on equity performance by country. This dashboard requires the NYSE enablement.

The top symbol row automatically... more

Thom Hartle
Apr 20, 2015
Updated: May 15, 2019

This Microsoft Excel® dashboard looks for forty strikes above and below the ATM. Features also include a theoretical value column. If the current best bid is higher than the theoretical value, the best bid is highlighted green. If the best ask is... more

Thom Hartle
Jan 20, 2015
Updated: Apr 16, 2019

These two Microsoft Excel® spreadsheets present market data and forward curves of the Globex Crude Light Oil and ICE Brent Crude Oil contracts. The data includes the outrights, exchange-traded calendar spreads, and synthetic butterfly spreads for... more

Thom Hartle
Sep 07, 2012
Updated: Sep 14, 2018

This spreadsheet outlines the basic syntax of RTD formulas and then details more complex formulas. Included is a collection of popular RTD formulas, which you can simply copy and paste into your own spreadsheet.

*Requires Microsoft... more

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

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

This dashboard allows you to change symbols as well as enter a value for the high-low alert (HLAlert). If the last price is within the value of the high or low prices, then... more

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

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

This spreadsheet displays the RTD formulas needed to bring market data from CQG Trader into Microsoft Excel. Excel has a throttle that limits the amount of time between RTD... 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