b0f77 wrote:I have Google sheets to automate my portfolio valuations by importing price data from the FT site for all my funds as Google Finance does not have price data from them.
What I do is use an "Import HTML" function to import prices into a table sheet like this:Code: Select all
=IMPORTHTML("https://markets.ft.com/data/funds/tearsheet/historical?s=GB00B4R2F348:GBP","table",1)
This one is importing price data for Vanguard LS60 Inc fund from here:
https://markets.ft.com/data/funds/tears ... R2F348:GBP
You just need to find the FT page with the price data for your fund.
That gives me a table and the first row has the latest closing price from the last business day in a column, and I use that from my other sheets.
If Excel has a similar HTML import function, you could do the same.
You may also be able to get the data like this from another source - for example with L&G I have done the same direct from their site.
It is a bit fragile to the "provider" changing their web site structure, however - so your mileage may vary
I have just tried cutting and pasting that code into my sheet to test so I could add in my own funds but it didn't work.
I don't know if its an old function or references something that has moved.
Anyone else can confirm if this still works