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
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… more
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… more
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… 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,… 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… 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… more
This Microsoft Excel® dashboard displays market data for crude oil spreads traded on the ICE platform using a matrix-style format. The outrights are along the top row and the start of each… more
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… more
Pull historical spread data into Microsoft Excel® using RTD formulas with this sample spreadsheet. It not only pulls open, high, low, and close values into Excel, but also a study, the… more