Docs/Sources/Live Bitcoin Price

Live Bitcoin Price

Get Current Bitcoin Price

OperationalCredits 2 per callp50 210msFinance

Overview

A Bitcoin API for apps that need the BTC price as JSON. Bitcoin Price works by fetching the latest market data for Bitcoin from multiple reliable sources. It returns the current price and its movement direction; paid plans add market capitalization, 24-hour trading volume, 24-hour percentage change, and quotes in any supported currency. Paid plans also get 1-hour, 7-day, 30-day and 1-year changes, market-cap rank, circulating and maximum supply, fully diluted valuation, and the all-time high and low with their dates and the distance from the high. The data is refreshed hourly. The last 30 daily closes are stored too: paid plans get the 30-day high, low, average and volatility, and daily=true returns the closes themselves, each converted at that day's exchange rate.

Live Test Live Bitcoin 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("bitcoin", "price")

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, market cap and volume for the last 30 days

Passing an option

=VERVE("bitcoin", "price", "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("bitcoin")
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
pricenumber80621Current Bitcoin price in specified currency
marketCapPremiumnumber1620852883292Total market capitalization in specified currency
volume24hPremiumnumber2345384727924-hour trading volume in specified currency
change24hPremiumnumber0.52Percentage price change over the last 24 hours
currencystringUSDCurrency code in which price is quoted
lastUpdatedstring2026-10-27T17:41:09.843ZISO 8601 timestamp of the last price update
high24hPremiumnumber80621Highest price in the last 24 hours
low24hPremiumnumber79416Lowest price in the last 24 hours
changeAmount24hPremiumnumber417.2Price change over the last 24 hours in the requested currency; null when unavailable
change1hPremiumnumber0.07Percentage price change over the last hour; null when unavailable
change7dPremiumnumber-2.45Percentage price change over the last 7 days; null when unavailable
change30dPremiumnumber-4.65Percentage price change over the last 30 days; null when unavailable
change1yPremiumnumber-29.97Percentage price change over the last year; null when unavailable
marketCapRankPremiumnumber1Bitcoin's rank among all cryptocurrencies by market capitalization; null when unavailable
circulatingSupplyPremiumnumber20104350Bitcoin currently in circulation; null when unavailable
totalSupplyPremiumnumber20104409Total Bitcoin supply in existence; null when unavailable
maxSupplyPremiumnumber21000000Maximum Bitcoin that will ever exist (21 million); null when unavailable
fullyDilutedValuationPremiumnumber1620857639990Market capitalization if the maximum (or total) supply were in circulation, in the requested currency; null when unavailable
allTimeHighPremiumnumber126080All-time high price in the requested currency; null when unavailable
allTimeHighDatePremiumstring2025-10-06T10:57:42.000ZISO 8601 date of the all-time high; null when unavailable
percentFromAllTimeHighPremiumnumber-36.06How far the current price is below (negative) the all-time high, in percent; null when unavailable
allTimeLowPremiumnumber67.81All-time low price in the requested currency; null when unavailable
allTimeLowDatePremiumstring2013-07-05T16:00:00.000ZISO 8601 date of the all-time low; null when unavailable
high30dPremiumnumber86489.73Highest daily close over the last 30 days, in the requested currency; null until two days are stored
low30dPremiumnumber80029.43Lowest daily close over the last 30 days, in the requested currency; null until two days are stored
average30dPremiumnumber82773.02Mean daily close over the last 30 days, in the requested currency; null until two days are stored
volatility30dPremiumnumber1.3193Standard deviation of the daily percent changes over the last 30 days (not annualized); null until two days are stored
dailyPremiumarray[30]Bitcoin's daily closes 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.pricePremiumnumber83479.25Closing price, converted at that day's exchange rate
daily.0.marketCapPremiumnumber1677138373123.67Market capitalization at the close; null when unavailable
daily.0.volume24hPremiumnumber41541721154.8624-hour trading volume at the close; null when unavailable
changeDirectionstringupPrice movement direction: up, down, or unchanged
formattedobject{…}Price, market cap and volume as human-readable strings
formatted.pricePremiumstring$80,621.00Formatted price with currency symbol and thousands separator
formatted.marketCapPremiumstring$1.62TFormatted market cap in human-readable units (T, B, M)
formatted.volumePremiumstring$23.45BFormatted 24-hour volume in human-readable units
formatted.priceWordsPremiumstringeighty thousand, six hundred twenty-one dollarsPrice written out in English words for accessibility

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 bitcoinAn 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

Crypto Wallet Balances
Multi-currency wallets convert satoshi balances into current fiat valuations using real-time price quotes and update timestamps.
Checkout Invoice Settlement
To calculate exact payment totals, merchant gateways lock in fiat-to-BTC amounts based on the latest price quote before generating payment QR codes.
Trading Terminal Indicators
When market trends shift, charting dashboards update visual ticker arrows directly from price movement direction indicators.
Accounting Ledger Conversions
Reconcile treasury holdings by attaching the exact timestamped Bitcoin valuation to every balance sheet entry at the close of business.

Other ways to use Live Bitcoin Price

Set up Live Bitcoin 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 Ethereum PriceGet Current Ethereum PriceLive Gold PriceGet Current Gold PriceLive Palladium PriceGet Current Palladium PriceLive Platinum PriceGet Current Platinum PriceLive Silver PriceGet Current Silver PriceMarket Open TimesGet stock market open times
Was this page helpful?