Workspaces

Thom Hartle
Jun 30, 2017
Updated: Sep 14, 2018

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the SPDR® S&P® Bank ETF (symbol: KBE).

Throughout the trading session, the individual stocks are dynamically ranked. The main display shows the top and bottom... more

Thom Hartle
Jul 20, 2017
Updated: Sep 14, 2018

In this article, we outline how to pull historical market data into Excel while excluding data from days when the market was in a holiday session.

Holiday sessions are trading dates, but not clearing dates. Holiday session data is... more

Thom Hartle
Jul 25, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard scans the Hang Seng Index market options on futures and ranks the traded volume for each expiry out to eleven expirations. The scan covers options traded ten strikes above and below the at-the-money option. The top... more

Thom Hartle
Aug 01, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard scans the options on futures for the H-shares Index (HHI) and ranks the traded volume for each expiry out to nine expirations. The scan covers options traded ten strikes above and below the at-the-money option... more

Thom Hartle
Aug 07, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard displays the cash indices available from the Hang Seng Indexes Company.

The quote displays are divided into four sections. The first section is the cash Hang Seng Indices. Net percent change is heat mapped.... more

Thom Hartle
Aug 10, 2017
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet tracks the front month contracts of the PowerShares® DB Commodity Index (symbol: DBC) holdings. The actual ETF holds deferred contracts. More information about ETF can be found here.

The PowerShares DB... more

Thom Hartle
Aug 15, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard scans the VIX (CBOE) options market for volume and displays the strikes ranked by the volume traded for each expiry listed. The scan covers options traded 15 strikes above and below the at-the-money option. The... more

Thom Hartle
Oct 06, 2017
Updated: Sep 14, 2018

This Microsoft Excel® dashboard has three tabs. The first tab displays today’s market quotes, volume, and open interest data. If the last price is matching the open price, then the open price is highlighted blue. If the last price is... more

Thom Hartle
Sep 21, 2017
Updated: Sep 14, 2018

These two Microsoft Excel® spreadsheets present Globex crude oil market data and forward curves, both current and historical. Two dashboards are available: The first the data includes outrights and exchange-traded calendar spreads using these... more

Thom Hartle
Oct 16, 2017
Updated: Sep 14, 2018

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