Track Ethereum Price in Google Sheets (2026)

Get the Live ETH Price in One Formula

=CT_PRICE("ETH")

That formula returns the current Ethereum price in USD. Paste it into any Google Sheets cell and you'll see a live number within seconds.

CoinTable, a Google Sheets add-on for cryptocurrency prices, makes this work. Install it from the Google Workspace Marketplace — no API key, no configuration. For the full setup guide covering multiple coins, see how to get crypto prices in Google Sheets.

All ETH Formulas

Here's every data point CoinTable provides for Ethereum:

Every formula updates automatically when you open the sheet or trigger a recalculation. On CoinTable's Plus plan, data auto-refreshes on a schedule.

GOOGLEFINANCE Alternative (and Why It Falls Short)

Google Sheets has a built-in option:

=GOOGLEFINANCE("ETHUSD")

This works — it returns an ETH price. But it has real limitations:

GOOGLEFINANCE("ETHUSD") gives you a single delayed number. CoinTable gives you a full data set. If you only need a rough ETH price and nothing else, GOOGLEFINANCE works. For anything more, CoinTable is the better tool.

For a deeper comparison covering all the limitations, see track Bitcoin price in Google Sheets — the same GOOGLEFINANCE constraints apply to ETH.

Build an ETH Dashboard

Set up a dedicated Ethereum monitoring dashboard in one sheet. Here's the layout:

Dashboard Header

Place these in cells A1:B8 for a quick-reference panel:

A1: Metric              B1: Value
A2: Price (USD)         B2: =CT_PRICE("ETH")
A3: Price (EUR)         B3: =CT_PRICE("ETH", "EUR")
A4: 24h Change          B4: =CT_CHANGE("ETH")
A5: Market Cap          B5: =CT_MARKETCAP("ETH")
A6: 24h Volume          B6: =CT_VOLUME("ETH")
A7: Rank                B7: =CT_RANK("ETH")
A8: All-Time High       B8: =CT_ATH("ETH")
A9: % Below ATH         B9: =1 - CT_PRICE("ETH") / CT_ATH("ETH")
A10: 24h High           B10: =CT_HIGH("ETH")
A11: 24h Low            B11: =CT_LOW("ETH")
A12: 24h Range          B12: =CT_HIGH("ETH") - CT_LOW("ETH")
A13: Circulating Supply B13: =CT_SUPPLY("ETH")

Format B5 and B6 with custom number format $#,##0,,,"T" or $#,##0,,"B" to display market cap in trillions/billions.

ETH Holdings Tracker

Below the dashboard header, track your actual ETH positions:

Why Track ETH Across Sources?

Ethereum sits in more places than most assets. You might hold ETH in a hardware wallet, on an exchange, staked in a validator (or liquid staking like Lido), and deployed in DeFi protocols. A spreadsheet is the one place you can see the aggregate picture.

Staked ETH is particularly worth tracking. If you're running a validator with 32 ETH, you want to know the USD value of your staked position alongside the rewards it generates. Add a "Staking Rewards" column that you update periodically with the ETH earned.

ETH Price Alerts With Conditional Formatting

Alert When ETH Crosses a Price Target

1. Put your target price in a cell, e.g., D1: 4000
2. Select the cell with =CT_PRICE("ETH")
3. Format → Conditional formatting
4. Custom formula: =B2 >= $D$1
5. Set green background with bold text
6. Add a second rule: =B2 < $D$1 * 0.9 → red background (more than 10% below target)

Alert on Large Daily Swings

1. Select the 24h change cell
2. Rule 1: Custom formula =B4 > 5 → green (up more than 5%)
3. Rule 2: Custom formula =B4 < -5 → red (down more than 5%)

ETH-Specific Context for Your Sheet

Gas Fees

Ethereum gas fees fluctuate and affect the real cost of transactions. While CoinTable doesn't provide gas data directly, you can add a manual "Last Gas" column to your dashboard where you note the current gwei from a site like Etherscan. This helps you decide when to move ETH between wallets.

ETH Supply After The Merge

Since Ethereum's transition to Proof of Stake (The Merge, September 2022), ETH supply dynamics changed fundamentally. New issuance dropped ~90%, and EIP-1559 burns a portion of every transaction fee. Use =CT_SUPPLY("ETH") to watch the circulating supply — during high-activity periods, ETH can actually be deflationary (more burned than issued).

Track this over time by recording =CT_SUPPLY("ETH") in a "History" tab weekly. Plot it to visualize whether ETH supply is growing, flat, or shrinking.

The Staking Yield Question

Staking ETH currently earns roughly 3-4% APR (this varies). If you're tracking staked ETH, you can estimate annual yield:

Staked ETH:           32
Current Price:        =CT_PRICE("ETH")
Staked Value:         =32 * CT_PRICE("ETH")
Est. Annual Yield:    =32 * 0.035 * CT_PRICE("ETH")

Adjust the 0.035 to match the current staking APR. This gives you a rough USD value of your expected annual staking income.

Track ETH Alongside Other Coins

A single-coin dashboard is useful, but most people hold more than just ETH. Extend your sheet by adding rows for other coins — every CoinTable formula works the same way:

=CT_PRICE("BTC")     → Bitcoin
=CT_PRICE("SOL")     → Solana
=CT_PRICE("ADA")     → Cardano

For a full multi-coin setup with P&L, allocation, and conditional formatting, see the track altcoin prices in Google Sheets guide.

Formulas Quick Reference

Need a printable reference for all CoinTable formulas, not just ETH? The crypto formulas cheat sheet has every function with syntax, examples, and sample output — works for any of the 10,000+ supported coins.

Summary

Tracking Ethereum in Google Sheets takes one formula: =CT_PRICE("ETH"). From there, you can build a complete dashboard with market cap, volume, ATH comparisons, staking value estimates, and holdings tracking across wallets. The data is always live, the layout is fully yours to customize, and the whole thing is free.