This post details a Microsoft Excel dashboard that tracks the day's performance of the holdings of the VanEck Data Center Supply Chain ETF (Symbol: RACK).
From the VanEck website detailing… more
Excel/RTD
This post details using Excel's UNICHAR function for a data visualization technique applied to a current session's percentage net change for a collection of markets. First, an introduction to both… more
This post details a Macro-Enabled Excel Dashboard that tracks the holding of the S&P 100 index and compares the percentage net change of each stock to the percentage net change of the cash S… more
This post details a Macro-Enabled Excel Dashboard that tracks the holding of the NASDAQ 100 index and compares the percentage net change of each stock to the percentage net change of the cash… more
CQG offers the Moving Linear Regression Line study. When plotted on a chart the line (blue line below) is the endpoint of a best fit line using the least squares technique. This technique finds… more
This post details a Microsoft Excel dashboard that tracks the day's performance of the holdings of the Invesco PHLX Semiconductor ETF (Symbol: SOXQ).
From the Invesco website regarding the… more
This post details a Macro-Enabled Excel Dashboard that tracks the holding of the S&P 500 Index and compares the percentage net change of each stock to the percentage net change of the cash S… more
This post is an update to: Excel 365: NASDAQ 100 Screening Dashboard.
Instead of the NASDAQ 100 Index, the iShares S&P 100 ETF (Symbol: S.OEF) is used. The ETF seeks to track an index… more
This post details using Excel's MAP function to rank the companies in the S&P 500 index performance relative to the S&P 500 index's performance. This is defined by today's percentage net… more
This post combines four Excel functions for managing market performance measurements. The market performance measurements are the top ten and bottom ten percentage net changes. The time periods… more