SMF Extension for LibreOffice Calc
.
latest release: 2023-11-04 02:05:24
Description
HTML Editor - Full Version
Stock Market Functions
The SMF extension allows you to create customized spreadsheets with stock market data directly from the web. Currently supported online sources include Morningstar and Yahoo Finance.
Download
You can download the current version of the SMF extension here
WARNING: This extension is discontinued. A fork can be found there.
You will need to update calls to GETYAHOO() in existing spreadsheets with this version since Yahoo deprecated elements, so datacodes necessarily changed.
NOTE: The extension itself is SMF.oxt. The example .ods worksheets demonstrate how to use the extension.
Usage
The SMF Extension adds four new functions to Calc:
GETYAHOO(Ticker,Datacode)
GETMORNINGKEY(Ticker,Datacode)
GETMORNINGFIN(Ticker,Datacode)
GETMORNINGQFIN(Ticker,Datacode)
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)
.
In the latter case the data in A1 should be AAPL
, not "AAPL"
.
NOTE: The full set of datacodes are demonstrated in the example .ods worksheets included with the release.
Support
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.
Contribute
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.
License
The SMF 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!
- Villeroy - conversion from string to float to make the extension useful
- karolus - optimization of keymapping code
- Corey Goldberg - Inspiration with the Yahoo portion of the extension
Additional documentation: https://github.com/madsailor/SMF-Extension/wiki
Release | Description | Compatibility | Operating Systems | License | Release notes | Updated | |
---|---|---|---|---|---|---|---|
0.7.0 | Adds Morningstar quarterly data and cleans up 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. Also cleans and restructures Yahoo data elements to remove elements deprecated by Yahoo. | 2020-03-05 23:11:42 | Download | |
0.7.0 | Adds Morningstar quarterly data and cleans up 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. Also cleans and restructures Yahoo data elements to remove elements deprecated by Yahoo. | 2020-03-05 23:11:41 | Download | |
0.7.0 | Adds Morningstar quarterly data and cleans up 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. Also cleans and restructures Yahoo data elements to remove elements deprecated by Yahoo. | 2020-03-05 23:11:41 | Download | |
0.7.0 | Adds Morningstar quarterly data and cleans up 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. Also cleans and restructures Yahoo data elements to remove elements deprecated by Yahoo. | 2020-03-05 23:11:41 | Download | |
0.6.3 | Fix string to float for useful spreadsheet data | 4.0 | LGPL | Fix to convert strings to floats for returned data. Thanks to Villeroy from the forums. | 2020-03-05 23:11:40 | Download | |
0.7.0 | Adds Morningstar quarterly data and cleans up 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. Also cleans and restructures Yahoo data elements to remove elements deprecated by Yahoo. | 2020-03-05 23:11:40 | Download | |
0.6.3 | Fix string to float for useful spreadsheet data | 4.0 | LGPL | Fix to convert strings to floats for returned data. Thanks to Villeroy from the forums. | 2020-03-05 23:11:39 | Download | |
0.6.3 | Fix string to float for useful spreadsheet data | 4.0 | LGPL | Fix to convert strings to floats for returned data. Thanks to Villeroy from the forums. | 2020-03-05 23:11:39 | Download | |
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). Also optimizes financial_datacode_map() function (thanks to karolus). |
2020-03-05 23:11:38 | Download | |
0.6.3 | Fix string to float for useful spreadsheet data | 4.0 | LGPL | Fix to convert strings to floats for returned data. Thanks to Villeroy from the forums. | 2020-03-05 23:11:38 | Download | |
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). Also optimizes financial_datacode_map() function (thanks to karolus). |
2020-03-05 23:11:37 | Download | |
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). Also optimizes financial_datacode_map() function (thanks to karolus). |
2020-03-05 23:11:37 | Download | |
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). Also optimizes financial_datacode_map() function (thanks to karolus). |
2020-03-05 23:11:37 | Download |
★ ☆ ☆ ☆ ☆
Post your review
You cannot post reviews until you have logged in. Login Here.
Reviews
Eike Rathke Feb 1, 2021, 4:53 PM (4 years ago)
★ ☆ ☆ ☆ ☆
Completely outdated. Maybe some of the functionality of the fork still works, the Yahoo API is dead anyway,
https://github.com/dhocker/SMF-Extension
Igoracutt Sep 16, 2020, 11:08 AM (4 years ago)
☆ ☆ ☆ ☆ ☆
variant3
No one has commented on this page yet.
RSS feed for reviews on this page | RSS feed for all reviews