A helpful Excel spreadsheet to help automate and monitor your assets - including historical metrics on profitability and asset holdings
Well... I put this together because it was fun (excel? fun?), but I figured I may as well share what I got- someone else out there might have some ideas to make it better, or might find it useful. It's a macro enabled excel spreadsheet which is understandably sketchy AF, so I included a 'dumb' .xlsx version and the actual macro in txt format if you're not comfortable downloading the macro version (I wouldn't blame you!) Also: as you can see I'm pretty new and I bought a bunch during the bubble this Decembeearly January. I also may have picked some longer-term holds than I was expecting... Looks like it'll be a while before I recoup my capital investments, help a dude out with some BTC or ETH if you think this is useful (or if you're just feeling charitable) Send me some BTC? 16W8XG2hXAmL1HJTzs5wWWoG8AUkyabdbT Send me some ETH? 0x48dAbF6c5B02C4f9E09E2f5B95bb231C7e9f6049 DOWNLOAD HERE! https://www.dropbox.com/sh/68se9vl6dujcf3x/AADk6NlfkDdR-6WO1WeBl4QSa?dl=0 Let me know if you have any questions- I included instructions in the document on how to interact with it also see below: Thanks for the great community, and I look forward to the rest of the year! Also: If you just wanna make fun of my stupid investments, I fully deserve it. :) Instructions (not great documentation, sorry) WARNINGS
I obviously am doing great on my investments… /s... take what I, or anyone, says with a grain of salt.
Changing stuff in this spreadsheet is not advised…
You may want to know something about Excel in order to monkey around, adding coins, etc
I am not great at excel… or macros or any of that. Get me some feedback if you have suggestions!
This is simply a tool to help give you an idea of what your portfolio looks like over time. Use it in comparison with Delta/Coinfolio. Or don't. You do you.
Any time you buy using Fiat currency you should add the purchase to the Purchases tab
I tend to use coinbase/gdax to purchase, so I simply insert the date, the amount paid, the # of coin I got, and the fees paid, etc.
Fiat purchase total will be flooded to the Assets tab as the capital investment
Adding a new Coin API call
In Excel use the Data tab to add a new API call (from web)
It will create a new tab automatically but I thought that was annoying- copy the content of the new sheet into the "Data" tab (paste at the bottom)
Delete the newly created sheet and the existing connection for it sheet…
Rename the new data connection from "Ethereum(2)" to "Ethereum" if you want.
Add the Coin to Assets
I have it split up by exchange for tracking where my assets are, where I bought them etc… not really necessary
Add the new exchange, or simply use the TOTALS at the very top and get rid of the references to the exchanges
Binance really screwed me with dust (I get it… buy BNB- bleh)… so I list those fractions as nLiq (non Liquid assets) so it's not counted in my actual return
Reference the Data sheet for the BTC amount and the USD amount. Carry and calculations over. The IF logic was to handle zero values so it was easier to read.
You'll probably need to add new coins to the TOTALS section- simply add a new record, name it, and reference the exchange below (or skip the exchange stuff and just list Totals) 5a. NOTE: The Bitcoin and Eth totals are summed from each exchange… I tend to use this as a worksheet for where I want to allocate resources too.
You'll need to manually add your new coins to the Historic Data sheet as a new column, it should be the same column order as the row order in the Assets TOTAL section WARNING: DO NOT SORT ANY TABLE or it'll screw up the Historic Data and macro stuff (see below)
I got kind of lazy, and went with Bitcoin as the fee structure for each exchange… about .001 BTC for withdrawing funds back to a Fiat exchange.
this is translated into USD fees and added up, you'll see the total fees in the TOTALS section at top
Asset Graphs They should update automatically, but you might need to make sure they follow newly added rows in the tables. Profits
These are calculated for every trade and takes an average based on the existing price… 1a. It's a little janky, because if you buy some with BTC and some with ETH you can find the % away from each, but you have to adjust the formulas for each row accordingly
the Average is taken for the Delta of each transaction from the current BTC or ETH price
This data is compiled in the Historic Data sheet
Historic Stuff On the Historical Assets tab there's a graph and it's derived from Historic Data sheet On the Historical Assets tab you'll see a button that says Start Macro and End Macro… On the Historical Profit tab there's a graph which is derived from the Histroric Data sheet The Historic Data sheet is populated by a macro which basically just copies a bunch of stuff. Macro does the following: (READ THE CODE COMMENTS)
Refresh the data without locking up the application
Copies the Liquid BTC column from the TOTALS table
Pastes the current # of BTC for each coin in the next row of Historic Data sheet
Get the Profit Analysis data and pastes it to a new row in its section of Historic Data sheet
I sold enough eth and bitcoin to pay off the mortgage to my house and compensate for taxes. Today I went to the bank and turned in my final house payment. No matter what happens to crypto from here on out, I have a house. Paying off the house was never a goal for 2020. Hell, it wasn't even a goal for the next decade. Bitcoin is classified as a decentralized virtual currency by the U.S. Treasury and as a commodity by the US Commodity Futures Trading Commission (CFTC). The IRS classifies Bitcoin as a property, which is the most relevant classification when it comes to figuring out your crypto-currency gains and losses. Microsoft’s latest upgrade roadmap for MS Office, includes four entries for bitcoin support into the four different platform version of their popular Excel spreadsheet software. Bitcoin offers a decentralized body made up of your peers, whose accounts and balances are not determined by others or any kind of political influence. Although volatile, cryptocurrencies promise to maintain and increase in value over a period of time. They also represent a quick and easy way of payment on a worldwide basis. However, their volatility remains unquestionable. Frequently a coin ... I know there have been posts on how to insert live prices into Google Sheets but I like using Excel so I set it up in there. For those who want the quick and dirty and feel like they can put it together with a couple of hints, all you'll need are the following two links: This Excel import is intended to import a large amount of trades or to edit your CoinTracking trades manually and locally on your PC. Download the CoinTracking_Excel_Import.xls Excel template file to your PC and fill in your trades. You can also export all your trades into Excel on the Enter Coins page (switch the table to Extended View first). Cryptocurrency combined market cap charts, bitcoin dominance charts, and more Now Bitcoin rises (but also XYZ) and your Bitcoin purchase is worth 300 USD. Next you use it to buy again 1 coin XYZ. The report will pick up your invested 200 USD first, then your sell for 210 ... While bitcoin has run-up to all new price highs in 2020, a great number of crypto supporters have been complaining about the mempool backlog and the high fees needed to send a transaction ... Cryptosheet's innovative interface puts a simple user guide on exactly how they can input their crypto transaction and get easy-to-follow instructions. Interface. Cryptosheet's purpose is to present an intuitive and advanced interface that allows for organized tracking and monitoring of cryptocurrency investments. The tools are arranged to provide research on future investments through complex ...
How to Withdraw Bitcoin from a Bitcoin Exchange to a ...
Not on Coinbase Yet? Join Here: https://www.coinbase.com/join/5a0579e45698da00e3e10b86 A quick tutorial that shows you how to find a bitcoin transaction ID (... Binance Academy 8,808 views. 6:03 . How To Keep Your Cryptocurrency Safe - Duration: 6:21. Ameer Rosic Recommended for you. 6:21. Blockchain/Bitcoin for beginners 3: public/private keys ... #Coinbase In max 3 min Bitcoin versenden von deinem Coinbase Konto, so gehts. Eine Auszahlung hat bei mir ca 20 min gedauert. Nach der Eingabe des Codes den man via SMS bekommt, die Transaktion ... Mon tuto Binance sur comment faire ses premiers trades sur le plus gros site bitcoin et cryptomonnaie du monde ! Le lien pour t'inscrire sur Binance : http:/... get 10% kick back when you sign up with my Binance link https://www.binance.com/en/register?ref=XB17R2L0 read the article which got the inspiration for this ... 🚨 MEGA BITCOIN BLUEPRINT SALE 🚨 https://www.btcblueprint.com 🔥 Up To $600 Discount - Limited Time 🔥 🔲 My Top 3 Recommended Exchanges 🔵 Phemex http ... If you want to use bitcoin for buying things online, you should use a bitcoin wallet that broadcasts transactions immediately. Most accounts and exchange ser... mnay binance trader and poloniex , kraken , need this to work How the bitcoin accelerator works What is ConfirmBTC? ConfirmBTC is a bitcoin transaction accelerator that allows you to get faster ... Get an additional $10 in Bitcoins from Coinbase when purchasing through my referral link http://fredyen.com/get/Bitcoins Here is a quick beginner's guide on ... IN today's video we take a look at how to Use Binance , specifically, how to deposit and withdraw on the Binance Exchange. I've set up a new Telegram group f...