Crypto Profit Tracker v0.1
I’ve created the following spreadsheet utility so that users can easily track their live USD/Filat profits and losses. Unlike Blockfolio or coingy that only capture the profits/losses between your buy in price and current price, this utility will factor in everything - coinbase fees from fiat to bitcoin, credit card fees, network transfer fees, and exchanges fees.
The result of this is that you can an accurate look of your portfolio value as well as an exact amount for your profits or losses.
What’s in version 0.1
Version 0.1 is the intial beta release of this tool. It includes the following features:
The portfolio tab captures all the information need to track your crypto investments. The top fileds have the Coin name, your total amount of shares in that coin, the 1 hour change, and total value of those shares you own in USD.
There is then a total overview of your portfolio:
-Portfolio Value: The USD value of all your holdings of all your coins
-Investment: The total USD amount spent to purchase your coins, including Tx fees
-Withdrawls: the toal USD amount you cashed out into your bank accounts
-Profit/Loss: The total amout in USD you have in profits or losses, updated live
This tab updates every 60 seconds for a live look.
The Buys/Deposits tab tracks the USD amount you spent to buy into crypto. This would be the amount you transfered from your bank account or credit card into bitcoin/ethereum/litecoin through coinbose or other exchange. It tracks the date of your purchase, what coin you bought/deposited into (allows only BTC/ETH/LTC) and the USD cost to make that deposit including fees. The notes filed is for your own personal tracking.
It is important to enter exact amounts here, as the portfolio values are calculated on these amounts
Similar to the buys tab, the sells tab tracks all of the coins you have cashed out into USD depositing/transfering them back to your bank account via coinboase or other exchange. The values are the same as the buys tab and like the buys tab it is important this information be accurate as the portfolio values are caluclated off of these fields.
The trades tab tracks all of your trades and all of your alt coin purchases. the coin on the lefthand side is the tethered coin you are trading/selling out of (typically bitcoin). The coin filed on the right is the alt coin you are purchasing or trading for. the quantities are all in satoshi. You do not need to worry about USD value here as that is automatically calculated. The notes filed is for your own personal notes.
Like the other tabs, the portfolio values are calulated off of these fields, so they need to be accurate.
The ticker tab imports all of the live coin data from coinmarketcap.com through their API’s. The sheets us auto updated every 60 seconds. These sheet should not be touched or edited, as any manual changes will effect or break the formulas in the spreadsheet.
The data tab has several cells were values are calulated. this data is all hidden. this tab should not be touched or edited. doing so will break the forumulas.
I will be updating this tool over time. This is beta release. please post any issues or bugs you may find. the following enhancements will be added to the next version:
-more alt coins
-a tab to enter in coins aquired at no cost (via mining, profitsharing, air drops, etc)
An example of how to use these sheet will be posted below.