Workspaces

Thom Hartle
Jun 30, 2017
Updated: Sep 14, 2018

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the SPDR® S&P® Bank ETF (symbol: KBE).

Throughout the trading session, the individual stocks are dynamically ranked. The main display shows the top and bottom... 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 14, 2017
Updated: Sep 14, 2018

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 Trading Preferences, under Trading Display, you... more

Thom Hartle
Jun 12, 2017
Updated: Sep 14, 2018

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 own symbols. To the right is a portfolio view of the... more

Thom Hartle
Jun 08, 2017
Updated: Jan 11, 2021

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the SPDR® S&P® Biotech ETF (symbol: XBI).

Throughout the trading session, the individual stocks are dynamically ranked. The main display shows the top and bottom... 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
May 31, 2017
Updated: Sep 14, 2018

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 dynamically ranked. The main display shows the top and... more

Thom Hartle
May 24, 2017
Updated: Sep 14, 2018

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 of an index composed of large- and mid-... more

Thom Hartle
May 18, 2017
Updated: Sep 14, 2018

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the iShares Core S&P U.S. Value ETF (symbol: IUSV). The iShares Core S&P U.S. Value ETF seeks to track the investment results of an index composed of large- and mid-... more

Thom Hartle
May 15, 2017
Updated: Sep 14, 2018

Traders can use pre-built conditions or create their own conditions in CQG to mark bars when a particular condition is met. They can then pull this information into Excel using RTD formulas. The RTD formulas are similar to study RTD... more