Bitcoin profitability/calculator spreadsheet? : BitcoinMarkets

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
Purchases
  1. Any time you buy using Fiat currency you should add the purchase to the Purchases tab
  2. 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.
  3. Fiat purchase total will be flooded to the Assets tab as the capital investment
Adding a new Coin API call
  1. In Excel use the Data tab to add a new API call (from web)
  2. I'm just using CoinMarketCap until a better API comes up… use the documentation at https://coinmarketcap.com/api/
  3. Use the name for your new coin - ex: https://api.coinmarketcap.com/v1/tickeEthereum
  4. Here's the resource I used to figure it out
  5. 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)
  6. Delete the newly created sheet and the existing connection for it sheet…
  7. Rename the new data connection from "Ethereum(2)" to "Ethereum" if you want.
Add the Coin to Assets
  1. I have it split up by exchange for tracking where my assets are, where I bought them etc… not really necessary
  2. Add the new exchange, or simply use the TOTALS at the very top and get rid of the references to the exchanges
  3. 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
  4. 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.
  5. 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.
IMPORTANT:
  1. 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)
Fees
  1. 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.
  2. 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
  1. 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
  2. the Average is taken for the Delta of each transaction from the current BTC or ETH price
  3. 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)
  1. Refresh the data without locking up the application
  2. Copies the Liquid BTC column from the TOTALS table
  3. Pastes the current # of BTC for each coin in the next row of Historic Data sheet
  4. Get the Profit Analysis data and pastes it to a new row in its section of Historic Data sheet
  5. Waits 30 minutes (1800 seconds)
  6. Repeat
  7. ???
  8. Profit
submitted by ThaGuvNa to CryptoCurrency [link] [comments]

Latest Cryptocurrency News  Bitcoin Analysis & Price ... Bitcoin & Altcoins Price Prediction  Technical Analysis ... URGENT: BITCOIN DUMPED!!! Last Time To Buy!? - Binance VS ... Binance BNB Coin Analysis 🎯 Free Bitcoin Live TA BTC USD ... BITCOIN $380K END GAME!! BINANCE LIBRA FORK? - Programmer Explains Binance Coin Price Analysis - July 14th 2020 REAL LIVE TRADING ON BINANCE (Technical Analysis) - YouTube Bitcoin/ XRP Buy Signals, KIMCHI Coin, New BTC ETP ... All In On Bitcoin, Futures Soar, Stellar + Ledger, Ethereum Inflation, XRP Sales Down & Binance DDoS (BNB) Binance Coin Price Prediction 2020 & Analysis

This led to Bitcoin’s first price spike above $10, as sellers noticed the demand and began demanding a higher price for their coins. A crash followed but recovery was rapid, as the market realized that the halving in late 2012 would offer price support. The pattern of a rising price leading to a halving was established at the end of this era. After that the price of XYZ rises and you sell it for Bitcoin (worth 210 USD). Now Bitcoin rises (but also XYZ) and your Bitcoin purchase is worth 300 USD. Next you use it to buy again 1 coin XYZ ... Binance’s crypto futures platform recorded an all-time high open-interest figure of $1 billion last month, as per the Binance August trading report. The crypto exchange behemoth noted that the stratospheric rise in open interest coincided with Bitcoin’s price rise to $12,000 during the beginning of August. Also, when BTC attempted to break past the $12,400 mark, which is the current 2020 ... 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. Satoshi/Bitcoin Price. There are over 1,500 coins and tokens available in the cryptocurrency market, and a majority of them cannot be acquired using USD or any fiat currencies. The only way to acquire the majority of these coins is through buying Bitcoin (BTC) first and then converting your BTC to any of these alternative coins (altcoins). Hence, Bitcoin is the base currency for all ... Real-time Cryptocurrency price-tracker that is connected to worldcoinindex website that updates the price each minute. calculator excel spreadsheet cryptocurrency crypto. 1,805 2 add_shopping_cart. free by Crypto Friendly How to Use Google Sheets to Track Cryptocurrency Prices. A comprehensive guide on how to use Google Sheets to track cryptocurrency prices. tracker cryptocurrency bitcoin ... Home Videos Bitcoin Is Juicing Up (But How)! June 2020 Price Prediction & News Analysis Bitcoin Is Juicing Up (But How)! June 2020 Price Prediction & News Analysis. Videos 0 Home Videos Bitcoin Why The BITMEX News Matters & Bitcoin Price! October 2020 Price Prediction & News Analysis Bitcoin Why The BITMEX News Matters & Bitcoin Price! October 2020 Price Prediction & News Analysis. Videos 0 Bitcoin Cash Price Prediction Today: Daily (BCH) Value Forecast – June 19 Bitcoin Cash (BCH) Azeez Mustapha - June 19, 2019 0 On the upside, if the bulls break above the EMAs the crypto’s price will rise to retest the $440 overhead resistance level. While it is a stock market add-in, it works with Yahoo Finanace and since Yahoo now lists Bitcoin (Symbol: BTCUSD=X) Yes, that is the symbol you use to get the price, it will update your spreadsheet every time there is a change made to the spreadsheet or when you force the sheet to recalculate. This fits the bill for what you need.

[index] [11061] [14315] [5229] [18508] [12228] [4059] [12362] [18407] [12150] [5863]

Latest Cryptocurrency News Bitcoin Analysis & Price ...

NEW CHANNEL: https://www.youtube.com/channel/UCH9HlTrjyLmLRS0iE1P4rrg ----- Rich Dad Poor Dad: https://amzn.to/3cKJ4Ia C... This Binance Coin Price Analysis - July 14th 2020 is hosted by BNC's Josh Olszewicz and finds technicals for BNB to USD suggesting a nascent bullish trend as the BNB price is above the 200-day EMA ... Today reviews (bnb) binance coin crypto price analysis prediction for 2020. ... How I Made +40% PROFIT Trading Bitcoin In 1 DAY!!! (Binance Futures) - Duration: 13:00. The Right Trader 4,085 views ... Robert Kiyosaki interview: Blockchain technology, AI, Crypto, Bitcoin BTC Halving 2020 Robert Kiyosaki 58,261 watching Live now BITCOIN VS WORLD DICTATORSHIP + Cypherium Review (Stack vs Register ... Welcome to Team Underground, I (Thomas) do weekly BTC price analysis on YouTube. I've been full time trading bitcoin for over a year now and I've decided to ... Today the Bitcoin current price is $ 10,590 USD. And in today's free bitcoin trading view we take a look at Binance (BNB) as it has led the market for the be... Amazon Affiliate Link - (If You Buy Something On Amazon, I Get A Small Commission As A Way To Support The Channel) - (There is NO extra cost for you) https://amzn.to/39MXp4q Computer I Use To ... Bitcoin & Altcoins Price Prediction Technical Analysis Live Sunday Talk WORLD’S TOP CRYPTO EXCHANGES REGISTRATION LINKS: KUCOIN REGISTRATION LINK & GET 1... Latest Cryptocurrency News Bitcoin Analysis & Price Prediction Samsung Travala Binance Etc. Latest cryptocurrency news today in hindi Video covers th... BECOME A FUNDED FUTURES TRADER (20% OFF): http://tracking.topsteptrader.com/SHFN BECOME A FUNDED FOREX TRADER (20% OFF):http://offers.topstepfx.com/SHHQ 2...

#