Google Sheets BTC portfolio tracker

Free Bitcoins: FreeBitcoin | BonusBitcoin

Coins Kaufen: Bitcoin.deAnycoinDirektCoinbaseCoinMama (mit Kreditkarte)Paxfull

Handelsplätze / Börsen: Bitcoin.de | KuCoinBinanceBitMexBitpandaeToro

Lending / Zinsen erhalten: Celsius NetworkCoinlend (Bot)

Cloud Mining: HashflareGenesis MiningIQ Mining


I’ve recently been developing my own BTC transactions tracker using Google Sheets that I’d like to share with anyone interested. The demo sheet includes fake buy/sell transactions using BTC historical prices directly from Google Finance.

This tracker allows you to check:

1. Your all-time buy/sell performance (realized vs realized gains, portfolio cost vs current value)
2. Your buy/sell performance for specific time periods > the demo sheet is currently set to look at the (fake) portfolio’s performance between Mar.21st, 2021 and and Jan. 22nd, 2022.
3. Details for all your transactions and their individual performance in relation to today’s price.

**The only columns that need filling are columns B to F in the ‘Tx Tracker’ sheet. The rest is automatically calculated for you.**

I wanted to keep it simple for my own sake. I have tried looking for good trackers in the past, but many of them are either too simplistic and don’t allow you to look at your overall performance, whilst others are far too complex to use for the noob I am – so I tried to strike a middle ground with this one.

Here’s the link to the file: [https://docs.google.com/spreadsheets/d/1tjt-GPQePqZqutKsugb2inIhaIWF-mZZB2LNPY7TsnU/edit#gid=692653265](https://docs.google.com/spreadsheets/d/1tjt-GPQePqZqutKsugb2inIhaIWF-mZZB2LNPY7TsnU/edit#gid=692653265)

I’ve restricted the sheet to ‘view only’, so you can click ‘File > Make a copy’ if you’d like to use it. One you’ve copied it, you will have access to the drop-down menu to select your desired time range in the ‘PERF BY DATE’ sheet.

Enjoy!

View Reddit by caoimghin_mcmarshall – View Source



Post Views:
12



[ad_2]

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close