ETF Net Assets
Returns the total net assets under management for an ETF.
Syntax
=ETFNetAssets(Symbol)Examples
=ETFNetAssets("SPY")When to Use
- ETF size analysis
- Liquidity assessment
- AUM comparison
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Total assets | ETFTotalAssets() |
| Liabilities | ETFTotalLiabilities() |
Common Issues & FAQ
What's the difference from total assets?
Net assets = Total assets - Total liabilities.
Related Formulas
More MarketXLS ETF & Funds formulas you can use in the same worksheet:
- ETF Report Period Date
- ETF Report Period End Date
- ETF Yield
- Fund Expense Ratio
- Fund Family
- Fund Family CIK
- Fund Holdings
- Fund Inception Date
See ETFNetAssets used in a complete workbook: Analyzing Bitcoin ETFs: How to Compare IBIT, FBTC, and More in Excel
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?