LibreOffice Logo LibreOffice Logo Extensions, Documentation and Templates repository

smf extension SMF Extension for LibreOffice Calc

.

★ ☆ ☆ ☆ ☆
Calc Extensions
Download latest

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

Homepage: https://github.com/madsailor/SMF-Extension

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
Show more

Feedback

★ ☆ ☆ ☆ ☆

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

RSS feed for reviews on this page | RSS feed for all reviews