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 python