Thom Hartle
Jan 20, 2015
Updated: Apr 16, 2019

These two Microsoft Excel® spreadsheets present market data and forward curves of the Globex Crude Light Oil and ICE Brent Crude Oil contracts. The data includes the outrights, exchange-traded calendar spreads, and synthetic butterfly spreads for... more

Thom Hartle
May 08, 2017
Updated: Apr 15, 2019

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the iShares Core S&P U.S. Growth ETF (symbol: IUSG). The iShares Core S&P U.S. Growth ETF seeks to track the investment results of an index composed of large- and mid-... more

Thom Hartle
Jul 27, 2017
Updated: Apr 03, 2019

This Microsoft Excel® spreadsheet tracks the constituents of the DJIA Index (symbol: DJIA).

Throughout the trading session, the thirty individual stocks are dynamically ranked and displayed in the histogram bar chart with their respective... more

Thom Hartle
Nov 21, 2017
Updated: Apr 01, 2019

You can use LocalHour and LocalMinute functions in the RTD formula to pull in the open price for a market using a 5-minute bar at 12:00. This technique was detailed in a previous article here.

If you are pulling in a large amount... more

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
Dec 12, 2017
Updated: Dec 12, 2018

CQG offers a collection of conditions you can use to mark points on a chart when the condition is met. In addition, you can create your own custom conditions. You can easily bring conditions into Excel using RTD formulas. Excel displays a 1... 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
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