Usage and examples

Function call

Use the muFunds function to load investment fund data into your spreadsheet, in this format:

The possible values of {option} and {asset_id} are listed below, along with an optional third argument, {source}.

For example, to get the current price (or NAV) of the Vanguard Global Stock Index Eur Acc UCITS mutual fund (ISIN IE00B03HD191) from Morningstar, the default data source, use:

Data options {option}

Asset identifiers {asset_id}

muFunds can track many types of assets, including mutual funds, stocks, pension plans, bonds and ETFs, which can be known by different names or tickers depending on the context or source. Check the Compatibility list to make sure you use the right identifier for an asset and a data source.

ISIN (International Securities Identification Number)

The ISIN is a 12-character alphanumeric code that uniquely identifies a security, as a result of normalizing its assigned national identifier. Its first two characters represent the issuing country, followed by nine alphanumeric characters (the National Securities Identifying Number, or NSIN) and one numerical check digit.

Most securities (equities, debt, entitlements, derivatives…) have an ISIN, which makes it a standard asset identifier and the most used one in muFunds.

Morningstar ID

Useful for assets 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).

To find it, search for the asset on the Morningstar website and open its detail page. The Morningstar ID is the 10-character identifier in 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

Some assets can be identified by their 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. In these cases it's better to use another identifier (ISIN or Morningstar ID).

Other identifiers

• APIR, for Australian 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

Data sources {source}

• Morningstar: "morningstar" (default)
• QueFondos.com: "quefondos"

Examples

See muFunds in action in these sample spreadsheets: a single asset, multiple mutual funds, or a combination of funds and stocks with data from Google Finance.