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.

Download the Excel File ‌‍‍‍‍

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

Microsoft Excel is a registered trademark of Microsoft Corporation in the United States and/or other countries.