This article introduces a collection of RTD formulas that returns time values instead of market or study values.
CQG provides the time of the highest high and the time of the lowest low from the current session via RTD:... more
This Microsoft Excel® spreadsheet pulls in market data for NFX WTI Crude Oil Penultimate Financial (symbol: NTQ) and NFX Brent Crude (symbol: BFQ), both traded on the NASDAQ OMX Futures Exchange (NFX).
The forward curves display... more
This is an updated post detailing new features in the original dashboards from a previous post. The three downloadable Microsoft Excel® dashboards present a unique view of four markets. Each overlay chart displays 5-minute percent net change... more
You can easily hide things unnecessary items in Microsoft Excel® to open up more screen real estate. All of my published CQG-powered Excel dashboards show you an image. You may have also noticed that the Excel ribbon, formula bar, and column/row... more
Customers who use Microsoft Excel® when following the markets can easily populate their Excel spreadsheet with RTD formulas using CQG's Quote SpreadSheet (QSS) 2.0.
To open QSS 2.0, click the Quote button on the application toolbar, then... more
RTD formulas for chart types and studies can include the same parameter settings used in your CQG continuation charts. In the RTD formula the continuation parameters are entered in the “time interval" field and the choice to equalize the... more
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 closes 15-minutes later, at 15:15. If you want to... more
A common request is an RTD formula to pull historical settlement prices for a particular market. There is a “Contract Data” RTD formula for settlement:
=RTD("CQG.RTD", ,"ContractData", "CLE", "Settlement",, "T")
However, “Contract... more
Customers 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 due to OS localization.
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 chart.
For example, in the chart we see the... more