Workspaces

Thom Hartle
Jun 08, 2017

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

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

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

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

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

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

Thom Hartle
May 08, 2017

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

Thom Hartle
May 03, 2017

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the Guggenheim S&P 500® Equal Weight Technology ETF (symbol: RYT). This ETF seeks to replicate, before fees and expenses, the performance of the S&P 500® Equal Weight... more

Thom Hartle
Apr 27, 2017

This Microsoft Excel® spreadsheet presents Eurodollar market data​. The data includes ten years of quarterly contracts for outrights and exchange-traded three-month and six-month calendar spreads.

Quarterly contracts are color-... more

Thom Hartle
Apr 24, 2017

CQG customers who create their own custom studies can easily use RTD to pull custom study values into Excel.

There are only two unique requirements in the RTD formula for a custom study: first, include the “^” sign in the custom study... more