Excels Implicit Intersection Operator =@CQGContractData("EP", "LastTrade",, "T")

▤ Summary

The RTD function displayed in the title of the post includes the "@" sign. If you use the CQG RTD Toolkit installed on the Excel Ribbon when either CQG IC or QTrader are installed to pull in "Label" data the "@" sign is seen if you are running Excel 365 or higher. As shown below, selecting from the Label Data button using the CQG RTD Toolkit and then selecting Last Trade inserts the RTD function calling for the Last Trade using the symbol located in cell A1. Excel 365 offers Dynamic Arrays, and a special key combination is not required. This post, Excel Combining SORTBY, CHOOSECOLS, and TAKE Functions, also discusses working with Dynamic Arrays.

▦ Linked Companies

CQG

$50M to $100M