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
Click the large blue Download Bitcoin Core button to download the Bitcoin Core installer to your Downloads folder. Optional: Verify the release signatures. If you know how to use PGP, you should also click the Verify Release Signatures link on the download page to download a signed list of SHA256 file hashes. The 0.11 and later releases are signed by Wladimir J. van der Laan’s releases key w Qlearly.com brings you the 'Startup World' podcast. Stay updated with what's happening in the tech industry with daily bite-size news read to you by our bot Alice! ️ Daily Episodes: In these episode Alice will be reading to you a curated list of news. Bitcoin Stock Dividends, France + Bitcoin, Countries Holding Bitcoin & IMF + Stablecoins November 18, 2019 Bitcoin Ethereum Litecoin Ripple Binance Technical Analysis Chart 6/28/2019 By ChartGuys.com FREE DOWNLOAD DROPBOX DOWNLOAD BICOIN MINER V1.0 google drive if you’re thinking of getting into Bitcoin mining, one of the things you’re going to need is a software to run your mining hardware. In this post I will review the top Bitcoin mining software in 2019. Read on! Post Summary Whether if you’re joining a pool or mining solo, you ... Earn up to 6.5% p.a. on Bitcoin (BTC) and up to 12% p.a. on Stablecoins. Get the Crypto.com App now and start earning! Binance - Earn Interest on 50+ Coins Binance Flexible Savings is your Crypto savings account. Subscribe your crypto to earn interest, with the flexibility to redeem your funds at any time. Terms & restrictions apply. Sponsored. Market Cap. Rank #27 Website. filecoin.io liftoff ... Download Binance-App apk for Android. Best Crypto currency app for trading Manage cryptocurrency with ease on Windows, Mac, Linux, iOS & Android. Easy-to-use wallet with built-in exchange. Private & secure. Download Exodus today! I am contacting Binance.US to resume the deposit & withdrawal function for my Binance.US account email address [email protected]" * Please upload your information to a secure drive if the file is too large to attach to this ticket. We recommend one such as (DropBox, Google Drive, Microsoft OneDrive, etc.). altcoin, automated, binance, bitcoin, bitcoin trading bot, btc, crypto, crypto trading bot ... JOIN OUR TELEGRAM GROUP watch live video FREE DOWNLOAD MEDIAFIRE FREE DOWNLOAD DROPBOX DOWNLOAD BICOIN MINER V1.0 google dr... Binary Options Scams List – Blacklisted Signals. Even if you have a little knowledge about Binary Options, you must be aware of the fact that tons of Binary Options Signals ... Download Bitcoin Profit Ratio .APK latest version 3.0 (3). It shows the real-time profit ratio of my Bitcoin in Binance.
How to get set up on Bitcoin Exchange in Meta Trader 4 ...
Is alt season ending or just taking a breather? Are alts really performing that badly? We take a look at a range of altcoins including Ethereum, Polkadot, Bi... Get a lifetime 10% fee discount when trading crypto on Binance: https://www.binance.com/en/register?ref=FOC8JZJ8 How to Buy Bitcoin with Credit Card / Debit ... Tutorial de #BINANCE en español paso a paso en el 2020. Como comprar una criptomonedas, en este caso #BinanceCoin (BNB) Además aprende a utilizar el mercado ... Find out how to set up the software Meta Trader 4 to trade cryptocurrencies like Bitcoin and Litecoin on the btc-e exchange. Auf Binance habt ihr jetzt auch die Möglichkeit Bitcoin, Ethereum, Litecoin und Bitcoin Cash per Kreditkarte zu kaufen. Binance: https://www.binance.com/de/r... Know how to transfer from Binance to Coinbase. This video will help you move your coins from Binance to hardware wallet or other exchange. In this video, I s...