Financial extension for LibreOffice
Posted: October 8th, 2021, 12:47 pm
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
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