GoogleFinance Formulas - Mutual Fund Examples
GoogleFinance Formulas - Mutual Fund Examples
Category
Attributes
Example of Formula
Netassets Change Changepct
Yieldpct Returnday return1 return4 return13 return52 return156 return 260 Incomedividend Incomedividenddate Capitalgain Capitalgaindate Morningstarrating
Expenseratio
The day-end net assets of the mutual fund. Net-asset figures are useful in gauging a fund's size, agility, and popularity. They help determine whether a small company fund, for example, can remain in its investment-objective category if its asset base reaches an ungainly size. =googlefinance("SWPIX", "netassets")
change in NAV value between the most recent reported NAV, and the NAV prior to that.
=googlefinance("SWPIX", "change")
% change in the NAV.
=googlefinance("SWPIX", "changepct")
Also known as the distribution yield, Morningstar computes this End Yield figure by summing the trailing 12-month's income distributions and dividing the sum by the last month's ending NAV, plus capital gains distributed over the same time period. Income refers only to interest payments from fixed-income securities and dividend payments from common stocks.
=googlefinance("SWPIX", "yieldpct")
one-day total return.
=googlefinance("SWPIX", "netassets")
one-week total return.
=googlefinance("SWPIX", "return1")
four-week total return.
=googlefinance("SWPIX", "return4")
thirteen-week total return.
=googlefinance("SWPIX", "return13")
52 week total return.
=googlefinance("SWPIX", "return52")
156 week total return.
=googlefinance("SWPIX", "return156")
260 week total return.
=googlefinance("SWPIX", "return260")
amount of the most recent cash distribution for the fund.
=googlefinance("SWPIX", "incomedividend")
date the above occurred.
=googlefinance("SWPIX", "incomedividenddate")
amount of the most recent capital gain distribution from the fund.
=googlefinance("SWPIX", "capitalgain")
date of the above.
=googlefinance("SWPIX", "capitalgaindate")
Morningstar "star" rating.
=googlefinance("SWPIX", "morningstarrating")
percentage of fund assets used to pay for operating expenses and management fees, including 12b-1 fees, administrative fees, and all other asset-based costs incurred by the fund, except brokerage costs. Fund expenses are reflected in the fund's NAV. Sales charges are not included in the expense ratio.
=googlefinance("SWPIX", "expenseratio")
Syntax: =GoogleFinance("symbol","attribute")
"symbol" represents the stock symbol of the company or mutual fund you're looking for (like GOOG, QQQ, XXXXX, and so on), and "attribute" represents the type of market data that you want (like Price, Volume, and so on). If the attribute is left blank, price is returned by default. In the formula, a semicolon also works in place of a comma.
Note: Stock quotes and other data may be delayed up to 20 minutes. Information is provided "as is" and solely for informational purposes, not for trading purposes or advice. You are allowed 250 GoogleFinance functions in a single spreadsheet.
Try these mutual fundsAston/Optimum Mid Cap (CHTTX), Royce Opportunity (RYPNX), T. Rowe Price (PRMSX), Vanguard 500 Index (VFINX) Note: Stock symbols do not need to be capitalized.
From:
Andy Mann amann@
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- sandp 500 etf the vanguard group
- 1 2 1 1 university of virginia
- buffett recommendations vfinx index funds
- preliminary year end distributions vanguard
- 8 3 2 9 5 1 fpl capital
- vanguard 500 index vfinx sec
- page 1 of 11 oakmark select advisor oaylx vanguard 500
- vanguardtotal bond market ii index fund the vanguard group
- 9 1 2 0 6 2
- 9 6 2 0 8 2
Related searches
- mutual fund investments for beginners
- mutual fund investment
- vanguard mutual fund return rate
- guide to mutual fund investing
- best mutual fund for retirees
- fidelity mutual fund performance chart
- fidelity mutual fund performance comparison
- fidelity mutual fund performance ytd
- fidelity mutual fund performance comparis
- mutual fund for retirement
- fidelity mutual fund list
- mutual fund dividend reinvestment calculator