Fund Holdings
Returns the complete list of holdings for an ETF or mutual fund. The data spills into adjacent cells below and to the right of the formula cell, showing each holding's details.
Return Value
The formula cell displays "{Symbol} Holdings" (e.g., "SPY Holdings"). The actual data is a table that spills into surrounding cells.
Spill Behavior
?? This function writes data to multiple cells. Ensure there is enough empty space below and to the right of the formula cell, or you'll get a spill error.
Notes
- Returns "NA" for stocks or invalid symbols
- A confirmation dialog appears before overwriting existing cell data
- Holdings are as reported in the fund's most recent SEC filing
- Can return hundreds of rows for broad index funds like SPY or VTI
Syntax
=FundHoldings(Symbol)Examples
=FundHoldings("SPY")=FundHoldings("QQQ")=FundHoldings("VFIAX")=FundHoldings("ARKK")When to Use
- Analyzing fund composition and top holdings
- Checking overlap between multiple funds
- Identifying sector or stock concentration in a fund
- Portfolio transparency and look-through analysis
When NOT to Use
\
Common Issues & FAQ
I'm getting a #SPILL error.?
The cells below or to the right of the formula contain data. Clear the area to allow the holdings table to spill.
The function shows "Cancelled".?
You clicked "Cancel" on the overwrite warning dialog. The function asks for confirmation before writing data to multiple cells.
Holdings seem outdated.?
Holdings reflect the most recent SEC filing. Use FundReportPeriodEndDate() to check the "as-of" date.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today