MarketXLS

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)
Excel Desktop (Windows)

Parameters

symbolstringRequired

Mutual fund ticker symbol

Returns

number

Mutual fund NAV/price

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

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:

See MF_Price used in a complete workbook: Mutual Funds Prices in Excel (With MarketXLS Add-in)

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