Workspaces

Thom Hartle
Bring Updating Time-Series Data from Microsoft Excel® Into CQG

The XL Real-Time study is included in CQGIC subscriptions enabled for CQG Trading, or Spreader, as well as CQG Spreader systems. The… more

Thom Hartle

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… more

Thom Hartle

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… more

Thom Hartle

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… more

Thom Hartle

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… more

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.

more

Thom Hartle

In this article, we outline how to pull historical market data into Excel while excluding data from days when the market was in a holiday session.

Holiday sessions are trading dates, but… more

Thom Hartle

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… more

Thom Hartle

Some traders want to see their current open trade equity (OTE) and closed out trades (P&L) based on yesterday’s settlement, not the original price when the trade was opened. In DOMTrader's… more

Thom Hartle

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… more