Crypto Portfolio Tracking Spreadsheet Template

Here's a free crypto portfolio tracking spreadsheet to track your cryptocurrency investments using Google Sheets.

You can download it here.

Google Sheets Crypto Portfolio Tracker

In order to be able to edit the crypto portfolio tracking spreadsheet, you need to make a copy.

1. Go to the Spreadsheet here
2. Click on "File" and "Make a Copy"

You now have your own copy of the Google Sheets crypto portfolio tracker that you can edit with your own data.

Most of the crypto data is pulled automatically from Google Finance using the CURRENCY format.

You can also check the free stock portfolio tracking spreadsheet if you're more interested in tracking your stocks / ETFs portfolio.

How to Use the Crypto Portfolio Tracker

The spreadsheet is designed to be simple and user-friendly. You only need to edit the numbers in blue (currency, ticker, quantity, and buy price) or add new lines with tickers. All other numbers are populated automatically.

Key Features:

• Automatic Price Updates: Crypto prices are pulled automatically from Google Finance
• Multi-Currency Support: Choose your preferred currency (EUR, USD, etc.)
• Real-time Calculations: Portfolio value, capital gains, and percentage gains are calculated automatically
• Visual Charts: Includes portfolio allocation and performance charts

Adding Your Crypto Positions:

1. Ticker: Enter the crypto symbol (e.g., BTC, ETH, SOL)
2. Quantity: Enter how many coins you own
3. Buy Price: Enter the price you paid per coin in your preferred currency

The spreadsheet will automatically:

• Fetch current prices using Google Finance
• Calculate your current portfolio value
• Show capital gains/losses
• Display percentage gains for each position

The template includes support for major cryptocurrencies including Bitcoin (BTC), Ethereum (ETH), Solana (SOL), ...

Portfolio Overview

The spreadsheet provides a comprehensive overview of your crypto portfolio:

• Total Portfolio Value: Current value of all your crypto holdings
• Total Capital Gains: Total profit/loss across all positions
• Total Percentage Gain: Overall portfolio performance
• Individual Position Analysis: Detailed breakdown of each crypto holding

Important Notes

• Some tickers may not have Google Finance data available automatically
• Prices may be delayed up to 20 minutes
• The spreadsheet works best with major cryptocurrencies that have good liquidity
• For more advanced features like historical performance tracking, consider using a dedicated portfolio tracker