How To

When using RTD functions in Excel to pull in market prices you have to manually format the prices. Excel does not know that the E-mini S&P 500 price has two decimals places (i.e. 3909.25) and… more

Microsoft Excel spreadsheets have functionality to format cells based on conditions. This feature is also referred to as data visualization. This post details two types of data visualizations… more

This post builds upon CQG Product Specialist Helmut Mueller's post titled “Most Wanted Seven Studies Plus a Bonus Trading System.” His post provides a PAC with the following studies:

You can easily hide things unnecessary items in Microsoft Excel® to open up more screen real estate. All of my published CQG-powered Excel dashboards show you an image. You may have also noticed… more

Customers who use Microsoft Excel® when following the markets can easily populate their Excel spreadsheet with RTD formulas using CQG's Quote SpreadSheet (QSS) 2.0.

To open QSS 2.0, click… more

CQG Integrated Client and CQG QTrader customers can pull the time the high and low occurred during today’s session into a Microsoft Excel® spreadsheet using these RTD formulas:… more

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

These are study formulas and… more

This spreadsheet provides a list of RTD formulas for historical bars and charting, requesting study data and study-related curves, calling a set of historical bars of all supported types, and… more

This spreadsheet outlines the basic syntax of RTD formulas and then details more complex formulas. Included is a collection of popular RTD formulas, which you can simply copy and paste into your… more