Mutual Funds Prices in Excel (With MarketXLS Add-in)

To get mutual fund prices in Excel, install the MarketXLS add-in and type =MF_Price("BIAGX") in a cell. The function returns the fund's latest net asset value (NAV). Mutual funds price once a day after the market closes, so the value updates when the fund company publishes its new NAV, not tick by tick like a stock. =QM_Last("BIAGX") also returns the latest price for a fund symbol.

See it in actionMarketXLS video

The full MarketXLS demo

Watch full demoBook a demo

Try it in your own spreadsheet

Get the free MarketXLS sample workbook (.xlsx).

Email address

Download free workbook

No account needed. MarketXLS live data requires a paid plan. Preview workbook

Explore more videos +

IntroductionHistorical DataOptions DataUse-cases

MarketXLS functions for mutual fund analysis

Each function below takes the fund's ticker symbol and returns one value (or a table) into the cell:

• =MF_Price("BIAGX"): latest NAV per share.
• =MF_PreviousClose("BIAGX"): the prior day's NAV.
• =MF_Yield("BIAGX"): the fund's distribution yield.
• =FundExpenseRatio("BIAGX"): the annual expense ratio.
• =FundNetAssets("BIAGX"): total net assets of the fund.
• =FundFamily("BIAGX"): the fund company that manages it.
• =FundHoldings("BIAGX"): the fund's holdings as a spilled table.
• =QM_GetHistory("BIAGX"): price history for return and volatility calculations.

On the Microsoft 365 add-in (Excel for Mac and Excel for the web), add the mxls. prefix, for example =mxls.MF_Price("BIAGX"). Some functions differ by platform, so check /formulas for the version you use.

Mutual Fund Prices in Excel

How to build a mutual fund tracker in Excel

A mutual fund tracker is a table with one fund per row and one MarketXLS function per column:

1. List your funds. Put ticker symbols in column A.
2. Add current values. Use =MF_Price(A2), =MF_Yield(A2), and =FundExpenseRatio(A2) in the next columns and fill down.
3. Study the portfolio. Run =FundHoldings(A2) on a separate sheet to see what the manager owns and how concentrated the top holdings are. The mutual fund overlap calculator shows how much two funds hold in common.
4. Compare with a benchmark. Pull =QM_GetHistory for the fund and for its benchmark index fund or ETF, then compare returns over the same period. The mutual fund compare tool does a side-by-side view without a spreadsheet.
5. Screen for new funds. Use the mutual fund screener to find candidates by category, cost, or yield, then add them to your sheet.

Past returns do not predict future returns. The tracker helps you see cost, yield, holdings, and history in one place; it does not tell you which fund to buy. This is educational content, not investment advice.

What you need to use these functions

MarketXLS is a paid add-in for Excel on Windows, and a Microsoft 365 add-in for Excel on Mac and Excel for the web. It adds more than 1,000 financial functions. US plans start with Standard at $70/month billed annually; see /pricing for current plans. For related articles, see DuPont analysis with MarketXLS and tracking valuation with MarketXLS.