CQG Trading Studies in Excel

Thom Hartle
Feb 05, 2016

This Microsoft Excel® dashboard uses RTD formulas to pull the following CQG Trading Studies into Excel:

Open Trade Equity Position Profit & Loss

These are study formulas and, therefore, historical data is available. However, the... more

Studies

Globex Crude Oil Gas Spreads Monitor

Thom Hartle
Feb 05, 2016

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

Crude Oil, Spreads, Monitor

Setting Studies to Share Scales

Tips and Tricks
Thom Hartle
Feb 04, 2016

Request:

My Imoku study is not lining up over the bars and using the same scale as the price. How do I correct this?

Solution:

Right-click the study, select Modify Study. Select Display. Change “ShareScale” to On. This... more

Custom Session in a Quote Display

Tips and Tricks
Thom Hartle
Feb 03, 2016

Request:

I would like to see in a quote display the same open, high, low, and close prices I see on a chart with a custom session.

Solution: Enter the symbol, then a comma followed by the time frame, and the name of the custom... more

Spread Symbology

Tips and Tricks
Thom Hartle
Feb 03, 2016

Request:

The 12m DEC16DEC17 Eurodollar and the 12m DEC16DEC17 Sterling spread should be around 2, but I see 34. Why is this?

Solution:

In CQG the EDA spread is quoted as whole numbers and QSA is quoted as a decimal.... more

Spread Bars

Tips and Tricks
Thom Hartle
Feb 03, 2016

Request:

I want to chart the DDH6-EPH6*5 spread using a Heikin-Ashi chart. On a bar chart, I just see a closing line chart and it will not work in a Heikin-Ashi chart.

Solution:

Use the Spread function:

Spread(... more

Trade System Monitor

Thom Hartle
Feb 02, 2016

This Microsoft Excel® dashboard displays trade system statistics pulled from CQG’s Backtesting module. Enter the system's “short’ name, chart time frame, and symbol

The dashboard will pull and display 125 bars of market and trade system... more

The Relationship between Gold and Crude Oil - Divergence

Commentary
Andy Hecht
Feb 01, 2016

There is a big difference between price and value. Price is a transparent number where buyers and sellers meet to transact. Value is a concept that often goes much deeper. We can all watch asset prices as they cross our screens in real time.... more

Globex Natural Gas Spreads Monitor

Thom Hartle
Jan 25, 2016

This Microsoft Excel® dashboard displays market data for natural gas spreads traded on the CME Globex platform. This monitor uses a matrix-style format. The outrights are along the top row and the start of each row. The best bid and best ask are... more

Globex Exchange-Quoted Crush Spreads Monitor

Thom Hartle
Jan 20, 2016

This Microsoft Excel® dashboard displays market data for Soybean Crush Spreads traded on the CME Globex platform. These spreads have an added layer of complexity due to the soybean contract not always having the same expiration month as the... more

Soybeans, Crush, Spreads, Commodity Spreads