Workspaces

Thom Hartle
Jan 23, 2019
Updated: Jan 23, 2019

After the current trading session ends, many exchanges clear out today’s market data to set up for the preopening posting of orders to the exchange's order book. This includes today’s open, high, low, and close. In effect, the exchange moved... more

Thom Hartle
Aug 25, 2017
Updated: Nov 08, 2018

These two Microsoft Excel® dashboard display market quotes for tradable UDS for the crude oil contract and the E-mini S&P 500 traded on Globex. There is also a quote display with at-the-money (ATM) calls and puts with one strike... more

Thom Hartle
Aug 03, 2016
Updated: Sep 25, 2018

This Microsoft Excel® dashboard offers a two-window view for tracking market performance (You have to enable macros when this dashboard is first opened.) The top half displays market data using whatever symbols (such as indices, stocks, and... more

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

This spreadsheet outlines the basic syntax of RTD formulas and then details more complex formulas. Included is a collection of popular RTD formulas, which you can simply copy and paste into your own spreadsheet.

*Requires Microsoft... 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
Aug 28, 2014
Updated: Sep 14, 2018

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

Thom Hartle
Sep 12, 2014
Updated: Sep 14, 2018

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

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

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