Docs/Sources/Live Palladium Price

Live Palladium Price

Get Current Palladium Price

OperationalCredits 2 per callp50 297msFinance

Overview

A collector reads the palladium spot price from public bullion price sources every hour, trying each in turn and falling back when one fails. It stores the price per troy ounce, gram and kilogram (31.1035 grams to the ounce), a 24-slot ring of hourly snapshots and one closing price per day for the last 30 days.

`change24h` compares the current ounce price with a snapshot taken between 21 and 25 hours earlier, picking the one closest to 24 hours; if none exists the change fields are omitted. `high24h` and `low24h` span all snapshots from the last 25 hours, so older slots that a failed refresh left behind are ignored. `hourly=true` returns those snapshots sorted by time, each tagged with the UTC `hour` slot it was captured in.

`currency` (paid) converts with the stored exchange rates, and an unknown code returns a 400. Daily closes in the 30-day history are converted at each day's own exchange rate where one is stored. `change7d` and `change30d` are null until a close from that far back exists; `volatility30d` is the standard deviation of daily percent changes, not annualized.

`marketStatus` follows regular spot hours, Sunday 18:00 to Friday 17:00 New York time with a daily 17:00 to 18:00 break, and does not model exchange holidays. In the `formatted` block, `ounceWords` and `kilogramWords` spell the rounded price out in words.

Live Test Live Palladium Price Source →

Formula

One function covers the whole catalog: the first argument names the source, the next are its inputs, and the field after them says which single value lands in the cell. Formulas covers the grammar that applies to all of them.

=VERVE("palladiumprice", "gram")

Inputs

Required inputs are positional, in the order below, followed by the field. Everything else is passed as a "name", value pair after that — the same shape as SUMIFS. Premium inputs are accepted on every plan but only take effect on plans that include them.

InputTypeWhere it goesDescription
currencyOptionalPremiumstring"currency", valueThe currency to get the price in
default USD
hourlyOptionalPremiumboolean"hourly", valueInclude hourly price data for the past 24 hours
dailyOptionalPremiumboolean"daily", valueInclude the daily closing price per ounce for the last 30 days

Passing an option

=VERVE("palladiumprice", "gram", "currency", "USD")

What lands in your sheet

The field — the argument after the inputs — is what makes the formula resolve to one cell. Its value is a dot-path from the table below, so swapping it is how you pull a different value — one formula per column.

Seeing everything at once

Leave the field out and the formula returns the whole response instead: two columns, field name on the left and value on the right, spilling from the cell you typed in.

=VERVE("palladiumprice")
Good for exploring, not for filling down

The second row's table would land on top of the first's, and every cell after the first reads #REF! (#SPILL! in Excel). Keep one per sheet, or name a field, and leave the cells below and to the right empty.

Response fields

Paths are relative to data. Each one is exactly what the field argument accepts, so swapping it is how you pull a different value into a cell. On a plan without a Premium field the cell reads #PREMIUM(field) rather than a value, so a locked field never looks like a real answer.

Use as the fieldTypeExample cell valueDescription
currencystringUSDISO 4217 currency code for price values
gramnumber33.47Palladium price per gram in specified currency
kilogramnumber33466.63Palladium price per kilogram in specified currency
ouncenumber1040.93Palladium price per troy ounce in specified currency
lastUpdatedstring2026-10-27T12:00:00.000ZISO 8601 timestamp of last price update
change24hnumber-11.29Price change vs 24 hours ago in currency units
change24hPctPremiumnumber-1.07Percentage price change vs 24 hours ago
changeDirectionstringdownDirection of 24h change: up, down, or unchanged
high24hPremiumnumber1052.22Highest price in the past 24 hours
low24hPremiumnumber1040.93Lowest price in the past 24 hours
change7dPremiumnumber-63.98Change in the ounce price over the last 7 days, in the requested currency; null until a close from then is stored
change7dPctPremiumnumber-5.79Percent change in the ounce price over the last 7 days; null until a close from then is stored
change30dPremiumnumber-229.07Change in the ounce price over the last 30 days, in the requested currency; null until a close from then is stored
change30dPctPremiumnumber-18.04Percent change in the ounce price over the last 30 days; null until a close from then is stored
high30dPremiumnumber1235.1Highest daily close per ounce over the last 30 days, in the requested currency; null until two days are stored
low30dPremiumnumber1040.93Lowest daily close per ounce over the last 30 days, in the requested currency; null until two days are stored
average30dPremiumnumber1135.83Mean daily close per ounce over the last 30 days, in the requested currency; null until two days are stored
volatility30dPremiumnumber1.4294Standard deviation of the daily percent changes over the last 30 days (not annualized); null until two days are stored
dailyPremiumarray[30]Palladium's daily closes per ounce for the last 30 days, oldest first (when daily=true). Today's row is the latest price
daily.0.datePremiumstring2026-09-28UTC date of the close (YYYY-MM-DD)
daily.0.pricePremiumnumber1235.1Closing price per ounce, converted at that day's exchange rate
marketStatusstringopenopen or closed by regular spot trading hours (Sunday 18:00 to Friday 17:00 New York time, daily 17:00-18:00 break); exchange holidays are not reflected
formattedobject{…}Prices formatted for display with the currency symbol and in words
formatted.ouncePremiumstring$1,040.93Formatted ounce price with currency symbol
formatted.gramPremiumstring$33.47Formatted gram price with currency symbol
formatted.kilogramPremiumstring$33,466.63Formatted kilogram price with currency symbol
formatted.ounceWordsPremiumstringone thousand, forty-one dollarsOunce price spelled out in words with currency
formatted.kilogramWordsPremiumstringthirty-three thousand, four hundred sixty-seven dollarsKilogram price spelled out in words with currency

When a cell doesn't fill

A failed lookup returns readable text starting with #ERR rather than a spreadsheet error, because Excel cannot show a custom message on a real error — you would get a bare #VALUE! with no reason. The trade-off is that IFERROR() will not catch it; test with LEFT(cell, 4) = "#ERR" instead. Error handling covers the rest.

Cell readsWhat happened
#ERR Not connectedNo API key saved. Open the side panel and connect your account.
#ERR Replace <name> with a cell or valueA preview formula was copied as-is. Swap the placeholder for a cell reference.
#ERR No "x" in palladiumpriceAn option name this source does not take. The message lists the ones it does.
#ERR No data point "…"The field path is not in the response. Check it against the table above.
#PREMIUM(field)The field exists but your plan does not include it.
#ERR Out of creditsThe cycle's credits are spent. Usage resets on your billing date.

Before the formula works

The add-in reads the API key you saved once in the side panel — the key never goes in the formula, so a shared sheet does not leak it and a collaborator without access simply sees the last calculated values.

  1. Install the add-in for Google Sheets or Excel.
  2. Open the side panel and sign in, or paste a key from your dashboard.
  3. Type the formula above into any cell.

Supported Currencies

170+ world currencies supported including fiat currencies, cryptocurrencies, and precious metals.

CodeCurrencyRegion
AEDUAE DirhamUnited Arab Emirates
AFNAfghan AfghaniAfghanistan
ALLAlbanian LekAlbania
AMDArmenian DramArmenia
ANGNetherlands Antillean GuilderCuraçao
AOAAngolan KwanzaAngola
ARSArgentine PesoArgentina
AUDAustralian DollarAustralia
AWGAruban FlorinAruba
AZNAzerbaijani ManatAzerbaijan
BAMBosnia-Herzegovina Convertible MarkBosnia and Herzegovina
BBDBarbadian DollarBarbados

Use cases

Scrap Converter Pricing
To calculate fair scrap payouts, auto recyclers pull real-time per-gram palladium rates before bidding on spent catalytic converters.
Bullion Dealer Dashboards
Precious metals brokerages update retail storefronts with live spot prices per troy ounce and display 24-hour change directions.
Industrial Procurement Alerts
When ordering raw alloy stock, manufacturing supply software flags price swings by comparing current spot rates against 24-hour changes.
Jewelry Asset Accounting
Calculate the market value of workshop inventory by multiplying recorded palladium weights in grams against incoming price feeds.

Other ways to use Live Palladium Price

Set up Live Palladium Price on VerveSheets, or reach the same source a different way. Your VerveSheets account and credits work on all of them — one key, one balance.

Call it as a REST APIOne HTTPS endpoint and an x-api-key header, with SDKs for Node, Python and .NET.APIVerve →Reference →
Give it to an AI agentConnect over MCP and your agent calls it as a native tool — Claude, Cursor, ChatGPT.VerveKit →Reference →
Ground an agent on itA cited, machine-checkable fact your model can't produce on its own.VerveContext →Reference →

More in Finance:

Was this page helpful?