This spreadsheet allows you to pull historical data into Microsoft Excel® using RTD formulas. The sample spreadsheet pulls open, high, low, close, contract volume, contract open interest and one… more
Workspaces
This Microsoft Excel® dashboard uses the CQG RTD OptVal formula to calculate implied volatility, theoretical value, delta, and the Greeks using data inputs from other RTD formulas.
… more
You can use Microsoft Excel® and data from CQG to expand the features of your own market display dashboards. This powerful combination can be tailored to your specific needs. This article shows… more
If you use RTD formulas for data from the options markets, then Excel will pull data using your settings in CQG, such as the options model you have selected. An RTD formula for implied volatility… more
Options offer a wide variety of strategies for traders. CQG provides a powerful options analytics package. A number of the analytics tools, such as theoretical value, implied volatility, and the… more
This Microsoft Excel® spreadsheet uses RTD formulas to pull today's basic orders and positions information from CQG.
Orders and positions data available include:
Number of… moreTo help you design and manage your custom dashboards using CQG with Microsoft Excel®, Thom Hartle has written the following articles that answer the most common questions.
Topic Description… moreCustomers worldwide use CQG to deliver data to Microsoft Excel® via RTD calls. Operating System (OS) localization translates the application into another language. Some Excel syntax is different… more
To access the RTD feature in CQG Trader, please contact your FCM. (CQG Trader RTD only works with 32-bit Excel).
This spreadsheet displays the RTD formulas needed to bring market data from… more
This spreadsheet provides a list of RTD formulas for historical bars and charting, requesting study data and study-related curves, calling a set of historical bars of all supported types, and… more