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
Workspaces
Feb 22, 2017
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
Sep 29, 2014
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.
Topic Description RTD Throttle Excel has a throttle that... more
Sep 22, 2015
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
Feb 07, 2019
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
Jan 23, 2019
After the current trading session ends, many exchanges clear out today’s market data to set up for the preopening posting of orders to the exchange's order book. This includes today’s open, high, low, and close. In effect, the exchange moved... more
Nov 28, 2017
This Microsoft Excel® dashboard displays market data for coffee spreads traded on the ICE platform using a matrix-style format. The outrights are along the top row and at the start of each row. The best bid and best ask are also included. If the... more
Dec 04, 2017
This Microsoft Excel® dashboard displays market data for cocoa spreads traded on the ICE platform using a matrix-style format. The outrights are along the top row and at the start of each row. The best bid and best ask are also included. If the... more
Sep 24, 2018
This Microsoft Excel® spreadsheet pulls 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 ask, then the mid... more
Aug 25, 2017
These two Microsoft Excel® dashboard display market quotes for tradable UDS for the crude oil contract and the E-mini S&P 500 traded on Globex. There is also a quote display with at-the-money (ATM) calls and puts with one strike... more