Mutual Fund Price
Returns the Net Asset Value (NAV) price for a mutual fund.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Symbol | string | Yes | Mutual fund ticker symbol |
Notes
- Returns the NAV which is updated daily after market close
- Use mutual fund ticker symbols (e.g., VFIAX, FXAIX)
Syntax
=MF_Price(Symbol)Parameters
symbolstringRequired
Mutual fund ticker symbol
Returns
number
Mutual fund NAV/price
Examples
When to Use
- Mutual fund portfolio tracking
- NAV lookups
- Fund performance monitoring
- Investment spreadsheets
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Stock prices | Last() |
| ETF prices | Last() |
| Fund yield | MF_Yield() |
| Fund assets | MF_NetAssets() |
Common Issues & FAQ
When is NAV updated?
Mutual fund NAVs are typically updated daily after market close.
Related Formulas
More MarketXLS ETF & Funds formulas you can use in the same worksheet:
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?