Workspaces

Thom Hartle
Apr 17, 2017

This Microsoft Excel® spreadsheet presents Globex crude oil market data and forward curves. The data includes outrights, exchange-traded calendar spreads, and butterfly spreads. The exchange-traded calendar spreads include the following... more

Thom Hartle
Apr 12, 2017

CQG Integrated Client and CQG QTrader version 2017 include Footprint® Charts and Studies, allowing customers to view the popular Delta Bar chart and related studies.

One study is the Footprint Bar Statistic applied to the Footprint chart.... more

Thom Hartle
Apr 07, 2017

This Microsoft Excel® dashboard scans the options on soybeans, wheat, and corn (Globex) futures markets for volume. It displays strikes ranked by the volume traded for each expiry listed. The scan covers options traded ten strikes above... more

Thom Hartle
Apr 03, 2017

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 28, 2017

CQG version 2017 includes updates to the volume study, available for various chart types. This overview of the RTD volume study formulas includes the new parameters that the MarketDelta Footprint® Studies use.

The Setup... more

Thom Hartle
Mar 21, 2017

This Microsoft Excel® dashboard displays market data for grain spreads traded on the Globex 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 the... more

Thom Hartle
Mar 13, 2017

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

Thom Hartle
Mar 06, 2017

This Microsoft Excel® spreadsheet pulls market data from CQG Integrated Client or CQG QTrader. There is a Symbols tab where you can enter the symbols, the parameter for decimal formatting, and the title for each group of quotes on the main... more

Thom Hartle
Feb 27, 2017

This article shows RTD formulas for pulling values into Microsoft Excel® that are a study applied to a study.

A common use of Excel with CQG is to pull in study data, such as the average true range study:

= RTD("cqg.rtd",,"... more

Thom Hartle
Feb 22, 2017

This macro-enabled Microsoft Excel® spreadsheet presents a ten-by-ten correlation matrix, a scattergram chart of the correlations by row, and frequency distribution charts of the correlations. In addition, twenty versions using a different city... more