Returns the previous day's closing Net Asset Value (NAV) for a mutual fund.

Syntax

=MF_PreviousClose(Symbol)
Excel Desktop (Windows)

Examples

=MF_PreviousClose("VFIAX")

When to Use

  • Daily change calculation
  • NAV comparison

When NOT to Use

Scenario Use Instead
Current NAV MF_Price()

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 Previous Close and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions