LibreOffice Calc extension for pulling fund/share prices off the web

1.2K Posts

Apologies if this is already generally known, but I've just come across a
rather useful extension for the LibreOffice Calc spreadsheet application
which pulls fund and share prices from the web directly into a
spreadsheet......and it's easy to use......just thought I'd share this in case anyone else finds it useful too.
To pull the latest price for VLS80 from the Financial Times website, for example, just enter this into a cell (after installing the extension of course).....
=GETREALTIME("GB00B4PQW151",21,"ft")
where "GB00B4PQW151" is the ISIN code for the fund, 21 is the internal extension code for "last price", and "ft" is the code for the FT website (all explained on the site above and in the example.ods spreadsheet on the same site)
One minor drawback is that if the spreadsheet contains lots of links, it slows down as the extension is updating the links (and is slow to open for the same reason)...another is that many of the codes/fields don't work for funds (but the main ones do)...... these don't bother me that much tbh, but ymmv.
3
Latest MSE News and Guides
Replies