Workspaces

Thom Hartle
Jul 06, 2018
Updated: Sep 14, 2018

This Microsoft Excel® dashboard has two parts: the top half pulls the forward curves for soybeans, corn, and wheat traded on the CME Globex platform and the bottom half pulls the USDA Crop Progress Reports by date. The USDA reports are... 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

Aug 18, 2017
Updated: Aug 23, 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

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

Marcus Kwan
Jan 30, 2017
Updated: Jan 31, 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

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
Sep 29, 2014
Updated: Aug 25, 2016

To help you design and manage your custom dashboards using CQG with Microsoft Excel®, Thom Hartle has written the following articles that answer the most common questions.

Topic Description RTD Throttle Excel has a throttle that... more