Workspaces

Thom Hartle

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… more

Thom Hartle

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… more

Thom Hartle

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… more

Thom Hartle

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… more

Thom Hartle

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.… more

Thom Hartle

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… more

Thom Hartle

You can use LocalHour and LocalMinute functions in the RTD formula to pull in the open price for a market using a 5-minute bar at 12:00. This technique was detailed in a previous article here.… more

Thom Hartle

This Microsoft Excel® dashboard scans options on the E-mini S&P 500 futures market using the CQG RTD Toolkit for volume and displays strikes ranked by the volume traded for each listed expiry… more

Thom Hartle

There are numerous Excel samples that walk you through bringing various market data into Excel using RTD formulas. However, there is a lot to look through. One solution is to use the CQG Formula… more

Thom Hartle

Customers who use Microsoft Excel® when following the markets can easily populate their Excel spreadsheet with RTD formulas using CQG's Quote SpreadSheet (QSS) 2.0.

To open QSS 2.0, click… more