Workspaces

Marcus Kwan
Jan 30, 2017

This CQG M dashboard layout displays a portfolio of symbols from the Americas (available with a subscription to the CME Globex feed on CQG) in a heat-map style. Tapping on a quote pushes the symbol to the chart displaying Bollinger Bands,... more

Thom Hartle
Jan 23, 2017

This Microsoft Excel® dashboard displays Delta Bars with a price ladder detailing the executed volume by price for the current Delta Bar. Also, an intraday bar chart is included with a price ladder showing the executed volume by price for the... more

Thom Hartle
Jan 17, 2017

CQG formulas include a crossover feature, and CQG can determine the number of completed bars back since a signal occurred. For example, using “Barssince(EP xabove Ma(EP,Sim,20),1,300)” as the symbol in a standard RTD formula for the close... more

Thom Hartle
Jan 10, 2017

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

Thom Hartle
Dec 29, 2016

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
Dec 20, 2016

A common request is an RTD formula to pull historical settlement prices for a particular market. There is a “Contract Data” RTD formula for settlement:

=RTD("CQG.RTD", ,"ContractData", "CLE", "Settlement",, "T")

However, “Contract... 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 28, 2016

With the addition of the Footprint® Charts and Studies by MarketDelta to CQG Integrated Client and CQG QTrader, customers can pull volume data traded by price into Excel.

To pull in the data, we used the RTD formula:

=RTD("... more

Thom Hartle
Nov 23, 2016

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
Nov 21, 2016

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