CQG FX Volatility Excel Dashboard

Powered by CQG FX, this Microsoft Excel® dashboard measures volatility by using the difference between the upper and lower Bollinger Bands and dividing the difference by the Moving Average. The dashboard then sorts the volatility by ranking them from lowest to highest and displays all other market data based on their respective ranking. You can change the time frame, look-back period, and number of standard deviations.

Make sure to lower your Excel RealTimeData (RTD) throttle to 0 to 50 milliseconds. Learn how to do that here.

Due to the ranking feature in Excel and the speed of RTD, Excel may warn you of an error. Just click Okay.

To learn more about this dashboard, please view this YouTube video.

Requirements: CQG FX, data enablements for all symbols displayed in this spreadsheet, Excel 2010 or more recent, and the CQG component pac, VolatilityDashboard.pac, must be installed.



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.