The LOC extension allows you to create customized spreadsheets with cryptocurrency market data directly from the web.
Version 0.3.2 provides compatibility with LibreOffice 7.4
For the full documentation, see the original author's repo: walkjivefly
You can download the current version of the LOC Extension here: LOC.oxt
NOTE: The extension itself is LOC.oxt The example .ods worksheet demonstrates how to use the extension.
The LOC-Extension adds five new functions to Calc.
The most interesting one is CCXT
CCXT(Exchange, Ticker, Datacode)
- Exchange is any exchange name supported by the system-installed version of ccxt.
- Ticker is a currency pair from the ccxt unified API.
- Datacode is one of the ccxt supported data items for the fetch_ticker function. The one you'll probably use most is "last".
The following formula will return the current price for "BTC/USDT":
=COM.LOC.CRYPTO.GETINFO.PYTHON.LOCIMPL.CCXT("binance","BTC/USDT","last")
-
Install Manjaro libreoffice packages
libreoffice-fresh&libreoffice-fresh-sdk -
Install ccxt on Manjaro by following this tutorial
sudo pacman -S --needed git && git clone https://aur.archlinux.org/python-ccxt.git && cd python-ccxt && makepkg -si- Compile LOC.oxt
git clone https://github.com/lbayle/LOC-Extension.git
cd LOC-Extension
./compile.sh
mv LOC.oxt LOC_0.3.2.oxt- upload & activate the plugin with the LibreOffice 'Extension manager' from the
Toolsmenu
For general support please visit the author's forums. If you find a bug or wish to request a feature please file an issue at the issue tracker.
The LOC Extension is released under the
ccxt is released under the MIT license.
There is NO warranty of any kind. You use the software entirely at your own risk. I am not responsible if anything goes wrong.
- walkjivefly - the original author of this plugin : LOC-Extension
- madsailor - provided the original SMF Extension that LOC is based on
- Igor Kroitor - actively maintains the ccxt library