Workspaces

Anthony Cohen
Mar 04, 2021
Updated: Mar 04, 2021

The BarInt function can be useful when creating Custom Studies or Conditions which can be applied to different timeframe but where a point of reference may be different whether you are looking at an intraday chart or a Historical chart (Daily... more

Anthony Cohen
Mar 04, 2021
Updated: Mar 04, 2021

One of the simplest examples for this function is to find out whether a value is an even number.

Modulus (Close(@),2) = 0

In other words, the result of the formula above would give us the remainder of the operation Closing Price/2. If the... more

Thom Hartle
Oct 23, 2017
Updated: Jul 17, 2020

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

Thom Hartle
Mar 30, 2015
Updated: Jan 29, 2020

If you use RTD formulas for data from the options markets, then Excel will pull data using your settings in CQG, such as the options model you have selected. An RTD formula for implied volatility will pull the Implied Volatility (IV) for the... more

Thom Hartle
Sep 10, 2015
Updated: May 15, 2019

Four new chart types have been added to CQG. This article details the RTD formulas for calling market and study data into Excel using these new chart types. The chart types are:

Heikin-Ashi Candlesticks Range Bar Renko Sub-Minute

These... more

Thom Hartle
May 19, 2015
Updated: May 15, 2019

This Microsoft Excel® dashboard uses the CQG RTD OptVal formula to calculate implied volatility, theoretical value, delta, and the Greeks using data inputs from other RTD formulas.

For example, the implied volatility calculation is... more

Thom Hartle
Aug 16, 2018
Updated: Apr 01, 2019
Bring Updating Time-Series Data from Microsoft Excel® Into CQG

The XL Real-Time study is included in CQGIC subscriptions enabled for CQG Trading, or Spreader, as well as CQG Spreader systems. The XL Real-Time Study is available to base CQGIC (... more

Thom Hartle
Sep 29, 2014
Updated: Feb 25, 2019

To help you design and manage your custom dashboards using CQG with Microsoft Excel®, Thom Hartle has written the following articles that answer the most common questions.

Topic Description RTD Throttle Excel has a throttle that... more
Thom Hartle
Feb 07, 2019
Updated: Feb 07, 2019

If you set up a Microsoft Excel® dashboard to monitor options prices and their respective deltas you may see the delta values disappear occasionally in the dashboard. In other words, the value for the options deltas, especially far out of the... more

Thom Hartle
Jan 23, 2019
Updated: Jan 23, 2019

After the current trading session ends, many exchanges clear out today’s market data to set up for the preopening posting of orders to the exchange's order book. This includes today’s open, high, low, and close. In effect, the exchange moved... more