Workspaces

Thom Hartle
Mar 30, 2015
Updated: Jan 29, 2020

If you use RTD formulas for data from the options markets, then Excel will pull data using your settings in CQG, such as the options model you have selected. An RTD formula for implied volatility will pull the Implied Volatility (IV) for the... 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
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 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
Mar 19, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet uses RTD formulas to pull today's basic orders and positions information from CQG.

Orders and positions data available include:

Number of filled buy orders Number of filled sell orders Number... more
Thom Hartle
Mar 26, 2015
Updated: Sep 14, 2018

Options offer a wide variety of strategies for traders. CQG provides a powerful options analytics package. A number of the analytics tools, such as theoretical value, implied volatility, and the Greeks, provide market information that can be... more

Thom Hartle
Jul 20, 2017
Updated: Sep 14, 2018

In this article, we outline how to pull historical market data into Excel while excluding data from days when the market was in a holiday session.

Holiday sessions are trading dates, but not clearing dates. Holiday session data is... more

Thom Hartle
Apr 15, 2015
Updated: Aug 25, 2016

You can use Microsoft Excel® and data from CQG to expand the features of your own market display dashboards. This powerful combination can be tailored to your specific needs. This article shows you how to build an Excel dashboard and provides a... more