Fund Net Assets
Returns the net assets for an ETF or mutual fund. Net assets represent total assets minus total liabilities — the actual value available to shareholders.
Return Value
A numeric value in USD representing the fund's net assets.
Notes
- Returns "NA" for stocks or invalid symbols
- Net assets = total assets - total liabilities
- Useful for gauging fund size and liquidity
- Larger funds tend to have lower tracking error and tighter bid-ask spreads
Syntax
=FundNetAssets(Symbol)Examples
=FundNetAssets("SPY")=FundNetAssets("QQQ")=FundNetAssets("VFIAX")=FundNetAssets(A1)=FundNetAssets("SPY")/1e9When to Use
- Evaluating fund size and liquidity
- Screening for large or small funds
- Comparing fund scale across providers
- Assessing fund viability (very small funds risk closure)
When NOT to Use
| Scenario | Use Instead |
|----------|-------------|
| Need gross total assets | FundTotalAssets() |
| Need per-share NAV | Last() |
| Need stock market cap | MarketCapitalization() |
Common Issues & FAQ
The number is very large — what units is it in?
Net assets are returned in USD. Divide by 1,000,000,000 to get billions.
What's the difference between FundNetAssets and FundTotalAssets?
Net assets = total assets minus liabilities. Total assets includes everything before liabilities are subtracted.
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?