Workspaces

Thom Hartle
Jul 20, 2017
Updated: Sep 14, 2018

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 not clearing dates. Holiday session data is... 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
Apr 15, 2015
Updated: Aug 25, 2016

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