Crypto prices in EUR and GBP in Google Sheets

By CryptoTrackPro · Published 9 September 2026 · Examples checked against the current formula implementation

A currency symbol changes how a number looks; a currency pair changes the price you request. To value Bitcoin in euros, use =cryptotrackpro("BTC-EUR"). For pounds, use =cryptotrackpro("BTC-GBP"). Applying a pound format to a dollar quote would label the original number incorrectly. This guide builds two reporting views from the same holdings, so you can compare them without maintaining separate portfolios.

Connect the add-on and test one pair

Install CryptoTrackPro, open your spreadsheet, then choose Extensions → CryptoTrackPro → Open CryptoTrackPro. Complete the connection using the Google account you use for the sheet. Test the EUR formula in an empty cell before copying formulas across a large table. The setup guide covers installation and the full function reference.

Build the two-currency table

Use row 1 for the headers below. Enter tickers in column A and your actual coin quantities in B. The numbers shown here are invented examples, not current quotes. The C and D headers must contain exactly EUR and GBP, because the formula reads them.

Enter this in C2, then copy it right to D2 and down through your populated rows:

=cryptotrackpro($A2&"-"&C$1)

The dollar sign before A keeps the ticker column fixed when you copy sideways. The dollar sign before 1 keeps the currency header fixed when you copy down. Each row therefore asks for its own coin in the currency above that column.

Calculate position values separately:

E2: =B2*C2
F2: =B2*D2
E5: =SUM(E2:E4)
F5: =SUM(F2:F4)

Copy E2 and F2 down to row 4. The illustrative totals are €15,750 and £13,650. Format C and E as euros, D and F as pounds, and B as a number with enough decimal places for your holdings. Google's number-formatting instructions explain how to choose a currency format.

Use one reporting selector when you need fewer quotes

For a larger portfolio, two complete quote columns may be unnecessary. On a separate tab, place a reporting currency such as EUR in G1, your tickers in A, and units in B. Put the following in G2 and H2, then fill down:

G2: =cryptotrackpro($A2&"-"&$G$1)
H2: =B2*G2

Changing G1 to GBP changes the requested pair for every formula that references it. Update the heading and number format at the same time: the formula cannot automatically change a cell's formatting. A dropdown containing only your approved reporting currencies helps prevent mistyped codes. Start with one reporting view and add a second only when you use it.

Keep comparisons meaningful

Refresh the table before recording a valuation and note the time you checked it. Different reporting-currency returns can reflect both crypto price movement and currency movement. Comparing today's euro value with an earlier dollar value mixes two units and does not produce a meaningful percentage return. Store each snapshot with its currency label and holdings quantity.

Live quote coverage does not guarantee historical or indicator coverage for the same pair. RSI, MACD and OHLCV use available Kraken pairs; a current GBP quote can work even when a particular GBP indicator does not. For a dated valuation, use the historical date guide. When including tokenized real-world assets, keep them labeled as tokens: their quotes are distinct from the underlying exchange-listed shares or commodities.

Refresh within your workflow

Use Refresh All Prices on the tab you are reviewing. Paid timed refresh requires the sidebar to remain open: Base uses a 30-minute interval and Pro a 5-minute interval. Reopening a connected sheet also refreshes within your lookup allowance. These are spreadsheet refresh intervals, not a promise that every upstream quote changes on each run. If a number seems stuck, follow the refresh troubleshooting guide before duplicating formulas.

Frequently asked questions

Do I need to convert a USD quote manually?

For a supported pair, request BTC-EUR or BTC-GBP directly. Format the returned number in that same currency. Do not change only the currency symbol on a USD value.

Can I use commas or semicolons in formulas?

The examples use commas between function arguments. If your sheet uses semicolons, replace argument-separating commas with semicolons. Keep hyphens and currency codes inside quoted text unchanged.

Continue with: Build a portfolio tracker · Copy the portfolio template · All guides