CQG Integrated Client customers can set up custom sessions for their charts. For example, NYSE’s trading hours are from 8:30 to 15:00. The primary session for the E-mini S&P opens at 8:30, but… more
Workspaces
CQG customers who create their own custom studies can easily use RTD to pull custom study values into Excel.
There are only two unique requirements in the RTD formula for a custom study:… more
This article shows RTD formulas for pulling values into Microsoft Excel® that are a study applied to a study.
A common use of Excel with CQG is to pull in study data, such as the… more
CQG Integrated Client and CQG QTrader customers can pull the time the high and low occurred during today’s session into a Microsoft Excel® spreadsheet using these RTD formulas:… more
The Microsoft Excel® RTD Studies sample offers a collection of RTD CQG study formulas applied to the Bar chart type. If you want to use other chart types, such as no gap or constant volume… more
When pulling a study value into Excel using RTD, you may not see the same value in Excel that you see on a chart. It is important that the RTD formula uses the same parameters as applied to the… more
This Microsoft Excel® spreadsheet uses RTD market data functions that call the daily open, high, low, and close by dates to automatically update the bottom of the table with today's market data.… more
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… more
Four new chart types have been added to CQG. This article details the RTD formulas for calling market and study data into Excel using these new chart types. The chart types are:
Heikin-Ashi… moreThis 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… more