Excel: Displaying Open Options Positions and Greeks

Thom Hartle – July 31, 2025

This spreadsheet built by CQG Product Specialist Jim Stavro uses RTD calls to pull in open futures and options positions as well as "Greeks" using RTD formulas.

To use the spreadsheet, CQG IC or QTrader must be logged into the Gateway. Then Cells B2 and B4 must have your account ID (Cell B2) and your account name (Cell B4).

The video shows where to find this information in IC or QTrader.

f1

The video walks you through the features as well as how to add additional tabs for specific markets.

 

Requires CQG Integrated Client or CQG QTrader, and Excel 2016 or more recent installed on the computer, not in the Cloud.

Downloads

File
option_positions_cqgic.xlsm
Tags
Excel
Excel/RTD
How To
Options
Thom Hartle

Disclaimer

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.