muFunds
Use the muFunds function to load investment fund data in your spreadsheets, with the following format:
=muFunds({option}, {asset_id}) (if you use a period as decimal separator)
=muFunds({option}; {asset_id}) (if you use a comma as decimal separator)
You can find the possible values of {option} and {asset_id} below, as well as an optional {source} third argument.
Example: You can retrieve the current price (or NAV) of the Vanguard Global Stock Index Eur Acc UCITS mutual fund (with ISIN IE00B03HD191) from Morningstar (muFunds' default data source) with =muFunds("nav", "IE00B03HD191").
{option})"nav": Net Asset Value (NAV) or price.
"change"/"return1d": Last NAV/price change.
"currency": Asset currency, in 3-letter code.
"date": Last NAV/price date.
"expenses": Total Expenses Ratio (TER).
"category": Fund category according to the source.
"returnytd": Fund year-to-date (YTD) return.
"return1m": Fund return in the last month.
"return3m": Fund return in the last 3 months.
"return1y": Fund return in the last year.
"return3y": Fund return in the last 3 years (annualized).
"return5y": Fund return in the last 5 years (annualized).
{asset_id})muFunds can track several types of assets, including mutual funds, stocks, pension plans, bonds, ETFs... that can be identified by different names or tickers at the same time, depending on the context or source. Check the Compatibility list to make sure you use the proper identifier(s) for an asset and a data source.
ISIN (International Securities Identification Number)
The ISIN is a 12-character alphanumeric code used for unique identification of a security, as a result of normalizing its assigned national identifier. Its first two characters represent the issuing country, followed by nine alpha-numeric characters (the National Securities Identifying Number or NSIN) and one numerical check digit.
Most securities (equities, debt, entitlements, derivatives...) are identified by a ISIN, which makes a standard asset identifier and the most used for identifying assets in muFunds.
Morningstar IDs
These identifiers are particularly useful for assets that are listed in several exchanges (e.g. multi-listed stocks) or that cannot be uniquely identified with a standard identifier (e.g. stocks that share the same ticker in different markets).
In this case, you can obtain this identifier by searching an asset in the Morningstar website and going to its detail page. Then you can extract the Morningstar ID as the 10-character identifier from the URL. For example:
https://global.morningstar.com/en-gb/investments/funds/0P00000WLG/quote
https://global.morningstar.com/es/inversiones/pensiones/0P0001LIG7/cotizacion
Country or market ticker
Certain assets can be identified through a ticker in their market. Unlike Google Finance, Morningstar does not use prefixes for every market, so the same ticker can refer to different assets in different markets, making preferrable to identify assets via another identifier (ISIN or Morningstar ID) in these cases.
APIR (for Australia and New Zealand mutual funds)
DGS code (for Spanish pension plans)
Canada fund code (for Canadian mutual funds)
CUSIP (for North American securities)
Chinese stock code (for Chinese securities)
{source})"morningstar", default)"quefondos")Check out our Google Sheets spreadsheet samples that use muFunds in different scenarios: a single asset, multiple mutual funds or a combination of funds and stocks with info from Google Finance.