30+ Best Cryptocurrency images cryptocurrency, what is ...
30+ Best Cryptocurrency images cryptocurrency, what is ...
Webdesign CMS Internet Homepage w3box Bad Abbach ...
Cryptocurrency 40+ ideas on Pinterest in 2020 ...
Bitcoin Unconfirmed Transactions History
Blockfolio - Bitcoin and Cryptocurrency Tracker - by ...
10+ Best Bitcoin Success Stories images bitcoin, success ...
Jobs in Nürnberg Stellenangebote jobs.inFranken.de
93 Best Crypto Coin images Crypto coin, Cryptocurrency ...
Dogecoin (DOGE) price, marketcap, chart, and info ...
Tixl Token Sale General Terms and Conditions: Version 6 ...
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
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. 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! 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. 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. 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. 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 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 ...
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 ... 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 ... 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 ... 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 ... 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... WATCH LIVE DAILY: https://ivanontech.com/live 🚀 SIGN UP FOR ACADEMY: https://academy.ivanontech.com ️ BEST DEALS: https://ivanontech.com/deals SIGN UP F... 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:/... 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 (...