Dynamically-Updated Volatility Excel Dashboard

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. Learn more about this dashboard, please view this YouTube video.

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

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

Downloads

CQG Integrated Client
Get a 2-week free trial

Learn More:

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