Unit trust and OEIC prices in Google Sheets

Discussions regarding financial software
torata
Lemon Slice
Posts: 474
Joined: November 5th, 2016, 1:25 am

Re: Unit trust and OEIC prices in Google Sheets

Post by torata »

xeny wrote:It's looking as if the solution is to use the importhtml function - see the end of this thread:

https://www.lemonfool.co.uk/viewtopic.php?f=27&t=12318

I'm using importhtml to retrieve data from a number of different sites without any major problems. It's really nice to have real time snapshot overview of all my portfolios that puts everything into pounds.
One of my imported tables is quite large so I have to use vlookup as a second step because the data I want can move around within the table.

torata

Post Reply

Return to “Financial Software - Discussion”