Spread Analysis Dashboard

This Microsoft Excel® dashboard offers four charts displaying seventy-five open, high, low, and close bars of a spread. The spread symbols are entered into Excel on the symbols tab and the time frame is set for the charts. The RTD formulas use the spread bar function. You can enter the interval for the spread bar function on the symbols tab. You can set the number of decimals to use for the price displays in the main display.

Below each chart on the main display are frequency distribution charts. Excel reviews the last 300 bars’ closing prices, determines the range of the spread, and counts the number of times the spread closed at a certain value. Excel then displays that value as a histogram bar. The current price is marked by a yellow histogram bar.

Requires CQG Integrated Client version 2016 and higher, Excel 2013 and higher, and real-time enablements for NYSE, Nasdaq, and other exchanges whose products you plan to monitor.

CQG-powered Excel dashboards are copyrighted content owned by CQG and are not available in an unlocked state.



Trading and investment carry a high level of risk, and CQG, Inc. does not make any recommendations for buying or selling any financial instruments. We offer educational information on ways to use our sophisticated CQG trading tools, but it is up to our customers and other readers to make their own trading and investment decisions or to consult with a registered investment advisor. The opinions expressed here are solely those of the author and do not reflect the opinions of CQG, Inc. or its affiliates.