SMF Extension for LibreOffice Calc

1 0

.

Project 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

Category/Categories

Calc Extension

Homepage of the Project

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

Logo

Current Release

No stable release available yet.

All Releases

Version

Released

Platform(s)

Compatibility

Description

License(s)

Status

0.7.0

Mar 14, 2015
    • LibreOffice 4.0
    • LibreOffice 4.1
    • LibreOffice 4.2
    • LibreOffice 4.3
    • LibreOffice 4.4
    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**
    • LGPL-v3+ (GNU Lesser General Public License Version 3 and later)
    release-candidate

    0.6.4

    Feb 22, 2015
      • LibreOffice 4.0
      • LibreOffice 4.1
      • LibreOffice 4.2
      • LibreOffice 4.3
      • LibreOffice 4.4
      Fix for ISO standardized date/time strings
      • LGPL-v3+ (GNU Lesser General Public License Version 3 and later)
      release-candidate

      0.6.3

      Feb 21, 2015
        • LibreOffice 4.0
        • LibreOffice 4.1
        • LibreOffice 4.2
        • LibreOffice 4.3
        • LibreOffice 4.4
        Fix string to float for useful spreadsheet data
        • LGPL-v3+ (GNU Lesser General Public License Version 3 and later)
        release-candidate

        Legal Disclaimer and Limitations for Downloads

        The Document Foundation has not reviewed, and cannot review, all of the material, including computer software, available on or by means of The Document Foundation's
        websites, and cannot therefore be responsible for that material's content, use or effects. By operating its websites, The Document Foundation does not represent or imply that it endorses the material there available, or that it believes such material to be accurate, useful or nonharmful. You are responsible for taking precautions as necessary to protect yourself and your computer systems from viruses, worms, Trojan horses and other harmful or destructive content. The Document Foundation's websites may contain content that is offensive, indecent or otherwise objectionable, as well as content containing technical inaccuracies, typographical mistakes and other errors. The Document Foundation's websites may also contain material that violates the privacy or publicity rights, or infringes the proprietary rights, of third parties, or the downloading, copying or use of which is subject to additional terms and conditions, stated or unstated. The Document Foundation disclaims any responsibility for any harm resulting from the use by The Document Foundation's visitors of The Document Foundation's websites, or from any downloading by those visitors of content available on or by means of The Document Foundation's websites.

        Changes

        Content contained on The Document Foundation's websites, including these Legal Disclaimers and Limitations, may be changed at the sole discretion of The Document Foundation and without notice. You are bound by any such updates or changes, and so should periodically review these Legal Disclaimers and Limitations.

        If you believe any file is present on the site contrary to any TDF rule or applicable law, please supply full details to info@documentfoundation.org for impartial consideration.