ETF Holdings
Returns the complete list of holdings for an Exchange-Traded Fund (ETF), including each holding's ticker symbol, name, percentage weight, and report date information.
Return Format
Returns tabular data with columns:
| Column | Description |
|---|---|
| Ticker | Stock symbol of holding |
| Name | Company name |
| Percentage Value | Weight in fund (0.07 = 7%) |
| Payoff Profile | Long/Short position |
| Report Date | Date of filing |
| Report Period End Date | Period end date |
Notes
- Weights are expressed as decimals (0.07 = 7%)
- Data comes from ETF regulatory filings
- Updates periodically based on fund's reporting schedule
- Only works with ETF symbols, not individual stocks
Syntax
=ETFHoldings(Symbol)Examples
=ETFHoldings("SPY")=ETFHoldings("QQQ")=ETFHoldings("VTI")=ETFHoldings("XLF")=ETFHoldings(A1)When to Use
- Analyzing ETF composition and top holdings
- Understanding sector/stock exposure through ETFs
- Comparing ETF holdings across similar funds
- Due diligence on ETF investments
- Building overlap analysis between ETFs
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need ETF price | Last() |
| Need ETF yield | ETFYield() |
| Need ETF total assets | ETFTotalAssets() |
| Need mutual fund holdings | Mutual fund-specific functions |
Common Issues & FAQ
Why am I getting no data?
This function only works with ETF symbols. Individual stocks don't have "holdings."
How current is the holdings data?
Holdings come from ETF regulatory filings, typically updated quarterly. Check the Report Date column for the filing date.
Why don't the percentages add up to 100%?
ETFs may have hundreds of holdings. The data shows all holdings, but smaller positions may have very small weights.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?