Workspaces

Thom Hartle
Oct 30, 2017

This Microsoft Excel® dashboard scans options on the E-mini S&P 500 futures market using the CQG RTD Toolkit for volume and displays strikes ranked by the volume traded for each listed expiry. The scan covers options traded 15 strikes above... more

Thom Hartle
Oct 23, 2017

There are numerous Excel samples that walk you through bringing various market data into Excel using RTD formulas. However, there is a lot to look through. One solution is to use the CQG Formula Builder. You can right-click a study, hover your... more

Thom Hartle
Oct 16, 2017

This Microsoft Excel® dashboard presents different styles of viewing market and study information. The left-hand side is today's current market data. You can enter symbols and set the number of decimals. The HiLoAlert cell is a user-entered value... more

Thom Hartle
Oct 11, 2017

There is an RTD call for depth-of-market (DOM) data for futures markets. You call the DOM data by symbol and queue number. You can pull the bid or ask price, bid or ask volume, and the time of the last update.

The best ask... more

Thom Hartle
Oct 06, 2017

This Microsoft Excel® dashboard has three tabs. The first tab displays today’s market quotes, volume, and open interest data. If the last price is matching the open price, then the open price is highlighted blue. If the last price is... more

Thom Hartle
Sep 25, 2017

CQG charts have a setting called the BATS Charts Preferences. Here, you select what data to use to build the chart. You can use the default setting where the chart is built using trade and settlement data. You can uncheck Use default ... more

Thom Hartle
Sep 21, 2017

These two Microsoft Excel® spreadsheets present Globex crude oil market data and forward curves, both current and historical. Two dashboards are available: The first the data includes outrights and exchange-traded calendar spreads using these... more

Thom Hartle
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
Aug 25, 2017

These two Microsoft Excel® dashboard display market quotes for tradable UDS for the crude oil contract and the E-mini S&P 500 traded on Globex. There is also a quote display with at-the-money (ATM) calls and puts with one strike... 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