This year, 2026, has seen a rotation towards large cap value stock. This post details a downloadable Microsoft Excel dashboard that tracks the current sessions performance of the holdings of the iShares S&P 500 Value ETF.
From the website:
The iShares S&P 500 Value ETF seeks to track an index composed of U.S. large-cap stocks, selected using metrics such as book value, earnings, and sales. The fund provides targeted exposure to the U.S large-cap value stocks.
The image below shows the current year performance of IVE (blue) versus the SPY (green).
While IVE has lagged SPY the chart does show less volatility by IVE. In addition, the current dividend yield for IVE is a little over 1.50% and the SPY dividend yield is a little over 1.00%
Top Ten Holdings (8/12/2026)
| Ticker | Company | Sector | Weight |
|---|---|---|---|
| S.AAPL | Apple Inc. | Information Technology | 7.35% |
| S.AMZN | Amazon.com Inc | Consumer Discretionary | 4.07% |
| S.XOM | ExxonMobil Holdings Corporation | Energy | 2.19% |
| S.WMT | Walmart Inc | Consumer Staples | 1.68% |
| S.INTC | Intel Corp | Information Technology | 1.65% |
| S.BAC | Bank of America Corp | Financials | 1.40% |
| S.COST | Costco Wholesale | Consumer Staples | 1.39% |
| S.UNH | UnitedHealth Group Inc | Health Care | 1.22% |
| S.CVX | Chevron Corp | Energy | 1.22% |
| S.TSLA | Tesla, Inc. | Consumer Discretionary | 1.16% |
Top Ten Percentage Gains as of 8/12/2026
| Ticker | Company | Gain |
|---|---|---|
| S.US.DELL | Dell Technologies Inc. | 300.87% |
| S.US.STX | Seagate Tch Hldgs Or | 230.97% |
| S.US.INTC | Intel Corp | 186.40% |
| S.US.WDC | Western Digital Cp | 184.90% |
| S.US.MRVL | Marvell Tech Inc Cmn | 168.89% |
| S.US.HONA | Honeywell Aerospace Inc | 166.93% |
| S.US.HPE | Hewlett Packard Enterprise Company | 157.95% |
| S.US.FDXF | FedEx Freight Holding Company, Inc. | 144.00% |
| S.US.MRNA | Moderna Inc Cs | 118.48% |
| S.US.MPC | Marathon Petroleum Corporation | 115.58% |
Bottom Ten Percentage Gains as of 8/4/2026
| Ticker | Company | Return |
|---|---|---|
| S.US.NKE | Nike Inc Clsb | -35.99% |
| S.US.APTV | Aptiv Plc | -36.17% |
| S.US.FICO | Fair Isaac Inc | -36.67% |
| S.US.PNR | Pentair Ltd. | -37.07% |
| S.US.ZTS | Zoetis Inc | -41.35% |
| S.US.LULU | Lululemon Athletica | -42.00% |
| S.US.BSX | Boston Scientific Corp | -45.51% |
| S.US.INTU | Intuit Inc | -48.09% |
| S.US.CSGP | CoStar Group Inc | -53.06% |
| S.US.TTD | The Trade Desk Cl A | -63.33% |
Below is an image of the downloadable Excel Dashboard. During the trading session, the Excel dashboard dynamically ranks the individual stocks held by IGE.
The Excel dashboard shows the top fifteen positive and bottom fifteen negative performers as histogram bar charts, along with their respective net percent change for today's trading session.
The top section of the quote display allows you to enter your own symbols.
The second section displays the top fifteen performers. The third section displays the bottom fifteen performers.
Quote data includes today's net change as a ratio to the 21-day Average True Range study. Next to today's traded volume is a column that calculates the ratio of today's volume versus the 21-day average of the volume. This ratio column gives you a sense of how active today's trading is relative to recent history. Readings of 100% and higher indicate active trading.
A key feature next to each company name is a link to Yahoo Finance. Clicking the News link will take you to the Yahoo page for that symbol. Note that this could take approximately 30 seconds to open in a browser.
If you open another Excel spreadsheet, then this dashboard will no longer be the active spreadsheet. The macro that updates the links and ranks the stocks by performance will stop. To start the macro, simply click the News toolbar button in the first column.
The current holdings are as of 8/12/2026. There is a Symbols tab with instructions detailing where to download the latest posted spreadsheet with the current holdings and steps to update the dashboard. Make sure to lower your Excel Realtime Data (RTD) throttle to 100 milliseconds. Learn how to do that here.
Requires CQG Integrated Client or CQG QTrader, data enablements for the NYSE and Nasdaq.