Docs/Sources/Live Gold Price

Live Gold Price

Get Current Gold Price

OperationalCredits 2 per callp50 224msFinance

Overview

A gold price API with a free plan, for apps and stores that show the live gold spot price. The Free plan returns the USD spot price per ounce, gram and kilogram with the 24-hour change. Requests retrieve real-time spot gold valuations denominated in USD across ounce, gram, and kilogram weights, accompanied by 24-hour change values and price direction. Paid tiers can query prices across 172 currency codes, retrieve 24-hour high and low ranges, and include hourly price snapshots spanning the preceding day. The last 30 daily closes are stored too: paid plans get the 7- and 30-day change and the 30-day high, low, average and volatility, and daily=true returns the closes themselves.

Live Test Live Gold 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("goldprice", "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("goldprice", "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("goldprice")
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
gramnumber129.25Gold price per gram in specified currency
kilogramnumber129251.92Gold price per kilogram in specified currency
ouncenumber4020.19Gold price per troy ounce in specified currency
lastUpdatedstring2026-10-27T12:00:00.000ZISO 8601 timestamp of last price update
change24hnumber11.88Price change vs 24 hours ago in currency units
change24hPctPremiumnumber0.3Percentage price change vs 24 hours ago
changeDirectionstringupDirection of 24h change: up, down, or unchanged
high24hPremiumnumber4020.19Highest price in the past 24 hours
low24hPremiumnumber4008.31Lowest price in the past 24 hours
change7dPremiumnumber-102.49Change in the ounce price over the last 7 days, in the requested currency; null until a close from then is stored
change7dPctPremiumnumber-2.49Percent change in the ounce price over the last 7 days; null until a close from then is stored
change30dPremiumnumber-265.95Change in the ounce price over the last 30 days, in the requested currency; null until a close from then is stored
change30dPctPremiumnumber-6.2Percent change in the ounce price over the last 30 days; null until a close from then is stored
high30dPremiumnumber4198.91Highest daily close per ounce over the last 30 days, in the requested currency; null until two days are stored
low30dPremiumnumber3993.62Lowest daily close per ounce over the last 30 days, in the requested currency; null until two days are stored
average30dPremiumnumber4132.9Mean daily close per ounce over the last 30 days, in the requested currency; null until two days are stored
volatility30dPremiumnumber0.7777Standard deviation of the daily percent changes over the last 30 days (not annualized); null until two days are stored
dailyPremiumarray[30]Gold'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.pricePremiumnumber4198.34Closing 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
karatGramPremiumobject{…}Gold value per gram by karat in the requested currency, at the purity fraction (karat / 24) of the spot gram price
karatGram.24kPremiumnumber129.25Price per gram of 24-karat gold (pure, equal to gram)
karatGram.22kPremiumnumber118.48Price per gram of 22-karat gold (91.7%)
karatGram.21kPremiumnumber113.09Price per gram of 21-karat gold (87.5%)
karatGram.18kPremiumnumber96.94Price per gram of 18-karat gold (75%)
karatGram.14kPremiumnumber75.4Price per gram of 14-karat gold (58.3%)
karatGram.10kPremiumnumber53.85Price per gram of 10-karat gold (41.7%)
formattedobject{…}
formatted.ouncePremiumstring$4,020.19Formatted ounce price with currency symbol
formatted.gramPremiumstring$129.25Formatted gram price with currency symbol
formatted.kilogramPremiumstring$129,251.92Formatted kilogram price with currency symbol
formatted.ounceWordsPremiumstringfour thousand, twenty dollarsOunce price spelled out in words with currency
formatted.kilogramWordsPremiumstringone hundred twenty-nine thousand, two hundred fifty-two 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 goldpriceAn 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

Jewelry Store Pricing
E-commerce jewelers adjust retail bullion and custom jewelry checkout prices dynamically based on live gold rates per gram.
Portfolio Asset Valuation
Wealth tracking dashboards recalculate physical precious metal portfolio balances by multiplying recorded gold ounces against incoming spot rates.
Pawn Shop Appraisals
When customers bring in scrap scrap gold, collateral loan software pulls the latest kilogram and gram benchmarks to calculate fair lending values.
Trading Alert Triggers
Market watch bots monitor 24-hour change direction and absolute price shifts to push notifications when bullion moves significantly.

Other ways to use Live Gold Price

Set up Live Gold 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:

Live Palladium PriceGet Current Palladium PriceLive Platinum PriceGet Current Platinum PriceLive Silver PriceGet Current Silver PriceMarket Open TimesGet stock market open timesMinimum WageFederal and State Minimum Wage RatesMortgage RatesGet US Fixed-Rate Mortgage Rates
Was this page helpful?