Pull inflation by the row. =VERVE("inflation", "US", 2023) returns annual inflation and CPI per country — Sheets or Excel, auto-refreshing.
It's one of 300+ live sources you reach with a single =VERVE()function — served from APIVerve's production data engine, billed at 1 credit per resolved cell, and refreshed on whatever cadence you set. No API keys to wrangle, no scripts, no exports.
A real example — these inputs, and the values they land in your sheet.
Drop =VERVE("inflation", "US", 2023) into a cell and your model reads the latest number every refresh — no more pasting figures from a browser tab into a stale sheet.
Fill a column beside your list of tickers or currencies and every row updates together, so a hundred-row watchlist stays current on its own.
Point a chart at the cell =VERVE("inflation", "US", 2023) feeds and the chart re-draws as the data moves — a finance dashboard that's live instead of a Monday-morning snapshot.
The same function works in both apps — install once, sign in with your key, and type it into any cell.
Install from the Workspace Marketplace, then drop the formula into a cell. Autocomplete suggests the source and its fields.
=VERVE("inflation", "US", 2023)Same function, same arguments, same key — in Excel on desktop, the web, or mobile. Drag to fill a whole column.
=VERVE("inflation", "US", 2023)Add a field name as the last argument to land just that value in the cell.
=VERVE("inflation", "US", 2023, "country")=VERVE("inflation", "US", 2023, "countryName")=VERVE("inflation", "US", 2023, "year")=VERVE("inflation", "US", 2023, "inflationRate")=VERVE("inflation", "US", 2023, "cpiIndex")=VERVE("inflation", "US", 2023, "cpiBaseYear")=VERVE("inflation", "US", 2023, "lastUpdated")Everything you need to wire it into a sheet.