Get the Bitcoin Profit Calculator I've created in Google Sheets to manage your portfolio. Based on your inputs, it'll return the profit or loss of your Bitcoin portfolio. (Read the tutorial How To Calculate Bitcoin Profit to learn more.)
Here's how it works:
- Transactions (Columns A-E): In columns A-D, you must enter the details of your Bitcoin transaction. In column E (spent), the number will get calculated automatically by multiplying Column D (quantity) and Column C ($/BTC).
- Calculations (Columns G-I): The data gets automatically calculated from your inputs in columns G-I. The following gets calculated: your average Bitcoin purchase price, the total quantity of Bitcoin you own, and the total you've spent.
- Portfolio (Columns K-M): In columns K-M, the data gets summed from your calculations. The Google Finance function gets used to retrieve the Bitcoin price: it gets used to multiply Column L (value) with Column H (quantity). And, in Column M (profit/loss), Column L (value) is subtracted from Column I (spent).
To get instant access to the Bitcoin Profit Calculator in Google Sheets, enter your email address. (Save the Sheet into your drive by clicking 'file'. Then, 'make a copy').