Here the user can specify the character used to separate arguments in formula. There is a setting in 'Tools' / 'Options.' / 'LibreOffice Calc' / 'Formula' called 'Functions'. LibreOffice: using, (comma) vs (semicolon) to separate arguments in formula Is available on the website but not from the extension, a good place to start when raising an issue is to include a similar You can start from these and search for other symbols. List of example URLs for checking symbols. While data for last price is most likely consistent across sites, they may differ for other data Having said that, I mostly look at US and West EuropeanĮquities, ETFs and mutual funds and major FX rates - if you have issues with the data available for other assets orĪssets in other regions, drop me a line (best to include full URLs and possibly the same asset listed on more than one The symbol/asset you want, this extension can't help you either. You have to check the respective websites to work out what symbol is the right one for you. There is a file examples.ods there too with usage examples and possible arguments to functions.

=GETREALTIME('ETH-USD','LAST_PRICE','COINBASE')Ĭodes 21 and 90 stand for 'last price' and 'close' (see below), respectively.

=GETREALTIME('EURUSD','LAST_PRICE','FT').

Getting data should be as simple as having this in a cell: Please make sure, not to rename the OXT file when downloading and before installing: LO will mess up the installation otherwise and the extension won't work. Under menu item: Tools, Extension Manager. Under 'Releases' on GitHub there is a downloadable Financials-Extension.oxt file - load it into Calc Please provide feedback about using the extension here Usage:

Starting with version 3.1.0, we received a contribution to get crypto data directly from Coinbase Feedback requested: Spreadsheets - currently supporting Yahoo's and Financial Times' finance websites using old-fashioned web scraping.

This is a Python based extension for LibreOffice Calc to make stock market, index and FX data available in Calc Version 3.3.0 includes improved cookie handling and somewhat improved logic to deal with network issues.

Libreoffice calc