LOC Extension for LibreOffice Calc

46 32

The LOC Extension enables you to create spreadsheets with crypto currency market data pulled directly from the web. Version 0.1.0 has only one datasource: Poloniex. Others are planned.

Project Description

LibreOffice Calc crypto price lookup extension

The LOC extension allows you to create customized spreadsheets with crypto currency market data directly from the web. The initial version supports only one source - Poloniex - but others are planned.


The LOC Extension adds a new function to Calc:


Quotes must be used when entering the ticker directly ex: GETPOLONIEX("BTC_ETH","last"), but are not needed when referencing another cell ex: GETPOLONIEX(A1,A2).

In the latter case the data in A1 should be BTC_ETH, not "BTC_ETH".

NOTE: The full set of datacodes are demonstrated in the example .ods worksheets included with the release.


Version 0.1.0 is fully standalone. The 3rd-party Poloniex API wrapper requirement has been removed.


For general support please visit the forums. If you find a bug or wish to request a feature please file an issue at the issue tracker.


Help is always welcome with development. If you would like to contribute you will need to fork the main repo, make your changes, and send a pull request to have your changes moderated and merged back into the main repo. Details on that process can be found here.

If you don't like the extension for some reason, don't just give it a thumbs down. Instead, open an issue on github. 


The LOC Extension is released under the which in layman's terms means:

  • You are permitted to use, copy and redistribute the work "as-is".
  • You may adapt, remix, transform and build upon the material, releasing any derivatives under your own name.
  • You may use the material for commercial purposes as long as the derivative is licenced under the GPL.
  • You must track changes you make in the source files.
  • You must include or make available the source code with your release.

Other Contributors and Thanks!

  • madsailor - provided the original SMF Extension that LOC is based on


Calc Extension,

Homepage of the Project


Current Release

No stable release available yet.

Latest Not Stable Release

LOC Extension for LibreOffice Calc - 0.2.0

tested with:

LibreOffice 5.3, LibreOffice 5.4,

File size: 115 kb

All Releases









  • Linux
  • Linux-x64
  • Windows
  • LibreOffice 5.3
  • LibreOffice 5.4
Version 0.2.0 embeds a snapshot of ccxt library (version 1.9.262) and adds a new CCXT(Exchange, Ticker, Datacode) function to provide access to over 90 exchanges. The original GETPOLONIEX(Ticker, Datacode) function is retained for backwards compatibility.
  • LGPL-v3+ (GNU Lesser General Public License Version 3 and later)


  • Linux
  • Linux-x64
  • LibreOffice 5.3
First standalone version
  • LGPL-v3+ (GNU Lesser General Public License Version 3 and later)

Legal Disclaimer and Limitations for Downloads

The Document Foundation has not reviewed, and cannot review, all of the material, including computer software, available on or by means of The Document Foundation's
websites, and cannot therefore be responsible for that material's content, use or effects. By operating its websites, The Document Foundation does not represent or imply that it endorses the material there available, or that it believes such material to be accurate, useful or nonharmful. You are responsible for taking precautions as necessary to protect yourself and your computer systems from viruses, worms, Trojan horses and other harmful or destructive content. The Document Foundation's websites may contain content that is offensive, indecent or otherwise objectionable, as well as content containing technical inaccuracies, typographical mistakes and other errors. The Document Foundation's websites may also contain material that violates the privacy or publicity rights, or infringes the proprietary rights, of third parties, or the downloading, copying or use of which is subject to additional terms and conditions, stated or unstated. The Document Foundation disclaims any responsibility for any harm resulting from the use by The Document Foundation's visitors of The Document Foundation's websites, or from any downloading by those visitors of content available on or by means of The Document Foundation's websites.


Content contained on The Document Foundation's websites, including these Legal Disclaimers and Limitations, may be changed at the sole discretion of The Document Foundation and without notice. You are bound by any such updates or changes, and so should periodically review these Legal Disclaimers and Limitations.

If you believe any file is present on the site contrary to any TDF rule or applicable law, please supply full details to info@documentfoundation.org for impartial consideration.