Workspaces

Thom Hartle
Apr 23, 2018

These two Microsoft Excel® dashboards present a unique view of the market. Each chart displays 5-minute percent net change lines from the previous day’s close for today and the previous nine days. Today’s price action is a white line and is... more

Thom Hartle
Apr 10, 2018

This article walks through the details of using three Microsoft Excel® functions: RANK, COUNTIF, and VLOOUP. These functions are used to build an Excel dashboard that automatically ranks a collection of markets based on percent net change and... more

Thom Hartle
Mar 21, 2018

This article introduces a collection of RTD formulas that returns time values instead of market or study values.

CQG provides the time of the highest high and the time of the lowest low from the current session via RTD:

... more
Thom Hartle
Mar 09, 2018

This Microsoft Excel® dashboard displays market data for a user-selected symbol. The standard market data includes the CQG Algo Orders study, which is only available in CQG’s flagship product, CQG Integrated Client (CQG IC). This study monitors... more

Thom Hartle
Feb 20, 2018

Various markets have different times for their trading sessions. Some markets, such as the Bund contract (symbol: DB) traded on Eurex, has only one session. Other markets, such as the E-mini S&P 500 contract (symbol: EP) traded on the CME... more

Thom Hartle
Jan 24, 2018

This Microsoft Excel® spreadsheet pulls in five Imoku studies along with open, high, low, and close bar values. You can change the symbol and the time frame. You can retrieve up to 300 daily bars and up to 3,000 intraday bar values. The... more

Thom Hartle
Jan 12, 2018

This Microsoft Excel® dashboard displays market data for eight user-selected symbols. The symbols must be entered in uppercase format.

The dashboard displays the following data:

Long description Price with the largest traded... more
Thom Hartle
Jan 05, 2018

Customers using our flagship product, CQG Integrated Client (CQG IC), have access to a new study called Algo Orders. Using a proprietary algorithm, this indicator of trading activity detects and exposes hidden volume (iceberg orders) in the... more

Thom Hartle
Jan 02, 2018

CQG offers an Implied Volatility (ImpVol) study that allows you to pull in historical implied volatility data onto a chart. ImpVol is not the implied volatility of one particular option. CQG uses the outright contract symbol from the... more

Thom Hartle
Dec 12, 2017

CQG offers a collection of conditions you can use to mark points on a chart when the condition is met. In addition, you can create your own custom conditions. You can easily bring conditions into Excel using RTD formulas. Excel displays a 1... more