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

edited 30 December 2022 at 9:11AM in Savings & investments
1 reply 141 views
MK62MK62 Forumite
1.2K Posts
Fifth Anniversary 1,000 Posts Name Dropper
Forumite
edited 30 December 2022 at 9:11AM in Savings & investments
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.

Replies

  • UncleKUncleK Forumite
    99 Posts
    Fourth Anniversary 10 Posts
    Forumite
    Good to know. I have a Google Sheet with prices and exchange rates on it and then refer to that on my Excel sheets. I need to refresh it on Excel manually which is OK and means it doesn't slow things down. Not sure if I could get it to update automatically but given it might slow me down, I'm not sure I'll try...........
Sign In or Register to comment.
Latest MSE News and Guides

Boost your Nectar points

Get up to £25 in bonus points

MSE News

Ask an Expert: Scams

Watch MSE Katie's answers to your questions

MSE Forum

Hot Diamonds 40% off code

Including already-reduced outlet stock

MSE Deals