This post details a Microsoft Excel dashboard that tracks the day's performance of the holdings of the iShares A.I. Innovation and Tech Active ETF (Symbol: BAI).
From the iShares website as to the objective of the ETF:
Active approach to artificial intelligence (AI) and tech: Selects a concentrated portfolio of global AI and technology equities across all market capitalizations, chosen through bottom-up, research-driven fundamental investing.
The ETF currently has over $8.37B in assets under management (AUM).
Here is a list of the current top ten holdings:
| Ticker | Name | Weight (%) |
|---|---|---|
| NVDA | NVIDIA CORP | 8.36% |
| AVGO | BROADCOM INC | 7.46% |
| GOOGL | ALPHABET INC CLASS A | 4.75% |
| MSFT | MICROSOFT CORP | 4.09% |
| TSM | TAIWAN SEMICONDUCTOR MANUFACTURING | 4.08% |
| LRCX | LAM RESEARCH CORP | 3.46% |
| SNOW | SNOWFLAKE INC | 3.22% |
| CLS | CELESTICA INC | 3.11% |
| 660 | SK HYNIX INC | 3.06% |
| TSEM | TOWER SEMICONDUCTOR LTD | 2.98% |
Below is an image of the downloadable Excel Dashboard. During the trading session, the Excel dashboard dynamically ranks the individual stocks held by ARKG. The Excel dashboard displayed below 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. Turning off Extensions in your browser will make this happen faster.
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 fund is actively managed. The current holdings are as of 1/09/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 50 milliseconds or lower. Learn how to do that here.
More information regarding Artificial Intelligence ETFs can be found here:
ETF.com: Artificial Intelligence ETFs
Two dashboards are available: One has a solid black background, and one has an image background.
These symbols from the Holdings List are not available from the CQG data feed.
| Symbol | Company | Exchange |
|---|---|---|
| 034020 | DOOSAN ENERBILITY LTD | Korea Exchange (Stock Market) |
| 007660 | ISUPETASYS LTD | Korea Exchange (Stock Market) |
| 000660 | SK HYNIX INC | Korea Exchange (Stock Market) |
| 3017 | ASIA VITAL COMPONENTS LTD | Taiwan Stock Exchange |
| 3661 | ALCHIP TECHNOLOGIES LTD | Taiwan Stock Exchange |
Special Note: These four symbols are not traded on US Stock Exchanges.
| Symbol | Company | Exchange |
|---|---|---|
| 6857 | ADVANTEST CORP | Tokyo Stock Exchange |
| 9984 | SOFTBANK GROUP CORP | Tokyo Stock Exchange |
| ENR | SIEMENS ENERGY N AG | Xetra - Deutsche Börse Group |
| PME | PRO MEDICUS LTD | Australian Stock Exchange |
Requires CQG Integrated Client or CQG QTrader, data enablements for the NYSE, the Nasdaq, the Tokyo Stock Exchange, the Australian Stock Exchange, Xetra - Deutsche Börse Group, and Excel 2016 or more recent.