Skip to content

v1.0.5 — FRED LibreOffice Calc Add-In

Choose a tag to compare

@davidjayjackson davidjayjackson released this 07 Jul 22:30

Maintenance release. Same functionality as v1.0.0–v1.0.4; regenerates the
demo spreadsheet against the previous release.

Changes since v1.0.4

  • Regenerated test/fred_demo.ods against the published v1.0.4 release
    asset (installed via unopkg) to confirm it still works end-to-end.
  • Extension package version bumped to 1.0.5.

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 (covers Linux/macOS too). Full history in CHANGELOG.md.

License

MIT.