Workspaces

This Microsoft Excel® dashboard tracks the 506 stocks in the S&P 500 index using CQG’s Level function. The Level function plots two lines, which identify the highest and lowest price levels attained over a defined period. The chart below... more

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the Invesco S&P 500® Equal Weight Technology ETF (symbol: RYT). This ETF seeks to replicate, before fees and expenses, the performance of the S&P 500® Equal Weight... more

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in market data for natural gas traded on CME Globex.

Twelve months of outrights, one-month, and three-month calendar spreads are displayed. The forward curves display today's... more

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in natural gas market data traded on the CME Globex exchange. It uses a matrix style presentation with the outrights displayed along the top row and also the first contract listed for... more

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in market data for heating oil traded on CME Globex.

The dashboard uses a matrix-style presentation with the outrights displayed along the top row and also the first contract... more

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in market data for crude oil traded on CME Globex.

The dashboard uses a matrix-style presentation with the outrights displayed along the top row and also the first contract... more

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in market data. There is a Symbols tab where you can enter the symbols and the parameter for decimal formatting.

This dashboard offers a unique format where the current market... more

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in live cattle, feeder cattle, and lean hogs market data traded on CME Globex.

The forward curves display today's data. If the last price is outside of the best bid and best... more

This article walks through the details of using three Microsoft Excel® functions: RANK, COUNTIF, and VLOOUP. These functions are used to build an Excel dashboard that automatically ranks a collection of markets based on percent net change and... more

This Microsoft Excel® spreadsheet presents a 10-by-10 correlation matrix. In addition, a dynamically ranked view of the correlations from the 10-by-10 correlation matrix is displayed as histogram bars. The histogram bars are separated into the... more