Track the spot price of palladium from a cell. =VERVE("palladiumprice", …) returns live prices in any currency and unit, auto-refreshing — Sheets or Excel.
It's one of 250+ 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 — the input you type, and the values you can pull from it. Click any cell to see the formula behind it.
Drop =VERVE("palladiumprice") 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("palladiumprice") 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("palladiumprice")Same source, same arguments, same key — in Excel on desktop, the web, or mobile. Excel namespaces it as VERVE.CALL. Drag to fill a whole column.
=VERVE.CALL("palladiumprice")Tune the result by adding name=value before the field argument — in any order. Leave one out and its default applies.
The currency to get the price in
=VERVE("palladiumprice", "currency", "USD")Include hourly price data for the past 24 hours
=VERVE("palladiumprice", "hourly", "true")Add a field name as the last argument to land just that value in the cell.
=VERVE("palladiumprice", "field", "currency")=VERVE("palladiumprice", "field", "gram")=VERVE("palladiumprice", "field", "kilogram")=VERVE("palladiumprice", "field", "ounce")=VERVE("palladiumprice", "field", "lastUpdated")=VERVE("palladiumprice", "field", "change24h")=VERVE("palladiumprice", "field", "change24hPct")=VERVE("palladiumprice", "field", "changeDirection")=VERVE("palladiumprice", "field", "high24h")=VERVE("palladiumprice", "field", "low24h")=VERVE("palladiumprice", "field", "hourly")=VERVE("palladiumprice", "field", "formatted.ounce")Premium marks data included on paid plans. On the Free plan a marked field is withheld and a marked input is ignored — either way the cell reads #PREMIUM(name) instead of a value, so a gated answer can never be mistaken for a real one. Everything unmarked works on every plan. Compare plans
Everything you need to wire it into a sheet.