Repo: https://github.com/qalydon/qf-localc

This project implements a LibreOffice Calc (LOCalc) addin extension that can retrieve stock market data from various free sources. Currently, most of the available data is historical. This is a good extension for getting historical OHLC (open, high, low, close) data.

There is no support for anything real-time or quasi-real-time.

The intent here is to provide a set of abstract functions that are independent of the underlying data source(s). Previous LOCalc extensions I have written are dependent on a specific data source (e.g. Intrinio or IEX). When The data sources change, the extension functions are frequently impacted and thus, any using spreadsheet is impacted. Some of the extension functions are actually modeled on the data source’s API. And, worse yet, the T’s and C’s of the data source can change making the data no longer freely available.

An example will serve to illustrate this point about abstraction. The first function to be implemented in this extension was QFClosingPrice. That function can be implemented using any data source that can provide a ticker symbols’s closing price for a given date. There’s nothing in the function name or its parameters (a ticker symbol, category and date) that indicates the actual source. If the initial implementation of QFClosingPrice uses data source A and this source subsequently changes, the implementation of QFClosingPrice can be changed to use data source B without changing any using spreadsheet. Of course this depends on both data sources A and B supporting a historical closing price.