A crypto portfolio tracker for Google Sheets is useful for real-time monitoring of cryptocurrency investments, enabling informed decisions and financial strategy optimization.
Access our free crypto tracker for Google Sheets here.
Please do not request edit access. To make a copy, go to 'File' and select 'Make a copy’.
Follow the steps below to use the Google Sheets crypto portfolio tracker.
Your template has two parts: Summary and Transactions. The Summary shows your overall portfolio. Transactions list all your buys, sells, and transfers.
Summary: Check cryptocurrencies, investments, and returns here.
Transactions: Enter details of your crypto activities.
You can add new cryptocurrencies or indicators in the Summary.
To add a cryptocurrency: Add a row, type its name, and enter initial details.
To add an indicator: Insert a column and name it after the new indicator.
The template have example transactions. Delete these rows to start fresh.
Record every crypto transaction in the Transactions section. Fill in the date, type, cryptocurrency, exchange, coins, and price. Use the green cells for inputs.
Check and update your tracker regularly. Add new transactions as they happen. This helps you stay on top of your investments and see how they are doing.
We hope that you now have a better understanding of how to use our free crypto portfolio tracker for Google Sheets. If you enjoyed this article, you might also like our article on our free options tracker for Google Sheets or our article on employee training tracker.
