CQG charts have a setting called the BATS Charts Preferences. Here, you select what data to use to build the chart. You can use the default setting where the chart is built using trade and settlement data. You can uncheck Use default ... more
Sep 25, 2017
Sep 07, 2012
This spreadsheet outlines the basic syntax of RTD formulas and then details more complex formulas. Included is a collection of popular RTD formulas, which you can simply copy and paste into your own spreadsheet.
*Requires Microsoft... more
Sep 07, 2012
This spreadsheet provides a list of all available labels in market data in all types of contracts, including synthetic spreads. Orders and related statistics data include number of filled orders, open position, open trade equity, and... more
Nov 05, 2012
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 requesting a set of historical study values created in... more
Feb 01, 2013
To access the RTD feature in CQG Trader, please contact your FCM.
This spreadsheet displays the RTD formulas needed to bring market data from CQG Trader into Microsoft Excel. Excel has a throttle that limits the amount of time between RTD... more
Mar 19, 2015
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 filled buy orders Number of filled sell orders Number... more
Mar 26, 2015
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 Greeks, provide market information that can be... more
Jul 14, 2015
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 study, the RSI. The spreadsheet pulls up to 300... more
Aug 24, 2015
This spreadsheet shows you the RTD formulas for pulling historical data into Microsoft Excel® by using dates and time. The sample spreadsheet pulls the closing price and the value of the RSI study by a date and by a time during the day. Subminute... more
Sep 16, 2015
This Microsoft Excel® spreadsheet uses the RTD correlation formula to pull historical correlation values from CQG.
You can enter the symbols for two markets, time frame, and the look-back period for the correlation analysis. The... more