Workspaces

This post details an Excel dashboard tracking Country Equity ETFs performance. The dashboard ranks and sorts the Country ETFs traded using the NYSE American enablement. Fifty-one ETFs are tracked… 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 post details the downloadable Excel Market Performance Dashboard's features and functions. The dashboard has seven tabs (the first is data and the other tabs display a chart and a table of… more

This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the iShares Core S&P U.S. Value ETF (symbol: IUSV). The iShares Core S&P U.S. Value ETF seeks to track the investment… 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

Recent posts detailed observing market data during pre-, current, and post-market sessions. The post View Pre and Post Sessions for Stocks detailed the steps to displaying a chart that included… more

The Excel MAXIF function returns the maximum value from a range of cells and a criteria range. For example. The downloadable sample at the bottom of this post is determining the best performance… more