Mutual Fund Yield
Returns the distribution yield for a mutual fund.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Symbol | string | Yes | Mutual fund ticker symbol |
Syntax
=MF_Yield(Symbol)Returns
number
Mutual fund yield
Examples
=MF_Yield("VFIAX")=MF_Yield("FXAIX")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
Is this the 30-day SEC yield?
Check fund documentation for specific yield methodology.
Related Formulas
More MarketXLS ETF & Funds formulas you can use in the same worksheet:
- ETF Category
- ETF Fund Family
- ETF Fund Family CIK Number
- ETF Holdings
- ETF Inception Date
- ETF Net Assets
- ETF Report Period Date
- ETF Report Period End Date
See MF_Yield 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
▶
How does MarketXLS work?