Workspaces

This Microsoft Excel® dashboard offers a two-window view for tracking market performance. The top half displays market data using symbols such as indices, stocks and futures that the user enters on the symbols tab. The bottom half has... more

These two Microsoft Excel® spreadsheets present market data and forward curves of the Globex Crude Light Oil and ICE Brent Crude Oil contracts. The data includes the outrights, exchange-traded calendar spreads, and synthetic butterfly spreads for... more

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the iShares Core S&P U.S. Growth ETF (symbol: IUSG). The iShares Core S&P U.S. Growth ETF seeks to track the investment results of an index composed of large- and mid-... more

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.

If you are pulling in a large amount... more

The XL Real-Time study is included in CQGIC subscriptions enabled for CQG Trading, or Spreader, as well as CQG Spreader systems. The XL Real-Time Study is available to base CQGIC (... more

This Microsoft Excel® dashboard tracks the 104 stocks in the Nasdaq-100 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 shows... more

This macro-enabled Microsoft Excel® spreadsheet presents a ten-by-ten correlation matrix, a scattergram chart of the correlations by row, and frequency distribution charts of the correlations. In addition, twenty versions using a different city... 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® spreadsheet uses the CQG Toolkit to pull in WTI Light Sweet Crude Oil market data traded on the ICE exchange.

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

If you set up a Microsoft Excel® dashboard to monitor options prices and their respective deltas you may see the delta values disappear occasionally in the dashboard. In other words, the value for the options deltas, especially far out of the... more