Fund Total Assets
Returns the total assets for an ETF or mutual fund. Total assets represent the gross value of all assets held by the fund before subtracting liabilities.
Return Value
A numeric value in USD representing the fund's total assets.
Notes
- Returns "NA" for stocks or invalid symbols
- Total assets includes cash, securities, receivables, and other assets
- Compare with FundNetAssets to understand the fund's leverage
Syntax
=FundTotalAssets(Symbol)Parameters
ETF or mutual fund ticker symbol
Returns
Total assets of the fund in USD
Examples
=FundTotalAssets("SPY")=FundTotalAssets("QQQ")=FundTotalAssets("FXAIX")=FundTotalAssets(A1)/1e9When to Use
- Analyzing fund balance sheet
- Comparing gross fund size
- Understanding fund leverage (compare total vs net assets)
When NOT to Use
| Scenario | Use Instead |
|----------|-------------|
| Need net assets (after liabilities) | FundNetAssets() |
| Need stock total assets | Use fundamental functions |
Common Issues & FAQ
What's the difference from FundNetAssets?
FundTotalAssets is gross (before liabilities). FundNetAssets subtracts liabilities. For most funds the difference is small.
Related Formulas
More MarketXLS ETF & Funds formulas you can use in the same worksheet:
- Mutual Fund Inception Date
- Mutual Fund Previous Close
- Mutual Fund Price
- Mutual Fund Yield
- ETF Category
- ETF Fund Family
- ETF Fund Family CIK Number
- ETF Holdings
See FundTotalAssets used in a complete workbook: ETF Data in Excel: Live Screener and Cost-Quality Rankings for Late May 2026
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today