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:
|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|
|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|
|Trade System||NA||NA||8 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.