Workspaces

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

Thom Hartle
Feb 13, 2017

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
Feb 08, 2017

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

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
Jan 31, 2017

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

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