Hi Everyone,
I spend too many hrs setting up this basic yet extremely effective portfolio sheet from scratch for personal use, simply because I don't trust any other 3rd parties to have my sensitive portfolio data.
It's truly my own work and has no dodgy links or background apps or code.
It only uses the 'cryptofinance' add-on to get the latest pricing results from the crypto market, you can remove this if you wish and update any figures manually, here is the source link so you can make any changes you want using cryptofinance: https://jbuty.com/how-to-get-crypto-currencies-rates-and-more-in-google-sheet-1a57e571bc14
To refresh everything just close and re-open the sheet, all $ is in USD, this can be changed to your currency of choice.
You can open the link to the sheet below and save a copy or export it, this way your saved or exported sheet is completely safe and private only to you for obvious reasons if privacy is important to you.
You can make any changes you want, just be mindful of the few formula's in certain areas, I left some examples to give an idea of how it works, if you want to add a row, just copy paste and update the fields/formula's accordingly.
I kept everything to a minimum as not to over complicate the sheet, I did this to make loading especially on mobiles very efficient, I go to other online resources for any other additional info.
I will be lost without this sheet, I use this to great success to track and manage my risks with my crypto portfolio without exposing the data to any 3rd parties like online portfolio sites etc.
I am sharing this to try and help other people who share my privacy and safety concerns, if it helps you please consider a tip to these jars:
BTC - 1Axj47ZrGLxoHrMnY4QpHighnoWQ8A9xZN
ETH - 0x3f5dc65fc0727a67b03ad3396e77266c0abb4e0d
DASH - XuT8LdYBReZB4s7qavVj7cSWDRcWNAbmWC
HERE IS THE LINK TO THE SHEET: https://docs.google.com/spreadsheets/d/1hDinKWGgAeP4knO-qpK8pK1DNwqFsO5sUgOn_cMAmZ4/edit?usp=sharing_eil&ts=5a0bc71a
