Compare Toolkits


CQG XL Toolkit for Excel*

CQG RTD Toolkit for Excel**

CQG XLS Trader Toolkit for Excel***


Connects Excel via CQG's Webapi to CQG Servers for data Connects Excel via Installed RTD DLL to CQG IC or QTrader for data Connects Excel via the CQG Trading API to the CQG Gateway for trade routing and order management

Access & Pricing

Contact your FCM for enablement Free download for CQG IC and CQG QTrader Enablements required:

  • CQG IC
    • XLS Trader
    • Backtesting
    • CQG Trading (included with CQG Spreader)
Information Number of available functions for each product
Account Data 7 Functions NA NA
Account Summary 5 Functions NA NA
Back Office NA NA 6 Functions
Chart Type Data NA 4 Chart Types NA
Commodities List NA 7 Functions NA
Contract Label Data 75 Functions 299 Functions NA
Derivatives List NA 3 Functions NA
DOM Data 4 Functions 4 Functions NA
Exchange List NA 4 Functions NA
Execution Instructions NA NA 9 Functions
Logs NA NA 6 Functions
Order Monitoring 21 Functions 22 Functions 23 Functions
Orders Working NA NA 9 Functions
Positions 6 Functions 8 Functions NA
Study Data NA 6 Studies NA
Symbols List NA   NA
Trade System NA NA 8 Functions
Utility NA NA 9 Functions
Excel Version 32- and 64-Bit Excel 2013 or higher 32- and 64-Bit Excel 2013 or higher Strongly recommended:
Microsoft Office Professional Excel 2016, 2019, 32 or 64-bits installed on your computer, not in the Cloud.

*The CQG XL Toolkit uses the CQG Web API to connect Excel to CQGs’ servers. The Exchanges view that as a separate connection from IC or QTrader and you have to pay additional fees if you pull market data simultaneously. You can pull in just orders and positions data using the XL Toolkit at no additional Exchange fees.

**In addition to the CQG RTD Toolkit for Excel functions, much more market and study data are obtainable using a wide array of additional RTD formulas. This includes all chart types (limited Market Profile data), studies data from chart displays and market data available through CQG quote displays. Learn more.

***CQG’s XLS Trader UDFs and CQG’s RTD functions can work within the same spreadsheet. This means that you can pull in market and study data from CQG using RTD functions, build sophisticated models that resolve to conditions and those conditions can be the basis for executing and managing orders using XLS Trader.

Microsoft Excel is a registered trademark of Microsoft Corporation in the United States and/or other countries.