Workspaces

Thom Hartle
Aug 08, 2014

This Microsoft Excel® dashboard displays all of the Globex-traded Eurodollar three-month calendar contracts. The volume column includes a red highlight if today's traded volume exceeds the previous session's traded volume. The volume column... more

Thom Hartle
Jul 28, 2014

Customers worldwide use CQG to deliver data to Microsoft Excel® via RTD calls. Operating System (OS) localization translates the application into another language. Some Excel syntax is different due to OS localization.

Example

For... more

Thom Hartle
Jul 24, 2014

CQG offers a Microsoft Excel® add-in to make your workflow easier when using CQG, RealTimeData (RTD), and 32-bit or 64-bit Excel. All you need to do is simply download the zip file, extract the contents, and run the setup file. The CQG RTD... more

Thom Hartle
Jul 16, 2014

This Microsoft Excel® dashboard displays the current crude oil options market ranked by the time of the last trade. It has two columns for two different expiry months. There are two tabs where you enter in the delivery month and the start and end... more

Thom Hartle
Jul 16, 2014

This Microsoft Excel® dashboard includes VBA code that plays a wav file if a condition is met. Download the CQG component pac, CQGIntradayNewHighNewLow.pac, which will indicate, in Excel, if the market is making a new high or low for the session... more

Thom Hartle
Jul 16, 2014

This Microsoft Excel® dashboard displays all of the Globex-traded Eurodollar contracts. The volume column highlights in gold the contract that has the largest twelve-day moving average. You can change the lookback period for the moving average.... more

Thom Hartle
Jul 14, 2014

This Microsoft Excel® dashboard presents different styles of viewing market and study information. The left-hand side is today's current market data. You can enter symbols and set the number of decimals. The HiLoAlert cell is a user-entered value... more

Thom Hartle
Apr 17, 2014

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

Thom Hartle
Mar 17, 2014

This Microsoft Excel dashboard is used to track the performance of a collection of Exchange-Traded Funds (ETFs).

The market information displayed is the last price, net change, the percentage net change heat mapped, and data bars... more

Thom Hartle
Jul 19, 2013

This correlation dashboard gives you sparklines to see the most recent changes in the correlation. Enter the symbols down the left-hand column. Change the look back period and the timeframe at the bottom.

Download the Excel File... more