This post builds upon the previous post: Excel 365 TRIMRANGE Function.
That post detailed how to build a quote display using the TRIMRANGE function to automatically manage working with… more
Workspaces
Microsoft Excel 365 offers the TRIMRANGE function which excludes all empty rows and/or columns from the outer edges of a range or array. This post details how this function is useful for designing… more
This Excel Dashboard uses RTD Calls to pull in the Net Percent Change of a collection of markets by a particular date.
For example, April 9, 2025:
"Markets News, April 9, 2025: Dow… more
This post details adding HTML News Links to an Excel dashboard for monitoring equities and ETFs.
The news source is Finance.Yahoo.com. An example link for Microsoft is https://finance.yahoo.… more
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