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)

Examples

=MF_Price("VFIAX")
Vanguard 500 Index Fund
=MF_Price("FXAIX")
Fidelity 500 Index Fund
=MF_Price("VTSAX")
Vanguard Total Stock Market

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

Q: When is NAV updated? A: Mutual fund NAVs are typically updated daily after market close.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Mutual Fund Price and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions