Workspaces

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

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the Invesco 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

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

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

This Microsoft Excel® spreadsheet presents Globex crude oil market data and forward curves. The data includes outrights, exchange-traded calendar spreads, and butterfly spreads. The exchange-traded calendar spreads include the following... more

This Microsoft Excel® dashboard scans the options on soybeans, wheat, and corn (Globex) futures markets for volume. It displays strikes ranked by the volume traded for each expiry listed. The scan covers options traded ten strikes above... more

This Microsoft Excel® dashboard displays market data for grain spreads traded on the Globex platform using a matrix-style format. The outrights are along the top row and the start of each row. The best bid and best ask are also included. If the... more

This Microsoft Excel® spreadsheet is a combination of market quotes and dynamic ranking. There is a Symbols tab where you can enter the symbols and the parameter for decimal formatting, or you can enter B for bonds and fractions. You can set the... more

This Microsoft Excel® spreadsheet pulls market data from CQG Integrated Client or CQG QTrader. There is a Symbols tab where you can enter the symbols, the parameter for decimal formatting, and the title for each group of quotes on the main... more

This article shows RTD formulas for pulling values into Microsoft Excel® that are a study applied to a study.

A common use of Excel with CQG is to pull in study data, such as the average true range study:

= RTD("cqg.rtd",,"... more