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)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.
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?