Thom Hartle
Nov 28, 2017

This Microsoft Excel® dashboard displays market data for coffee spreads traded on the ICE platform using a matrix-style format. The outrights are along the top row and at the start of each row. The best bid and best ask are also included. If the... more

Thom Hartle
Nov 21, 2017

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... more

Marcus Kwan
Nov 16, 2017
Charts The order display study now includes the average fill price Quotes When using net change mode on a mobile quote board, the last price displays last trade rather than last quote General A link to the new help website has been added to the ?... more
Andy Hecht
Nov 01, 2017

Crude oil is the energy commodity that continues to power the world. While many new and exciting energy products will likely take away some of oil’s market share in the years to come, the fact is that today oil remains essential for consumers... more

Thom Hartle
Oct 30, 2017

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

Oct 26, 2017

Watch our recorded webinar to learn about the following services that CQG Integrated Client customers can access for free through the end of the year:

Market Scan Advanced Options

Our product specialists provide expert-level overviews... more

Oct 25, 2017
Free Services

CQG Integrated Client customers have free access to the following services through the end of the year:

Market Scan Advanced Options

Sign-up is not necessary. We’ve turned these services on for all current CQG IC customers... more

Thom Hartle
Oct 23, 2017

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
Oct 16, 2017

This Microsoft Excel® dashboard presents different styles of viewing market and study information. The left-hand side is today's current market data. You can enter symbols and set the number of decimals. The HiLoAlert cell is a user-entered value... more

Thom Hartle
Oct 11, 2017

There is an RTD call for depth-of-market (DOM) data for futures markets. You call the DOM data by symbol and queue number. You can pull the bid or ask price, bid or ask volume, and the time of the last update.

The best ask price... more