How can I use Google Sheets to create a cryptocurrency portfolio tracker?

1 answers

• Dec 29, 2021 · 3 years ago
  Creating a cryptocurrency portfolio tracker in Google Sheets is a great way to stay organized. Here's how you can do it: 1. Open Google Sheets and create a new spreadsheet. 2. Name the first column 'Cryptocurrency' and the second column 'Quantity'. 3. Enter the names of the cryptocurrencies you own in the first column. 4. Enter the quantity of each cryptocurrency you own in the second column. 5. Use the '=CRYPTOFINANCE()' add-on to fetch the current prices of the cryptocurrencies. 6. Multiply the quantity by the current price to calculate the total value of each cryptocurrency. 7. Use conditional formatting to highlight the positive and negative changes in the portfolio. 8. You can also add additional columns to track other information like purchase price or profit/loss. That's it! You now have a cryptocurrency portfolio tracker in Google Sheets. Enjoy tracking your investments!
  893447