Workspaces

Thom Hartle
Sep 15, 2016
Updated: Sep 14, 2018

The Microsoft Excel® RTD Studies sample offers a collection of RTD CQG study formulas applied to the Bar chart type. If you want to use other chart types, such as no gap or constant volume bars, then the solution is to include the chart type... more

Thom Hartle
Oct 28, 2016
Updated: Sep 14, 2018

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
Nov 03, 2016
Updated: Sep 14, 2018

Mark B. Fisher, founder and CEO of MBF Clearing Corp, discussed his chart and study during a joint webinar with CQG. This article further explains the study and chart type, available in CQG, as well as Mark Fisher’s trading bands... more

Stan Yabroff
Nov 08, 2016
Updated: Sep 14, 2018

The component pac at the end of this article contains holdings or components of eleven SPDR ETF portfolios. You can use a portfolio to create a quote page with a link to a chart.

You can also ... more

Thom Hartle
Nov 17, 2016
Updated: Sep 14, 2018

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
Nov 21, 2016
Updated: Sep 14, 2018

Pull historical CVB 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 Relative Strength Index.

To pull in the data, we... more

Thom Hartle
Nov 23, 2016
Updated: Sep 14, 2018

This Microsoft Excel® dashboard scans the options on the Eurodollar futures market for volume and ranks the traded volume for each expiry out to three years. The scan covers options traded ten strikes above and below the at-the money option. Then... more

Thom Hartle
Dec 06, 2016
Updated: Sep 14, 2018

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
Dec 29, 2016
Updated: Sep 14, 2018

This Microsoft Excel® dashboard scans the crude oil (GLOBEX) futures market options for volume and ranks the traded volume for each expiry out to sixteen months. The scan covers options traded ten strikes above and below the at-the... more

Thom Hartle
Jan 10, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard displays key market information for contracts traded on the CME Exchange and the Globex platform. The markets are grouped by these products:

Equity Indices Fixed Income Metals Energy Agriculture​ Forex

Two... more