Workspaces

Thom Hartle
Mar 21, 2018
Updated: Sep 14, 2018

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
Thom Hartle
May 07, 2018
Updated: Sep 14, 2018

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

Thom Hartle
May 21, 2018
Updated: Sep 14, 2018

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

Thom Hartle
Jun 07, 2018
Updated: Jun 07, 2018

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

Thom Hartle
Sep 08, 2017
Updated: Sep 08, 2017

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

Thom Hartle
Jun 28, 2017
Updated: Jun 28, 2017

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

Thom Hartle
Jun 05, 2017
Updated: Jun 05, 2017

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

Thom Hartle
Dec 20, 2016
Updated: Apr 24, 2017

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

Thom Hartle
Jul 28, 2014
Updated: Aug 25, 2016

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.

Example

For... more

Thom Hartle
Jul 01, 2016
Updated: Aug 25, 2016

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