Google Finance Down?

I do use importxml() on Morningstar to grab some data, but googlefinance() is so much simpler…

For price, I do the following. ‘B37’ is a reference to a cell where I have Morningstar’s ID code for the particular security (which looks something like ‘0P00018NKW’):

IMPORTXML(concat("https://www.morningstar.co.uk/uk/funds/snapshot/snapshot.aspx?id=",B37), "//*[(@id = "overviewQuickstatsDiv")]//tr[(((count(preceding-sibling::*) + 1) = 2) and parent::*)]//*[contains(concat( " ", @class, " " ), concat( " ", "text", " " ))]")

(I didn’t create that magic incantation for extracting the data from the page. I found it on the excellent Simple Living in Somerset blog at a walk on the wild side – Simple Living In Somerset, and he got it from a post on Lemon Fool at Unit trust and OEIC prices in Google Sheets - The Lemon Fool)

3 Likes