Workspaces

Thom Hartle
Aug 31, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet is a modified version of the Dynamically Ranked SPDR® ETFs Dashboard. This version allows you to enter in the symbols you want using the symbols tab. The top twenty performing markets, on a percent change basis,... more

Thom Hartle
Sep 16, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet uses the RTD correlation formula to pull historical correlation values from CQG.

You can enter the symbols for two markets, time frame, and the look-back period for the correlation analysis. The... more

Thom Hartle
Sep 22, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in market data for crude oil traded on CME Globex.

Twelve months of outrights, one-month, and three-month calendar spreads are displayed. The forward curves display today's... more

Thom Hartle
Sep 22, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in market data for CME Globex-traded soybeans, corn, and wheat.

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
Sep 22, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in market data for RBOB gasoline traded on CME Globex.

Twelve months of outrights, one-month, and three-month calendar spreads are displayed. The forward curves display today's... more

Thom Hartle
Sep 22, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in market data​ for RBOB gasoline traded on CME Globex.

The dashboard uses a matrix-style presentation with the outrights displayed along the top row and also the first... more

Thom Hartle
Sep 22, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in market data. There is a Symbols tab where you can enter the symbols and the parameter for decimal formatting.

One of the features of the CQG Toolkit is the ability... more

Thom Hartle
Sep 22, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in WTI Light Sweet Crude Oil market data traded on the ICE exchange.

The dashboard uses a matrix-style presentation with the outrights displayed along the top row and also the... more

Thom Hartle
Sep 22, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in Brent Crude Oil and WTI Light Sweet Crude Oil market data traded on the ICE exchange.

The forward curves display today's data. If the last price is outside of the best bid... more

Thom Hartle
Sep 22, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in Brent Crude Oil market data traded on the ICE exchange.

The dashboard uses a matrix-style presentation with the outrights displayed along the top row and also the first... more