Skip to content

v1.0.3 — FRED LibreOffice Calc Add-In

Choose a tag to compare

@davidjayjackson davidjayjackson released this 07 Jul 22:13

Maintenance release. Same functionality as v1.0.0–v1.0.2; adds a Linux/macOS
build path and fixes broken release links.

Changes since v1.0.2

  • Added build.sh, a POSIX shell port of build.ps1 for building FRED.oxt
    on Linux/macOS (resolves LibreOffice/JDK from --libreoffice/--jdk flags
    or LO_HOME/JAVA_HOME).
  • Fixed release links in the README and CHANGELOG that pointed at the old
    repo name java_federal_reserve- (trailing hyphen).
  • Extension package version bumped to 1.0.3.

No functional changes to the add-in.

Functions

Function Purpose
FRED_SERIES(id; [start]; [end]; [api_key]; [headers]) Observations as a spillable (date, value) array. Accepts date cells; optional header row.
FRED_DESCRIPTION(id; [api_key]) Series title.
FRED_META(id; field; [api_key]) A single metadata field.
FRED_FIELDS(id; [api_key]; [headers]) Lists a series' metadata fields — the valid FRED_META field names.
FRED_LATEST(id; [api_key]) Most recent non-missing observation.

Every function takes an optional trailing api_key; when omitted it falls back to the FRED_API_KEY environment variable.

Install

Download FRED.oxt below and install it:

unopkg add --force FRED.oxt

Then set FRED_API_KEY (or pass a key per formula). See docs/INSTALL.md for details. Full history in CHANGELOG.md.

License

MIT.