Can I get historical crypto prices for tax in Google Sheets?

Yes. =cryptotrackproPrice("BTC","2021-04-14") returns the closing price on that date. Major coins are covered back to around 2013, and thousands of coins for the past year.

Does the sheet know short-term vs long-term gains?

The Tax Report template flags each lot as short-term or long-term based on how long you held it (the 365-day boundary used by many tax systems). Always confirm the exact rules for your country with a tax professional.

How to Calculate Crypto Tax & Cost Basis in Google Sheets

Q: How do I calculate crypto cost basis in Google Sheets?

Enter each purchase (coin, date, quantity). CryptoTrackPro's =cryptotrackproPrice() pulls the historical price on the buy date, and cost basis is quantity × that price. The built-in Tax Report template does this automatically for every lot.

The hardest part of crypto taxes is answering one question for every trade: what was this coin worth on the day I bought it? Digging through old exchange statements is miserable. In Google Sheets you can look it up with a formula — and a built-in template does the whole calculation for you.

The fastest way: the Tax Report template

With the free CryptoTrackPro add-on installed, open your sheet and choose Extensions → CryptoTrackPro → Create Tax Report. You get a ready-made table — just replace the sample rows with your own buys:

You enter: coin, buy date, quantity
It fills in: historical buy price, cost basis, current price, current value, gain/loss ($ and %), days held, and short-term vs long-term

Gains show green, losses show red, and a totals row sums your whole position. Nothing to wire up.

Or build it yourself with two formulas

Prefer to roll your own? The engine is one formula. To get the price of a coin on the day you bought it:

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

Point it at your date cell and multiply by quantity for cost basis:

=cryptotrackproPrice(A2, TEXT(B2,"yyyy-mm-dd")) * C2

Then subtract cost basis from current value (quantity × live price) for your unrealised gain. Major coins are covered back to about 2013; thousands of coins for the past year.

Why do this in a spreadsheet?

You own the data. No uploading your full transaction history to a third-party tax site.
It's auditable. Every number is a visible formula you can check and adjust.
It's free to start. Historical lookups work on the free plan, within the daily limit.
No API key. Nothing to register or configure.

Build your cost-basis sheet in a minute

Install free, then Extensions → CryptoTrackPro → Create Tax Report.

Install CryptoTrackPro free

Note: CryptoTrackPro helps you organise your own figures. It is not tax advice, and tax rules differ by country. Confirm holding-period rules and reporting requirements with a qualified tax professional.

Frequently asked questions

How do I calculate crypto cost basis in Google Sheets?

Cost basis is your buy quantity × the price on the buy date. =cryptotrackproPrice() supplies the historical price; the Tax Report template does the rest automatically.

Can I get historical prices for old trades?

Yes — any coin, any past date. Major coins reach back to ~2013; thousands of coins for the last year.

Does it handle short-term vs long-term?

The template flags each lot using the 365-day boundary. Confirm your country's exact rules with a professional.

Crypto tax & cost basis in Google Sheets