Workspaces

Thom Hartle

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

Thom Hartle

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

Thom Hartle

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

Thom Hartle

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

Thom Hartle

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

Thom Hartle

This Microsoft Excel® dashboard has three tabs. The first tab displays today’s market quotes, volume, and open interest data. If the last price is matching the open price, then the open price… more

Thom Hartle

CQG charts have a setting called the BATS Charts Preferences. Here, you select what data to use to build the chart. You can use the default setting where the chart is built using trade and… more

Thom Hartle

These two Microsoft Excel® spreadsheets present Globex crude oil market data and forward curves, both current and historical. Two dashboards are available: The first the data includes outrights… more

Thom Hartle

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

Thom Hartle

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