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
Mar 30, 2015
Sep 22, 2015
This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in natural gas market data traded on the CME Globex exchange. It uses a matrix style presentation with the outrights displayed along the top row and also the first contract listed for... more
Apr 23, 2015
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
Nov 20, 2014
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
May 19, 2015
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
May 04, 2015
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
Apr 20, 2015
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
Jan 20, 2015
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
Sep 07, 2012
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
Feb 01, 2013
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