This list includes all assets than can be tracked in Google Sheets via muFunds.
Many real-time data assets (such as stocks or ETFs) are compatible with Google Finance, and in these cases we recommend the Google Finance function included in Google Sheets, which usually provides reliable data with small delays. The list of exchanges connected to Google Finance is available in their disclaimer page.
For all the other assets (mutual funds, pension plans, bonds, etc.), muFunds relies in different data sources listed below, with the codes that should be used as the {source}
argument for the muFunds
function.
Asset type | Data source | Asset identifier | Example identifier |
---|---|---|---|
UCITS mutual fund (e.g. Vanguard Global Stock Index Eur Acc) |
Morningstar (morningstar ) |
ISIN | IE00B03HD191 |
Morningstar ID | 0P00000WLG |
||
QueFondos (quefondos ) |
ISIN | IE00B03HD191 |
|
UCITS ETF (e.g. Vanguard FTSE Dev Eurp ex UK ETF Dis) |
Morningstar (morningstar ) |
|
|
Morningstar ID (recommended, uniquely identifies each listing) |
0P0001BVGE (XFRA)0P00016SSA (CHIX)0P00014D7Q (XLON)0P0001O0UQ (AQSE)0P00014D7M (XAMS)
|
||
UK mutual fund (e.g. iShares North American Eq Idx (UK) D Acc) |
Morningstar (morningstar ) |
ISIN | GB00B7QK1Y37 |
Morningstar ID | F00000OJRV |
||
UK pension fund (e.g. Baillie Gifford Japanese Equity Series 3) |
Morningstar (morningstar ) |
ISIN | GB00B2PGGQ45 |
Morningstar ID | 0P0000F3DY |
||
Spanish pension plan (e.g. MyInvestor Indexado Global PP) |
Morningstar (morningstar ) |
DGS code | N5396 |
Morningstar ID | F000016CB6 |
||
QueFondos (quefondos ) |
DGS code | N5396 |
|
Canadian mutual fund (e.g. EdgePoint Global Growth & Inc Port Sr A) |
Morningstar (morningstar ) |
Fund code | EDG180 |
Morningstar ID | 0P0000IUYM |
||
Australian mutual fund (e.g. OnePath OA FR IP-T. Rowe Price Global Eq) |
Morningstar (morningstar ) |
ISIN | AU60MMF15632 |
APIR | MMF1563AU |
||
Ticker | 18568 |
||
Morningstar ID | F00000LKY3 |
||
US mutual fund (e.g. Vanguard 500 Index Fund Admiral Shares) |
Morningstar (morningstar ) |
ISIN | US9229087104 |
Ticker | VFIAX |
||
CUSIP | 922908710 |
||
Morningstar ID | FOUSA00L8W |
||
Chinese mutual fund (e.g. China Life Security Ultra-Short Bond A) |
Morningstar (morningstar ) |
Stock code | 017305 |
Morningstar ID | F00001ESHW |
||
Singaporean mutual fund (e.g. Eastspring Inv UT Global Technology) |
Morningstar (morningstar ) |
ISIN | SG9999002794 |
Morningstar ID | 0P00006Q06 |
||
Indonesian mutual fund (e.g. Panin Dana Maksima) |
Morningstar (morningstar ) |
ISIN | IDN000016706 |
Morningstar ID | F000003YB6 |
||
Thai mutual fund (e.g. BCAP Global Private Equity 22A NFRI) |
Morningstar (morningstar ) |
ISIN | THA792010003 |
Morningstar ID | 0P0001PAL0 |
||
Brazilian mutual fund (e.g. Valora Horizon High Yield Fi) |
Morningstar (morningstar ) |
ISIN | BRVVGICTF000 |
Morningstar ID | F00000PRN3 |
||
Chilean mutual fund (e.g. BICE Balanceado Clásica) |
Morningstar (morningstar ) |
ISIN | CL0001523589 |
Morningstar ID | F00000ZUTU |
||
Mexican mutual fund (e.g. BlackRock Portafolio Estratégico Gold) |
Morningstar (morningstar ) |
ISIN | MX52GO090015 |
Morningstar ID | F00000LVWX |
||
Israeli ETF (e.g. Tachlit SAL 40 Composite Local Equity) |
Morningstar (morningstar ) |
ISIN | IL0011450694 |
Morningstar ID | F00001Q2I1 |
||
Hong Kong mutual fund (e.g. Allianz Choice Asian Ord A HKD) |
Morningstar (morningstar ) |
ISIN | HK0000061553 |
Morningstar ID | 0P0001SKSP |
||
Taiwanese mutual fund (e.g. ABITL US Growth Fund-A2 TWD) |
Morningstar (morningstar ) |
ISIN | TW000T1819A9 |
Morningstar ID | 0P0001LF7Y |
||
Malaysian mutual fund (e.g. Phillip Master Money Market) |
Morningstar (morningstar ) |
ISIN | MYU00007AA09 |
Morningstar ID | 0P00008MH7 |