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
Workspaces
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… more
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
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… more
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
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
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
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
This Microsoft Excel® dashboard displays market data for cocoa spreads traded on the ICE platform using a matrix-style format. The outrights are along the top row and at the start of each row. The… more
This Microsoft Excel® dashboard displays market data for coffee spreads traded on the ICE platform using a matrix-style format. The outrights are along the top row and at the start of each row.… more