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.
You can download the current version of the SMF Extension here
The SMF extension can also be found on the LibreOffice Extension Center.
NOTE: The extension itself is SMF.oxt. The example .ods worksheets demonstrate how to use the extension.
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.
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.
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.
- 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