Excel/RTD

Customers using our flagship product, CQG Integrated Client (CQG IC), have access to a new study called Algo Orders. Using a proprietary algorithm, this indicator of trading activity detects and exposes hidden volume (iceberg orders) in the... more

CQG offers an Implied Volatility (ImpVol) study that allows you to pull in historical implied volatility data onto a chart. ImpVol is not the implied volatility of one particular option. CQG uses the outright contract symbol from the... more

CQG offers a collection of conditions you can use to mark points on a chart when the condition is met. In addition, you can create your own custom conditions. You can easily bring conditions into Excel using RTD formulas. Excel displays a 1... more

You can use LocalHour and LocalMinute functions in the RTD formula to pull in the open price for a market using a 5-minute bar at 12:00. This technique was detailed in a previous article here.

If you are pulling in a large amount... more

This Microsoft Excel® dashboard scans options on the E-mini S&P 500 futures market using the CQG RTD Toolkit for volume and displays strikes ranked by the volume traded for each listed expiry. The scan covers options traded 15 strikes above... more

There are numerous Excel samples that walk you through bringing various market data into Excel using RTD formulas. However, there is a lot to look through. One solution is to use the CQG Formula Builder. You can right-click a study, hover your... 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 the Quote button on the application toolbar, then... more

These two Microsoft Excel® dashboard display market quotes for tradable UDS for the crude oil contract and the E-mini S&P 500 traded on Globex. There is also a quote display with at-the-money (ATM) calls and puts with one strike... more

This Microsoft Excel® dashboard provides a drop-down menu where you can select the underlying market, such as E-mini S&P 500. The display will then show all front contract option symbols, including weekly and end-of-month options. The... more

This Microsoft Excel® dashboard scans the VIX (CBOE) options market for volume and displays the strikes ranked by the volume traded for each expiry listed. The scan covers options traded 15 strikes above and below the at-the-money option. The... more