Workspaces

Thom Hartle
Jul 20, 2017

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
Jun 30, 2017

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the SPDR® S… more

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

Thom Hartle
Jun 14, 2017

Some traders want to see their current open trade equity (OTE) and closed out trades (P… more

Thom Hartle
Jun 12, 2017

This Microsoft Excel® spreadsheet tracks the BrokerTec US Treasury Yield Curve data and the ICAP Euro Bonds and Gilts markets.

The top-left quote display allows you to enter your… more

Thom Hartle
Jun 08, 2017

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the SPDR® S… more

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

Thom Hartle
May 31, 2017

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the Financial Select Sector SPDR® ETF (symbol: XLF).

Throughout the trading session, the individual stocks are… more

Thom Hartle
May 24, 2017

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the iShares Russell 1000 Growth ETF (symbol: IWF). The iShares Russell 1000 Growth ETF seeks to track the investment results… more

Thom Hartle
May 18, 2017

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the iShares Core S… more