About 4 years ago, Eventide created an Excel add-in for extracting share data from Yahoo: viewtopic.php?f=27&t=8332&hilit=excel+eventide#p94736
I've often pondered creating a similar extension for LibeOffice but never quite got beyond the pondering stage, then yesterday, by chance, I found that such an extension already exists: https://github.com/cmallwitz/Financials-Extension
It extracts financial information for shares from Yahoo and the Financial Times, using a formula such as =GETREALTIME("SSE.L",21,"YAHOO") or =GETREALTIME("SSE.L","LAST_PRICE","YAHOO"). Various data is available such as Bid, Ask, Yield, etc, and (Yahoo only) historic prices.
I've tried in on Windows 10 and Linux Mint and it seems to work fine, though perhaps missing some of the elegance of Eventide's Excel implementation.
--kiloran
Got a credit card? use our Credit Card & Finance Calculators
Thanks to Rhyd6,eyeball08,Wondergirly,bofh,johnstevens77, for Donating to support the site
Financial extension for LibreOffice
-
- Lemon Quarter
- Posts: 4112
- Joined: November 4th, 2016, 9:24 am
- Has thanked: 3252 times
- Been thanked: 2855 times
-
- Lemon Quarter
- Posts: 4179
- Joined: November 4th, 2016, 9:42 pm
- Has thanked: 1001 times
- Been thanked: 1855 times
Re: Financial extension for LibreOffice
kiloran wrote:I've tried in on Windows 10 and Linux Mint and it seems to work fine...
Nice, thanks. I've tried it in LibreOffice Portable on Windows 11 and seems to work fine there too.
Return to “Financial Software - Discussion”
Who is online
Users browsing this forum: No registered users and 24 guests