Add Symbols in All Contracts Window to Excel

Request: How can I get the symbols I see in the All Contracts Window into Excel? I cannot select the columns and copy and paste.

Solution: CQG offers an Excel RTD Add-in. There is a 64-bit Excel version and a 32-bit Excel version. Please check your version of Excel. To check your Excel version, click File then click Account. In the Account screen, click About Excel.

Once installed, one option is using the Derivatives List. This is the same symbol list used in the CQG All Contracts window. In the Get Derivative Contract List dialog, enter in the symbol in quotes and then choose futures, options, or fixed income and the cell for the output.

Submit a Support Request ‌‍‍‍‍


Trading and investment carry a high level of risk, and CQG, Inc. does not make any recommendations for buying or selling any financial instruments. We offer educational information on ways to use our sophisticated CQG trading tools, but it is up to our customers and other readers to make their own trading and investment decisions or to consult with a registered investment advisor. The opinions expressed here are solely those of the author and do not reflect the opinions of CQG, Inc. or its affiliates.