Workspaces

Thom Hartle
Nov 28, 2017
Updated: Dec 05, 2018

This Microsoft Excel® dashboard displays market data for coffee spreads traded on the ICE platform using a matrix-style format. The outrights are along the top row and at the start of each row. The best bid and best ask are also included. If the... more

Thom Hartle
Dec 04, 2017
Updated: Dec 05, 2018

This Microsoft Excel® dashboard displays market data for cocoa spreads traded on the ICE platform using a matrix-style format. The outrights are along the top row and at the start of each row. The best bid and best ask are also included. If the... more

Thom Hartle
Sep 24, 2018
Updated: Nov 19, 2018

This Microsoft Excel® spreadsheet pulls in live cattle, feeder cattle, and lean hogs market data traded on CME Globex.

The forward curves display today's data. If the last price is outside of the best bid and best ask, then the mid... 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
Jun 18, 2018
Updated: Nov 08, 2018

This Microsoft Excel® dashboard presents two charts of the Nasdaq-100 futures contract and market data for the one hundred stocks that are constituents of the Nasdaq 100 Index.

The chart in the top left corner displays... more

Thom Hartle
May 03, 2017
Updated: Nov 06, 2018

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the Guggenheim S&P 500® Equal Weight Technology ETF (symbol: RYT). This ETF seeks to replicate, before fees and expenses, the performance of the S&P 500® Equal Weight... more

Thom Hartle
Oct 12, 2015
Updated: Oct 18, 2018

These Microsoft Excel® spreadsheets determine the at-the-money option and display a table of thirty strikes above and below the at-the-money. The tables consist of market data and the implied volatilities for each of the sixty-one strikes. The... more

Thom Hartle
Jan 23, 2017
Updated: Oct 10, 2018

This Microsoft Excel® dashboard displays Delta Bars with a price ladder detailing the executed volume by price for the current Delta Bar. Also, an intraday bar chart is included with a price ladder showing the executed volume by price for the... more

Thom Hartle
Nov 03, 2016
Updated: Oct 10, 2018

This Microsoft Excel® dashboard uses RTD formulas to pull in market data based on a new CQG chart type called Delta Bar. Delta Bar is similar to the Constant Volume chart type except instead of a user-set amount of executed volume to... more

Thom Hartle
Sep 25, 2017
Updated: Oct 01, 2018

CQG charts have a setting called the BATS Charts Preferences. Here, you select what data to use to build the chart. You can use the default setting where the chart is built using trade and settlement data. You can uncheck Use default ... more