Getting Started Using CQG, RTD, and Excel(R)

CQG supports the Microsoft Excel RealTimeData (RTD) function in CQG Integrated Client version 8.4 and greater for delivering market data and other information to Excel. Through the combination of CQG and Excel, you can create highly-customized applications designed for your specific needs.

We have created a basic tutorial for customers who are just starting to take advantage of the powerful combination of RTD, Excel, and CQG's data. The following Excel spreadsheet outlines the basic syntax of RTD formulas and then details more complex formulas. Included is a collection of the popular RTD formulas. You can simply copy and paste these formulas into your own spreadsheet.

Download the RTD formulas tutorial spreadsheet ‌‍‍‍‍

For more information on using CQG and RTD, please visit our website. Also, some tips and tricks for using RTD in Excel can be found here.


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.