How to get the Ethereum price in Google Sheets

Ethereum holders tend to track more than a dollar price — staking positions, the ETH/BTC ratio, cost basis across many transactions. A spreadsheet handles all of it, once you can pull live prices. Google Sheets can't do that natively, but a free add-on adds a one-word formula.

The live Ethereum price, in one formula

Install the free CryptoTrackPro add-on and type:

=cryptotrackpro("ETH-USD")

Live Ethereum price in dollars. Change the currency freely:

• =cryptotrackpro("ETH-EUR") — Ethereum in euros
• =cryptotrackpro("ETH-GBP") — Ethereum in pounds

The ETH/BTC ratio

Many Ethereum holders watch ETH relative to Bitcoin, not just the dollar price. One formula does it:

=cryptotrackpro("ETH-BTC")

That's how many Bitcoin one Ether is worth — track it over time to see ETH's strength against BTC.

Historical Ethereum prices

For cost basis, tax, or charting around events like the Merge, pull the price on any past date:

=cryptotrackproPrice("ETH","2022-09-15")

Point it at a date column to price every purchase automatically — the basis of a cost-basis and tax tracker.

Track a staking or holdings position

With your ETH amount in A2, current value is one multiplication:

=A2*cryptotrackpro("ETH-USD")

Add rows for each wallet or validator and total them — see the portfolio tracker guide for the full setup.

Frequently asked questions

How do I get the Ethereum price in Google Sheets?

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

Can I get the ETH/BTC ratio?

Yes — =cryptotrackpro("ETH-BTC").

Is it free?

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

See also: how to get the Bitcoin price in Google Sheets →