Crypto currency portfolio and trading manager template for Google Spreadsheets

in #investment9 years ago (edited)

I created this spreadsheet to help me track my trades and balance my crypto portfolio. To me, simplicity and clutterlessness are key, so I have grown to find this simple spreadsheet way more useful than the full fledged cointracking.info and the likes.

Feel free to copy the template and use it for your own: https://docs.google.com/spreadsheets/d/1uxkgGf6T_PMtXxf4kzsPdbTWZjfErgKENutv3e60LlA/edit?usp=sharing

Features:

  • Present asset valuation compared to your purchase point, to help you decide when to take profit
  • Track the balance of your accumulation and trading wallets
  • Compare your profit performance with a preview of a laddered compound profit over time
  • Calculate the additional profit % required to offset a trade that hits stop loss

It requires the google sheets add-on CRYPTOFINANCE to fetch current market prices.

More info in the spreadsheet.

Hope you like it, comments welcome!

Sort:  

Welcome to Steemit!

We have all been waiting for you, we are glad you could make it.
I have given you a upvote to help you out!

Hope you love Steemit as much as we do.

Give these a read:

Chat with us:

If this post was helpful, please leave an upvote. It helps me to keep helping new users.

I'm sunnybooster, a booster for accounts not posts. Send me 0.5 STEEM or SBD to get a week of upvotes! If you don't yet know what this is its fine.

I am a bot and this was automated. I exist to help out new members and attempt to get them hooked

Congratulations @fils! You received a personal award!

Happy Birthday! - You are on the Steem blockchain for 2 years!

You can view your badges on your Steem Board and compare to others on the Steem Ranking

Do not miss the last post from @steemitboard:

SteemitBoard supports the SteemFest⁴ Travel Reimbursement Fund.
Vote for @Steemitboard as a witness to get one more award and increased upvotes!

Coin Marketplace

STEEM 0.04
TRX 0.33
JST 0.104
BTC 65145.00
ETH 1945.16
USDT 1.00
SBD 0.37