Workspaces

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

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

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

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

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

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

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

These Microsoft Excel® spreadsheets determine the at-the-money option and display a table of thirty strikes above and below the at-the-money. The tables consist of market data and the implied… more

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.

… more

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