Workspaces

Thom Hartle
Jan 08, 2016
Updated: Sep 14, 2018

This Microsoft Excel® dashboard displays today’s open interest and traded volume for all of the strikes by month for both call and put options on futures. In addition, the current put/call ratio and previous session’s traded volume and open... more

Thom Hartle
Nov 23, 2016
Updated: Sep 14, 2018

This Microsoft Excel® dashboard scans the options on the Eurodollar futures market for volume and ranks the traded volume for each expiry out to three years. The scan covers options traded ten strikes above and below the at-the money option. Then... more

Thom Hartle
Dec 29, 2016
Updated: Sep 14, 2018

This Microsoft Excel® dashboard scans the crude oil (GLOBEX) futures market options for volume and ranks the traded volume for each expiry out to sixteen months. The scan covers options traded ten strikes above and below the at-the... more

Thom Hartle
Apr 07, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard scans the options on soybeans, wheat, and corn (Globex) futures markets for volume. It displays strikes ranked by the volume traded for each expiry listed. The scan covers options traded ten strikes above... more

Thom Hartle
Jul 25, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard scans the Hang Seng Index market options on futures and ranks the traded volume for each expiry out to eleven expirations. The scan covers options traded ten strikes above and below the at-the-money option. The top... more

Thom Hartle
Aug 01, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard scans the options on futures for the H-shares Index (HHI) and ranks the traded volume for each expiry out to nine expirations. The scan covers options traded ten strikes above and below the at-the-money option... more

Thom Hartle
Aug 15, 2017
Updated: Sep 14, 2018

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

Thom Hartle
Oct 30, 2017
Updated: Sep 14, 2018

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

Thom Hartle
Jan 02, 2018
Updated: Sep 14, 2018

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

Thom Hartle
Apr 15, 2015
Updated: Aug 25, 2016

You can use Microsoft Excel® and data from CQG to expand the features of your own market display dashboards. This powerful combination can be tailored to your specific needs. This article shows you how to build an Excel dashboard and provides a... more