Thanks to Villeroy from the forums.Choose your operating system: Linux (64-bit) (deb) Linux (64-bit) (rpm) macOS (Apple Silicon) macOS (Intel) Windows (32-bit) Windows (64-bit) DOWNLOAD Torrent, Info 7.2.6 0.6.3 Fix string to float for useful spreadsheet data 4.0 LGPL Fix to convert strings to floats for returned data.0.6.4 Fix for ISO standardized date/time strings 4.0 LGPL This release fixes date/time string formatting to meet ISO standards (thanks to Villeroy for info).Īlso optimizes financial_datacode_map() function (thanks to karolus).Also cleans and restructures Yahoo data elements to remove elements deprecated by Yahoo. **You will need to adjust your GETYAHOO() calls with this update, as Yahoo deprecated many data elements, so datacodes have necessarily changed** 4.0 LGPL Adds a new function, GETMORNINGQFIN() which allows access to Morningstar quarterly financial data. 0.7.0 Adds Morningstar quarterly data and cleans up Yahoo.Corey Goldberg - Inspiration with the Yahoo portion of the extension.karolus - optimization of keymapping code.Villeroy - conversion from string to float to make the extension useful.You must include or make available the source code with your release.You must track changes you make in the source files.You may use the material for commercial purposes as long as the derivative is licenced under the GPL.You may adapt, remix, transform and build upon the material, releasing any derivatives under your own name.You are permitted to use, copy and redistribute the work 'as-is'.

The SMF Extension is released under the which in layman's terms means: Details on that process can be found here. 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. Supportįor 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. ods worksheets included with the release. NOTE: The full set of datacodes are demonstrated in the example.

In the latter case the data in A1 should be AAPL, not 'AAPL'. Quotes must be used when entering the ticker directly ex: GETYAHOO('AAPL',1), but are not needed when referencing another cell ex: GETYAHOO(A1,1). The SMF Extension adds four new functions to Calc: ods worksheets demonstrate how to use the extension. You will need to update calls to GETYAHOO() in existing spreadsheets with this version since Yahoo deprecated elements, so datacodes necessarily changed.

You can download the current version of the SMF extension here Currently supported online sources include Morningstar and Yahoo Finance. The SMF extension allows you to create customized spreadsheets with stock market data directly from the web. HTML Editor - Full Version Stock Market Functions

Libreoffice calc download