How to get the Bitcoin price in Google Sheets

Whether you're tracking a stack, dollar-cost-averaging, or working out cost basis for tax, having the Bitcoin price live in your spreadsheet beats refreshing an exchange tab. Google Sheets can't do it out of the box, but a free add-on adds a one-word formula.

The live Bitcoin price, in one formula

Install the free CryptoTrackPro add-on and type:

=cryptotrackpro("BTC-USD")

That's the live Bitcoin price in US dollars. Want another currency? Just change the second half:

• =cryptotrackpro("BTC-EUR") — Bitcoin in euros
• =cryptotrackpro("BTC-GBP") — Bitcoin in pounds
• =cryptotrackpro("BTC-JPY") — Bitcoin in yen

The Bitcoin price on any past date

This is where a spreadsheet really shines. To get Bitcoin's closing price on a specific day — for cost basis, tax, or charting the halvings:

=cryptotrackproPrice("BTC","2021-04-14")

BTC history reaches back to around 2013, so you can look up the price on the day you bought, on a past halving, or at any all-time high. Point it at a date cell to price a whole column of purchases — see the crypto tax & cost basis guide.

Track your stack in sats

If you think in satoshis, one column does it. With your BTC holdings in A2:

• Holdings in sats: =A2*100000000
• USD value: =A2*cryptotrackpro("BTC-USD")

More than the price

The same add-on gives you Bitcoin's 24-hour change, market cap, dominance inputs and technical indicators:

• =cryptotrackproChange("BTC") — 24-hour % change
• =cryptotrackproData("BTC","marketcap") — market cap
• =cryptotrackproRSI("BTC", 14) — RSI (Base & Pro)

Frequently asked questions

How do I get the Bitcoin price in Google Sheets?

Install CryptoTrackPro and type =cryptotrackpro("BTC-USD"). No API key needed.

Can I get the historical Bitcoin price?

Yes — =cryptotrackproPrice("BTC","2021-04-14") for any date back to ~2013.

Is it free?

Yes — 50 lookups a day on the free plan; Base and Pro add more plus auto-refresh.

Next: build a crypto portfolio tracker in Google Sheets →