Google Finance portfolio tracking

For Google Sheets fans with UK mutual funds in their portfolio, here’s a way your spreadsheet can grab the recent prices from Yahoo finance. (The work of @simran , @Jim_mcgrain , others and this and got me there, thanks.)

=iferror(index(IMPORTHTML(“Symbol Lookup from Yahoo Finance”,1),1,2))

is the formula which grabs the price (currently it is the previous close, not the current price, but that’s fine for me because mutual funds are priced once a day I think. The formula tries a couple of times because Sheets sometimes fails the first time it tries to get the price.)

And cell A7 contains the fund’s ISIN code with .L appended. So eg for Vanguard Lifestrategy 80, A7 would contain GB00B4PQW151.L