Excel/RTD

Workspaces

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

Workspaces

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

Workspaces

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

Workspaces

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

Workspaces

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

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

Workspaces

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

Workspaces

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

Workspaces

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

Workspaces

A common request is an RTD formula to pull historical settlement prices for a particular market. There is a “Contract Data” RTD formula for settlement:

=RTD("CQG.RTD", ,"ContractData", "CLE", "Settlement",, "T")

However, “Contract... more