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
Jun 07, 2018
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
Aug 18, 2017
Welcome to CQG. Here is some important information to get you started. If you need help logging on, review these steps.Main Window
Once you have logged on, you see the main window.
You may want to familiarize yourself with the... more
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
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
Dec 20, 2016
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
Jan 30, 2017
This CQG M dashboard layout displays a portfolio of symbols from the Americas (available with a subscription to the CME Globex feed on CQG) in a heat-map style. Tapping on a quote pushes the symbol to the chart displaying Bollinger Bands,... more
Jul 28, 2014
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.
Jul 01, 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
Apr 15, 2015
You can use Microsoft Excel® and data from CQG to expand the features of your own market display dashboards. This powerful combination can be tailored to your specific needs. This article shows you how to build an Excel dashboard and provides a... more