Google Sheets Crypto Portfolio Tracker

This Google Sheets template lets you track your crypto portfolio across networks & wallets with more ease.

Features

• Account level & aggregated balances in USD
• Fetch asset prices automatically for assets supported in CoinGecko and Google Finance
• Automatic address tracking on Ethereum for manually chosen assets
• Manual historical portfolio balance tracker
• Comes pre-initialised for 100+ assets. Add more easily with just a few clicks.
• Asset categorisation allows you to understand your exposure in terms of crypto themes, such as NFTs, DeFi, infrastructure, and more!

Setup

You'll receive a link to make a copy of the Google Sheets template. Login to your Google Account and accept copying. Please note that this will also install a script for fetching address & price data.

After copying the file, follow the instructions on the "GETTING STARTED & HELP" tab. Please note that the first load of the sheet will take a while as it loads all price and address data.

Who is it for?

Someone who wants to track their crypto portfolio in one place! This template helps with price data fetching and gives you a good starting point for building a tool for yourself. Also works for non-crypto assets.

Who is it not for?

Someone who wants a super quick start. This file requires a bit of configuration before it works.

This sheet is not intended for accurate, to-the-dollar, portfolio tracking nor to track trades or tax liabilities. It serves as a tool to track portfolio holdings over time in one place with the option of not doxxing wallets to third-party providers.

Important notes

Please note that the sheet may hit API rate limits on the first loads. If the problem persists, iterate over the price column in the "Assets" sheet and click enter when the errored cell is selected.

This sheet works for any number of blockchains and even non-crypto assets. However, it has been designed with an Ethereum user in mind. This is not a magic tool like Zapper and requires manual work to keep up to date.

The sheet default to using U.S. Dollars as the primary currency but this can be changed.