ETF

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the Health Care Select Sector SPDR® (XLY). The ETF is based on the Health Care Select Sector Index.

There are 60 stocks… more

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the iShares Semiconductor ETF (SOXX). The ETF tracks the investment results of an index composed of listed US equities in the… more

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the Invesco S&P 500® Momentum ETF (SPMO). The ETF is based on the S&P 500 Momentum Index (Index).

Recently… more

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the iShares Russell 1000 Growth ETF (symbol: IWF). The iShares Russell 1000 Growth ETF seeks to track the investment results… more

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… more

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… more

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the Financial Select Sector SPDR® ETF (symbol: XLF).

Throughout the trading session, the individual stocks are… more

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

Throughout the trading session, the individual stocks are dynamically… more

This article builds upon the post titled “Evaluate ETF Constituents Performance Using Excel” that detailed gauging the current price of a stock relative to the high as an indication of relative… more

If you track the performance of ETFs you may be interested in evaluating the performance of the stocks that are held by the ETF, such as the Invesco QQQ ETF, which tracks the Nasdaq-100 Index. Two… more