Workspaces

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

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

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 31, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard displays market data for crude oil spreads traded on the ICE platform using a matrix-style format. The outrights are along the top row and the start of each row. The best bid and best ask are also included. If... more

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

This Microsoft Excel® dashboard displays market data for crude oil spreads traded on the ICE platform using a matrix-style format. The outrights are along the top row and the start of each row. The best bid and best ask are also included. If... more

Thom Hartle
Feb 08, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard displays 90-day bank bills and exchange-traded spreads traded on ASX. The inside market for the front six contracts is detailed along the top. The open, high, low, and last, along with the net change, volume, and... more

Thom Hartle
Feb 13, 2017
Updated: Sep 14, 2018

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

Thom Hartle
Apr 03, 2017
Updated: Sep 14, 2018

CQG Integrated Client and CQG QTrader version 2017 include the popular Footprint® Charts and Studies.

The primary focus of the chart type is to organize and display the volume traded at each price and provide an indication of its... more

Thom Hartle
Mar 13, 2017
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet is a combination of market quotes and dynamic ranking. There is a Symbols tab where you can enter the symbols and the parameter for decimal formatting, or you can enter B for bonds and fractions. You can set the... more