Market Data as Worksheet Functions

Every series in ALM DataHub is an Excel function. Type =ALM.SONIA("2026-08-24") and the rate is in the cell — no CSV downloads, no copy-paste, no stale numbers.

Excel worksheet with ALM DataHub functions returning live SONIA, gilt yield, Smith-Wilson fit, inflation, PRA spread, and life expectancy values

Live production data — every value on this sheet is one formula.

48 functions, one prefix

Everything lives under ALM.* — lookups, full tables, and discovery helpers that tell you what data exists before you ask for it. This list is generated from the live function registry.

Rates & FX5 functions

ALM.BANKRATE ALM.FX ALM.SONIA ALM.SONIA_INDEX ALM.STERLING_ERI

Yield Curves & Smith-Wilson12 functions

ALM.CURVE_DATES ALM.CURVE_TYPES ALM.GILT ALM.INFLATION ALM.LATEST_CURVE_DATE ALM.OIS ALM.RFR ALM.SW_CURVE ALM.SW_FIT ALM.SW_META ALM.SW_RATE ALM.SW_ZCB

ONS Inflation8 functions

ALM.CPI ALM.CPIH ALM.CPIH_YOY ALM.CPI_YOY ALM.RPI ALM.RPIX ALM.RPIX_YOY ALM.RPI_YOY

ONS Life Tables6 functions

ALM.LIFE_EXPECTANCY ALM.LIFE_PERIODS ALM.LIFE_TABLE ALM.MORTALITY ALM.MORTALITY_TABLE ALM.SURVIVORS

PRA Fundamental Spreads13 functions

ALM.LATEST_PRA_DATE ALM.PRA_COD ALM.PRA_CQS_LABELS ALM.PRA_CURRENCIES ALM.PRA_DATES ALM.PRA_FS ALM.PRA_FS_BREAKDOWN ALM.PRA_LTAS ALM.PRA_PD_PROB ALM.PRA_PD_SPREAD ALM.PRA_SECTORS ALM.PRA_TABLE ALM.PRA_TENORS

Discovery & Meta4 functions

ALM.AVAILABLE_DATES ALM.AVAILABLE_SERIES ALM.LATEST_DATE ALM.SERIES_INFO
ALM DataHub task pane showing the searchable function browser with categories

The task pane documents every function — searchable, with parameters and examples.

Sign in once, then it's just Excel

  1. 1

    Install the add-in

    From Microsoft AppSource, or deployed centrally to your whole team by your IT administrator. Nothing else to install — no local data files, no macros.

  2. 2

    Sign in from the task pane

    One sign-in per device. The add-in holds a personal access token — your password is never stored in a workbook, and tokens can be revoked from your account at any time.

  3. 3

    Use any ALM.* function

    Formulas resolve together — a workbook with thousands of ALM cells refreshes in a handful of requests, not thousands. A ribbon Refresh data button re-pulls everything on demand, and past-dated values are stable by design.

Compatibility

Excel 2016 or later on Windows and Mac, and Excel for the web. Microsoft 365 subscriptions included. Workbooks shared with colleagues keep their last-calculated values even without the add-in installed.

New to ALM DataHub?

Access is by subscription. Tell us about your use case and we'll set your team up — the add-in, the REST API, and the full data catalogue.

Start free trial

Already a customer?

The add-in is coming to Microsoft AppSource. Until the listing is live, sign in and follow the install guide to load it directly.

Install guide Example workbook — every function demonstrated