Add-Ins for Excel

 

CQG Toolkit for Excel
(32-Bit)

The CQG Toolkit pulls today’s market and orders and positions data via the Internet into Excel. Historical data is not available. CQG products do not need to be running. This toolkit does require you to have an account with a CQG FCM partner as this is an FCM enablement. The toolkit accesses market and orders and positions information using the exchanges you are enabled to trade by your FCM.

CQG Toolkit for Excel

Features

  • Excel function-like syntax
  • Cell references that are part of the formula
  • Far more orders and positions data compared to RTD Toolkit is available, including fill prices
  • Today’s market (label) data
  • Depth-of-market data
  • Account data
  • Account summary
  • Orders data including fill prices
  • Open positions data

The market and orders and positions data is limited to 200 symbols.


CQG RTD Toolkit for Excel
(32- and 64-Bit)

CQG supports the RealTimeData (RTD) function for delivering market data and other information to Excel. Through the combination of CQG and Excel, you can create highly customized applications designed for your specific needs.

The CQG RTD Toolkit uses Microsoft’s RTD Worksheet function to pull real-time market data and other information from CQG Integrated Client and CQG QTrader.

CQG RTD Toolkit for Excel

RTD is extremely efficient and offers many advantages over Dynamic Data Exchange (DDE). With RTD, you can drive calculation formulas based on cells that reference real-time data. You can also request market data, historical data, and current working orders and positions data, including synthetic spreads.

Features

  • Excel function-like syntax
  • Cell references that are part of the formula
  • Twenty thousand unique topics, which can be updated three times per second and one topic can be updated 200 times per second
  • Twenty thousand cells for market data, 5,000 cells for historical and study data, and 500 combinations of order-related data that are supported by CQG

These limitations relate only to RTD technology, not data limitations; historical data is limited to 300 daily/weekly/monthly bars and 300 days of intraday data.

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