Workspaces

Thom Hartle
Sep 07, 2012
Updated: Sep 14, 2018

This spreadsheet provides a list of all available labels in market data in all types of contracts, including synthetic spreads. Orders and related statistics data include number of filled orders, open position, open trade equity, and... more

Thom Hartle
Nov 05, 2012
Updated: Sep 14, 2018

This spreadsheet provides a list of RTD formulas for historical bars and charting, requesting study data and study-related curves, calling a set of historical bars of all supported types, and requesting a set of historical study values created in... more

Thom Hartle
Feb 01, 2013
Updated: Sep 14, 2018

To access the RTD feature in CQG Trader, please contact your FCM.

This dashboard allows you to change symbols as well as enter a value for the high-low alert (HLAlert). If the last price is within the value of the high or low prices, then... more

Thom Hartle
Feb 01, 2013
Updated: Sep 14, 2018

To access the RTD feature in CQG Trader, please contact your FCM.

This spreadsheet displays the RTD formulas needed to bring market data from CQG Trader into Microsoft Excel. Excel has a throttle that limits the amount of time between RTD... more

Thom Hartle
May 29, 2013
Updated: Sep 14, 2018

Track the roll between futures contracts using this dashboard. The daily volume is displayed side-by-side on the volume chart and the open interest values are displayed as overlaid line charts. The center column shows the net difference between... more

Thom Hartle
Jul 19, 2013
Updated: Sep 14, 2018

This dashboard tracks the spread between the two volatility futures contracts, including the forward curves.

Please install the CQGVIXVSTOXX component pac before running the Microsoft Excel® dashboard.

Requires Microsoft... more

Thom Hartle
Jul 19, 2013
Updated: Sep 14, 2018

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.

Requires Microsoft Excel... more

Thom Hartle
Mar 17, 2014
Updated: Sep 14, 2018

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
Apr 17, 2014
Updated: Sep 14, 2018

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
Jul 16, 2014
Updated: Sep 14, 2018

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