CQG Trading Studies in Excel

This Microsoft Excel® dashboard uses RTD formulas to pull the following CQG Trading Studies into Excel:

  • Open Trade Equity
  • Position
  • Profit & Loss

These are study formulas and, therefore, historical data is available. However, the historical data for trading studies is limited to today’s session only.

This sample spreadsheet allows you to change the symbol and time frame. In addition, open, high, low, and close data as well as the time of each bar is pulled into Excel.

You must be logged into your trading account for the spreadsheet to access the data.

Requires CQG Integrated Client or CQG QTrader and Excel 2010 or more recent.




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.