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:

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… more

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