How to Retrieve Crypto Ticker Prices in Google Sheets for Bitcoin and Other Altcoins

This guide will show you how to track live prices of Bitcoin and other altcoins directly in Google Sheets. Learn to automate price updates, calculate returns, and visualize gains/losses with simple formulas.

Step-by-Step Guide to Crypto Price Tracking

1. Set Up Your Coin Symbols

Use Cell A3 to input the coin symbol (e.g., BTC for Bitcoin).
Ensure symbols are in uppercase for consistency.

👉 Need a reliable crypto price API?

2. Fetch Live Crypto Prices

Insert this formula in Cell B3:

=IMPORTDATA("https://cryptoprices.cc/"&A3&"")

The formula pulls real-time prices from Crypto Prices CC.
Replace A3 with your coin symbol cell reference.

3. Display All-Time High (ATH) Prices

Add this formula in Cell C3:

=IMPORTDATA("https://cryptoprices.cc/"&A3&"/ATH")

Shows the highest historical price of the coin.

4. Calculate Profit/Loss Percentage

Enter your purchase price in Cell E3.
Use this formula in Cell F3:
```
=IF(E3 <> 0, (B3 – E3) / E3, "")
```
Computes percentage gains/losses based on current price.

5. Apply Conditional Formatting

Visualize profits (green) and losses (red):

Select Cell F3.
Go to Format > Conditional Formatting.
Set rules:
- Profit: =F3 > 0 (Green background).
- Loss: =F3 < 0 (Red background).

FAQs

Q1: Which websites provide crypto price data?

A: Reliable sources include Crypto Prices CC, CoinGecko, and CoinMarketCap.

👉 Explore more crypto tools

Q2: Can I track multiple coins at once?

A: Yes! Repeat Steps 1–4 for each coin symbol in new rows.

Q3: How often does the price update?

A: Google Sheets refreshes IMPORTDATA every 1–2 hours.

Q4: Is this method free?

A: Absolutely—no paid APIs required.

Pro Tips

Expand your sheet with columns for:
- 24-hour price change.
- Market cap.
- Portfolio allocation.
Use Markdown tables for better organization:

| Column | Purpose | Formula Example |
|--------|---------|------------------|
| A3 | Coin Symbol | BTC |
| B3 | Live Price | =IMPORTDATA(...) |
| F3 | % Return | =(B3-E3)/E3 |

Final Notes
Automate your crypto tracking without coding. Customize your sheet further with historical data or price alerts for advanced analysis.