Thom Hartle

This Microsoft Excel® spreadsheet uses a matrix format to show the heating oil market traded on the CME Globex electronic trading platform.

This dashboard screen capture shows the inside… more

This Microsoft Excel® spreadsheet uses a matrix format to show the crude oil market traded on the CME Globex electronic trading platform.

This dashboard screen capture shows the inside… more

In order to smoothly transition from DDE to RTD, CQG provides a tool that converts all DDE-coded spreadsheets into RTD format. This zip file contains the converter for updating DDE coding in Excel… more

Version 3

This CQG-powered Microsoft Excel® dashboard offers a ten-year performance review for a period defined by the user. You can use futures and stock symbols. Enter… more

This Microsoft Excel® dashboard displays current market data and five-minute, fifteen-minute, thirty-minute, and sixty-minute measurements of volatility. Volatility is defined as the upper twenty-… more

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.

This Microsoft Excel® dashboard displays the first two months' expiries of the KOSPI 200 options. Last price, net change, percent net change, implied volatility using Black-Scholes, and today's… more

This Microsoft Excel® spreadsheet uses a matrix format to show the natural gas market traded on the CME Globex electronic trading platform.

This dashboard screen capture shows the… more

Customers who subscribe to the CQG Comprehensive FXTM data feed can use this dashboard to see all crosses sorted by the base currency. Each group displays the net change, which is color-coded red… more

This group of Microsoft Excel® dashboards displays individual Short-Term Interest Rate (STIRs) products for tracking the rolls. All of the active deliveries for each individual symbol are… more