Workspaces

Thom Hartle
Oct 20, 2014

Version 3

This CQG-powered Microsoft Excel® dashboard offers a ten-year performance review for a period defined by the user. You can use futures and stock symbols. Enter one starting futures symbol and Excel will do the... more

Thom Hartle
Oct 09, 2014

This Microsoft Excel® dashboard displays current market data and five-minute, fifteen-minute, thirty-minute, and sixty-minute measurements of volatility. Volatility is defined as the upper twenty-period Bollinger Band minus the lower twenty-... more

Thom Hartle
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
Thom Hartle
Sep 26, 2014

This Microsoft Excel® dashboard displays the first two months' expiries of the KOSPI 200 options. Last price, net change, percent net change, implied volatility using Black-Scholes, and today's and yesterday's volume data are automatically... more

Thom Hartle
Sep 23, 2014

This Microsoft Excel® spreadsheet uses a matrix format to show the natural gas market traded on the CME Globex electronic trading platform.

This dashboard screen capture shows the inside market for each of the outright contracts... more

Thom Hartle
Sep 12, 2014

Customers who subscribe to the CQG Comprehensive FXTM data feed can use this dashboard to see all crosses sorted by the base currency. Each group displays the net change, which is color-coded red for negative net changes, then a heat-mapped... more

Thom Hartle
Aug 28, 2014

This group of Microsoft Excel® dashboards displays individual Short-Term Interest Rate (STIRs) products for tracking the rolls. All of the active deliveries for each individual symbol are displayed in a single dashboard detailing market data. The... more

Aug 26, 2014

This component pac provides an overview of global market activity across multiple asset classes, grouped in separate Portfolio Monitor windows. Columns are intuitively color-coded to identify both the nature of the column and direction of an... more

Thom Hartle
Aug 11, 2014

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... more

Thom Hartle
Aug 11, 2014

CQG FX supports the RealTimeData (RTD) function for delivering market information, study data, and other information to Microsoft Excel®. By partnering CQG FX with Excel, you can design dashboards to your specific requirements and make your... more