93 Best Crypto Coin images Crypto coin, Cryptocurrency ...

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]

$100 A Day Trading On Binance - Cryptocurrency Trading For ... How to Withdraw Bitcoin from a Bitcoin Exchange to a ... Binance tuto : meilleur site Trading Bitcoin Cryptos ... How to Find a Bitcoin Transaction ID in Your Coinbase ... How to deposit and withdraw on Binance - YouTube Tracking Bitcoin Transactions (Forensics) - Programmer ... Keeping your private keys secure How To Trade Bitcoin Cryptocurrency for Beginners - YouTube Pending btc, Solve this problem only one seconds, HOW BITCOIN TRANSACTION WORKS - YouTube

Tixl Token Sale General Terms and Conditions Version 6 - September 2019 Link Disclaimer Our General Terms and Conditions contain links to external websites. Despite our careful content control, we assume no liability for the content of external websites. We have no influence on the content of external websites and the operators of the linked websites are solely responsible for their content. Dogecoin differs from Bitcoin's proof-of-work protocol in several ways, one of which is by using Scrypt technology. The altcoin has also a block time of 1 minute, and the total supply is uncapped, which means that there is no limit to the number of Dogecoin that can be mined. You can mine Dogecoin either solo, or by joining a mining pool. A Doge miner can mine the digital currency on Windows ... Sep 3, 2017 - Explore Jacqui Kimmel's board "Cryptocurrency", followed by 449 people on Pinterest. See more ideas about Cryptocurrency, What is bitcoin mining, Investing. Jun 24, 2018 - Explore Wealth Freedom Foundation Bi's board "Bitcoin Success Stories", followed by 222 people on Pinterest. See more ideas about Bitcoin, Success stories, Cryptocurrency. BitDegree Transaction unconfirmed:As you can see from Johoe’s Mempool Stats site, transactions with 10 sat/B were buried underneath a mountain of higher transaction fees:Once the transaction is Jan 15, moving average trading strategy python 2018 - My apartment had a lot of extra space, and I was living in a shoddy old I googled “unconfirmed Bitcoin transactions” and discovered a litany ... 1. Effortlessly track over 2000 cryptocurrencies & stay updated on new currencies that are added the same day they enter the exchange 2. Input holdings & transaction history for an effective overview of your true portfolio value 3. News Reader gives the latest Bitcoin & Altcoin news from CoinDesk, Bitcoin Magazine & other relevant cryptocurrency outlets Wir entwickeln und betreuen Internetauftritte für Unternehmen, Vereine und Privatpersonen im Raum Bad Abbach - Regensburg - Kelheim und überregional. Gerne auch für Sie! Auf der regionalen Jobbörse von inFranken finden Sie alle Stellenangebote in Nürnberg und Umgebung Suchen - Finden - Bewerben und dem Traumjob in Nürnberg ein Stück näher kommen mit jobs.infranken.de! Mar 14, 2019 - Explore Suzanne Lover's board "Crypto Coin", followed by 3025 people on Pinterest. See more ideas about Crypto coin, Cryptocurrency, What is bitcoin mining. VOGAL A - Treinando letra cursiva VOGAL E - Treinando letra cursiva VOGAL I - Treinando letra cursiva VOGAL O - Treinando letra cursiva VOGAL U - Treinando letra cursiva Como baix

[index] [4554] [15692] [14708] [17376] [8209] [23245] [14092] [9571] [14427] [9397]

$100 A Day Trading On Binance - Cryptocurrency Trading For ...

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... 🚨 MEGA BITCOIN BLUEPRINT SALE 🚨 https://www.btcblueprint.com 🔥 Up To $600 Discount - Limited Time 🔥 🔲 My Top 3 Recommended Exchanges 🔵 Phemex http ... 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 ... 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 ... 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 ... 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... 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 (... how to confirm btc ( bitcoin ) unconfirmed transaction ! 100% working ! mlm nitin - Duration: 6:11. MLM NITIN 38,199 views. 6:11. Bitcoin Fees and Unconfirmed Transactions - Complete Beginner's ... 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:/... WATCH LIVE DAILY: https://ivanontech.com/live 🚀 SIGN UP FOR ACADEMY: https://academy.ivanontech.com ️ BEST DEALS: https://ivanontech.com/deals SIGN UP F...

#