Compare Toolkits

 

CQG XL Toolkit for Excel*

CQG RTD Toolkit for Excel**

CQG XLS Trader Toolkit for Excel***

Description

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

Included with CQG Integrated Client 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

Bar chart data

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.