Extension for LibreOffice Calc to make stock market, index and FX data available in a Calc spread sheet - currently supports Yahoo's, Financial Times' and Google's (without FX data) finance web sites using web scraping.

System dependencies:

Requires the following Python 3 (used by LibreOffice) packages (on top of standard libs): dateutil, pytz, pyparsing

The following steps have worked for me on a fresh Debian installation (as root)

apt install python3-pip
pip3 install python-dateutil
pip3 install pytz
pip3 install pyparsing

Usage:

Have a look at the 'releases' tab above: download a prebuild Financials-Extension.oxt file and load it into Calc under menu item: Tools, Extension Manager...

There is a file examples.ods there too with usage examples and possible arguments to functions.

You have to check the respective web sites to work out what symbol is the right one for you. If a web site doesn't have the symbol/asset you want, this extension can't help you either. Having said that, I mostly look at US and West European equities, ETFs and mutual funds and major FX rates - if you have issues with the data available for other assets or assets in other regions, drop me a line (best to include full URLs and possibly the same asset listed on more than one site for comparison). While data for last price is most likely consistent across sites, they will differ when it comes to less well defined data points.

Dealing with missing data:

First of all, a hint for using LibreCalc: if you want to refresh data you can press SHIFT-CTRL-F9 - this will force a recalculation of all formulas in all sheets.

Secondly the extension saves some debug information under your user directory in a directory ".financials-extension": the HTML for each stock symbol is saved in a separate file (depending on source and ticker symbol). You can open it your favorite web browser (or other tools) to check if the page actually contained the information you are looking for. If it does the file trace.log has a record of all calls to the extension and the value returned to LibreOffice.

Build:

You will need the LibreOffice SDK installed.

On my system I installed packages: libreoffice-dev libreoffice-java-common libreoffice-script-provider-python

# depending on your location...

cd ~/tech/IdeaProjects/Financials-Extension/

python3 src/test_yahoo.py

python3 src/test_google.py

# This builds file Financials-Extension.oxt

./compile.sh

Tested with:

Debian 10.3 / LibreOffice Calc 6.1.5.2 / Python 3.7.3
Ubuntu 20.04 / LibreOffice Calc 6.4.3.2 / Python 3.8.2
Ubuntu 19.10 / LibreOffice Calc 6.3.5.2 / Python 3.7.6
Ubuntu 19.04 / LibreOffice Calc 6.2 / Python 3.7.3
Ubuntu 18.04 / LibreOffice Calc 6 / Python 3.6.7
Ubuntu 16.04 / LibreOffice Calc 5 (previous versions)