Mutual Fund Yield

Returns the distribution yield for a mutual fund.

Parameters

Parameter Type Required Description
Symbol string Yes Mutual fund ticker symbol

Examples

=MF_Yield("VFIAX")
Vanguard 500 yield
=MF_Yield("FXAIX")
Fidelity 500 yield

When to Use

  • Income analysis
  • Fund comparison
  • Distribution planning

When NOT to Use

Scenario Use Instead
Fund price MF_Price()
Stock dividend yield DividendYield()

Common Issues & FAQ

Q: Is this the 30-day SEC yield? A: Check fund documentation for specific yield methodology.

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

Related Functions