Import All Live Cryptocurrency Data Into a Spreadsheet in ...

P2P Bitcoin Derivative Trading Through the Blockchain: Equities, Bonds, Forex & Commodities

Research & ideas to use [Veritaseum's UltraCoin](http://ultra-coin.com/) **user programmable Bitcoin swaps** to trade exposures to cryptos, forex, equities, bonds & commodities through 45,000+ global tickers & up to 10,000x price leverage - peer-to-peer. Veritaseum's UltraCoin is a software concern that holds no client funds and is not a financial entity, hence presents you with no counterparty or default risk. [Download the client & tutorials](http://ultra-coin.com/index.php/download-beta)
[link]

I made a complete bitcoin spreadsheet (excel) with live crypto price updates, moon math, and a full history of your Portfolio and trading performance.

I made a complete bitcoin spreadsheet (excel) with live crypto price updates, moon math, and a full history of your Portfolio and trading performance.
This is a spreadsheet that I have developed for myself over the last year or so. I have found it very helpful for keeping track of my bitcoin holdings (great for tax purposes) and how well my trading decisions have been (not great). I figure it's time to share.
There is a lot in here including;
Automatically updates prices from coinmarketcap. Nearly 2000 coins included. Just select which ones you want to track by typing in the name.
You can even choose your local Fiat currency and get live conversion rates for any country.

https://preview.redd.it/zgsggn369pk11.png?width=602&format=png&auto=webp&s=8db3d0b1118d5d7b402988339f696e620a69f780
No need to record details of every trade. Just keep track of your bitcoin purhcases (from fiat) and what coins you currently hold. The spreadsheet will calculate the rest and keep a record of how your portfolio and holdings have changed over time.

https://preview.redd.it/yqt28sf79pk11.png?width=602&format=png&auto=webp&s=c4b5c4aecc226cbc39139e4d5d050e0f7430a494

This data gets saved every time you save the spreadsheet.

https://preview.redd.it/b00vize89pk11.png?width=602&format=png&auto=webp&s=152d1a0698712941b643a063270174378f4bd6e5
I find this very handy to see if your trading is actually profitable compared to the HODL method.

https://preview.redd.it/0d8o7dba9pk11.png?width=929&format=png&auto=webp&s=e17d0f256465b24bb9c67a4e14a7ad55c9e0dc01

Oh yes and there are plenty of 'moon math' and analytics to see how bitcoin is trending and how far off you are from a lambo. This includes a full history of bitcoins price which updates every time you open the sheet.


https://preview.redd.it/pveh8ehb9pk11.png?width=602&format=png&auto=webp&s=e750e06735558f34a7bddcb13b2092f641f49db9
Also includes a bitcoin block countdown time (i.e number of days until halvening), and a 'regret calculator' among others.
free download from here. Instructions inside. You will need macros enabled (if you want it to do the fancy stuff).
https://www.dropbox.com/s/2n8xpn9r8oyetli/Cryptoprices9%20-%20For%20others.xlsm?dl=0
Let me know if you have any issues.
submitted by Fly115 to Bitcoin [link] [comments]

I created a website where Bitcoin traders and investors could go to get easy access to datasets and trading tools. This platform would be tailored to folks who prefer to do analysis within spreadsheets such as Excel and Google Sheets.

https://spreadstreet.io
My name is John, and back in February of this year I started working on a website where Bitcoin traders and investors could go to get easy access to datasets and trading tools (such as technical analysis templates). This platform would require no coding knowledge, and would be tailored to folks who prefer to do analysis within spreadsheets such as Excel and Google Sheets.
Quick About Me
I am a former Fortune 500 financial analyst, where I managed two $3 billion portfolios. I've been investing/trading since 2002/2003. If you take a look at my kindle cloud reader, you will see over 100 books dedicated to trading and investing of all sorts - technical analysis, fundamental analysis, daily options trading strategies, value investing, volatility trading, quantitative trading, algorithmic trading, and bullshit trading.
I think Bitcoin and crypto is the future, and I believe that it is on an unstoppable path. My ultimate goal is to become a cost-leader in the field, and be tailored towards the individual investor. You shouldn't have to pay hundreds to thousands of dollars for top-notch tools.
Features at a Glance
Databases currently included (updated daily)
All datasets are available as a tab-delimited, CSV file. The datasets are a mix between raw tick data, OHLCV, spreads, mining and economic statistics. They can be used for backtesting, analysis, and charting.
Investing/Trading Templates
On The Horizon
Potential Ideas
I'm open to answer questions or talk more about the project if there's interest. Hope it helps the traders and investors out there.
John
submitted by 1kexperimentdotcom to BitcoinMarkets [link] [comments]

I made a complete bitcoin spreadsheet (excel) with live crypto price updates, moon math, and a full history of your Portfolio and trading performance. /r/Bitcoin

I made a complete bitcoin spreadsheet (excel) with live crypto price updates, moon math, and a full history of your Portfolio and trading performance. /Bitcoin submitted by ABitcoinAllBot to BitcoinAll [link] [comments]

I created a website where Bitcoin traders and investors could go to get easy access to datasets and trading tools. This platform would be tailored to folks who prefer to do analysis within spreadsheets such as Excel and Google Sheets. (/r/BitcoinMarkets)

I created a website where Bitcoin traders and investors could go to get easy access to datasets and trading tools. This platform would be tailored to folks who prefer to do analysis within spreadsheets such as Excel and Google Sheets. (/BitcoinMarkets) submitted by ContentForager to mistyfront [link] [comments]

I created a website where Bitcoin traders and investors could go to get easy access to datasets and trading tools. This platform would be tailored to folks who prefer to do analysis within spreadsheets such as Excel and Google Sheets. /r/BitcoinMarkets

I created a website where Bitcoin traders and investors could go to get easy access to datasets and trading tools. This platform would be tailored to folks who prefer to do analysis within spreadsheets such as Excel and Google Sheets. /BitcoinMarkets submitted by BitcoinAllBot to BitcoinAll [link] [comments]

What is the best free Excel/GDocs spreadsheet to track my Bitcoin trading?

submitted by catsfive to btc [link] [comments]

What is the best free Excel/GDocs spreadsheet to track my Bitcoin trading? /r/btc

What is the best free Excel/GDocs spreadsheet to track my Bitcoin trading? /btc submitted by BitcoinAllBot to BitcoinAll [link] [comments]

Bitcoin Newcomers FAQ - Please read!

Welcome to the /Bitcoin Sticky FAQ

You've probably been hearing a lot about Bitcoin recently and are wondering what's the big deal? Most of your questions should be answered by the resources below but if you have additional questions feel free to ask them in the comments.
It all started with the release of the release of Satoshi Nakamoto's whitepaper however that will probably go over the head of most readers so we recommend the following videos for a good starting point for understanding how bitcoin works and a little about its long term potential:
Some other great resources include Lopp.net, the Princeton crypto series and James D'Angelo's Bitcoin 101 Blackboard series.
Some excellent writing on Bitcoin's value proposition and future can be found at the Satoshi Nakamoto Institute.
Some Bitcoin statistics can be found here and here. Developer resources can be found here. Peer-reviewed research papers can be found here.
Potential upcoming protocol improvements and scaling resources here and here.
The number of times Bitcoin was declared dead by the media can be found here (LOL!)

Key properties of Bitcoin

Where can I buy bitcoins?

Bitcoin.org and BuyBitcoinWorldwide.com are helpful sites for beginners. You can buy or sell any amount of bitcoin (even just a few dollars worth) and there are several easy methods to purchase bitcoin with cash, credit card or bank transfer. Some of the more popular resources are below, also check out the bitcoinity exchange resources for a larger list of options for purchases.
Here is a listing of local ATMs. If you would like your paycheck automatically converted to bitcoin use Bitwage.
Note: Bitcoins are valued at whatever market price people are willing to pay for them in balancing act of supply vs demand. Unlike traditional markets, bitcoin markets operate 24 hours per day, 365 days per year. Preev is a useful site that that shows how much various denominations of bitcoin are worth in different currencies. Alternatively you can just Google "1 bitcoin in (your local currency)".

Securing your bitcoins

With bitcoin you can "Be your own bank" and personally secure your bitcoins OR you can use third party companies aka "Bitcoin banks" which will hold the bitcoins for you.
Note: For increased security, use Two Factor Authentication (2FA) everywhere it is offered, including email!
2FA requires a second confirmation code to access your account making it much harder for thieves to gain access. Google Authenticator and Authy are the two most popular 2FA services, download links are below. Make sure you create backups of your 2FA codes.
Google Auth Authy OTP Auth
Android Android N/A
iOS iOS iOS

Watch out for scams

As mentioned above, Bitcoin is decentralized, which by definition means there is no official website or Twitter handle or spokesperson or CEO. However, all money attracts thieves. This combination unfortunately results in scammers running official sounding names or pretending to be an authority on YouTube or social media. Many scammers throughout the years have claimed to be the inventor of Bitcoin. Websites like bitcoin(dot)com and the btc subreddit are active scams. Almost all altcoins (shitcoins) are marketed heavily with big promises but are really just designed to separate you from your bitcoin. So be careful: any resource, including all linked in this document, may in the future turn evil. Don't trust, verify. Also as they say in our community "Not your keys, not your coins".

Where can I spend bitcoins?

Check out spendabit or bitcoin directory for millions of merchant options. Also you can spend bitcoin anywhere visa is accepted with bitcoin debit cards such as the CashApp card. Some other useful site are listed below.
Store Product
Gyft Gift cards for hundreds of retailers including Amazon, Target, Walmart, Starbucks, Whole Foods, CVS, Lowes, Home Depot, iTunes, Best Buy, Sears, Kohls, eBay, GameStop, etc.
Spendabit, Overstock and The Bitcoin Directory Retail shopping with millions of results
ShakePay Generate one time use Visa cards in seconds
NewEgg and Dell For all your electronics needs
Bitwa.la, Coinbills, Piixpay, Bitbill.eu, Bylls, Coins.ph, Bitrefill, LivingRoomofSatoshi, Coinsfer, and more Bill payment
Menufy, Takeaway and Thuisbezorgd NL Takeout delivered to your door
Expedia, Cheapair, Destinia, Abitsky, SkyTours, the Travel category on Gyft and 9flats For when you need to get away
Cryptostorm, Mullvad, and PIA VPN services
Namecheap, Porkbun Domain name registration
Stampnik Discounted USPS Priority, Express, First-Class mail postage
Coinmap and AirBitz are helpful to find local businesses accepting bitcoins. A good resource for UK residents is at wheretospendbitcoins.co.uk.
There are also lots of charities which accept bitcoin donations.

Merchant Resources

There are several benefits to accepting bitcoin as a payment option if you are a merchant;
If you are interested in accepting bitcoin as a payment method, there are several options available;

Can I mine bitcoin?

Mining bitcoins can be a fun learning experience, but be aware that you will most likely operate at a loss. Newcomers are often advised to stay away from mining unless they are only interested in it as a hobby similar to folding at home. If you want to learn more about mining you can read more here. Still have mining questions? The crew at /BitcoinMining would be happy to help you out.
If you want to contribute to the bitcoin network by hosting the blockchain and propagating transactions you can run a full node using this setup guide. If you would prefer to keep it simple there are several good options. You can view the global node distribution here.

Earning bitcoins

Just like any other form of money, you can also earn bitcoins by being paid to do a job.
Site Description
WorkingForBitcoins, Bitwage, Cryptogrind, Coinality, Bitgigs, /Jobs4Bitcoins, BitforTip, Rein Project Freelancing
Lolli Earn bitcoin when you shop online!
OpenBazaar, Purse.io, Bitify, /Bitmarket, 21 Market Marketplaces
/GirlsGoneBitcoin NSFW Adult services
A-ads, Coinzilla.io Advertising
You can also earn bitcoins by participating as a market maker on JoinMarket by allowing users to perform CoinJoin transactions with your bitcoins for a small fee (requires you to already have some bitcoins.

Bitcoin-Related Projects

The following is a short list of ongoing projects that might be worth taking a look at if you are interested in current development in the bitcoin space.
Project Description
Lightning Network Second layer scaling
Blockstream, Rootstock and Drivechain Sidechains
Hivemind and Augur Prediction markets
Tierion and Factom Records & Titles on the blockchain
BitMarkets, DropZone, Beaver and Open Bazaar Decentralized markets
JoinMarket and Wasabi Wallet CoinJoin implementation
Coinffeine and Bisq Decentralized bitcoin exchanges
Keybase Identity & Reputation management
Abra Global P2P money transmitter network
Bitcore Open source Bitcoin javascript library

Bitcoin Units

One Bitcoin is quite large (hundreds of £/$/€) so people often deal in smaller units. The most common subunits are listed below:
Unit Symbol Value Info
bitcoin BTC 1 bitcoin one bitcoin is equal to 100 million satoshis
millibitcoin mBTC 1,000 per bitcoin used as default unit in recent Electrum wallet releases
bit bit 1,000,000 per bitcoin colloquial "slang" term for microbitcoin (μBTC)
satoshi sat 100,000,000 per bitcoin smallest unit in bitcoin, named after the inventor
For example, assuming an arbitrary exchange rate of $10000 for one Bitcoin, a $10 meal would equal:
For more information check out the Bitcoin units wiki.
Still have questions? Feel free to ask in the comments below or stick around for our weekly Mentor Monday thread. If you decide to post a question in /Bitcoin, please use the search bar to see if it has been answered before, and remember to follow the community rules outlined on the sidebar to receive a better response. The mods are busy helping manage our community so please do not message them unless you notice problems with the functionality of the subreddit.
Note: This is a community created FAQ. If you notice anything missing from the FAQ or that requires clarification you can edit it here and it will be included in the next revision pending approval.
Welcome to the Bitcoin community and the new decentralized economy!
submitted by BitcoinFan7 to Bitcoin [link] [comments]

DataSource.Error: Unable to connect to the remote server

Does anyone know what the correct syntax is to get a query returned?
I created a Day Trading Spreadsheet that includes an external query to coinmarketcap.com that used to work, but no longer does. I believe it is due to them requiring that you have an API account with them as they can monitor the amount of queries to their database on a daily/monthly basis.
My query that used to work is this:
= Json.Document(Web.Contents("https://api.coinmarketcap.com/v1/tickebitcoin"))
I have since signed up with coinmarketcap.com and recieved my API key, but I can't find the procedure to use my API key within Excel. Does anyone know what the correct syntax would be to return a query from coinmarketcap.com?
The URL that it goes to is: https://api.coinmarketcap.com/v1/tickebitcoin
And Open File As is set to Json.
submitted by rogue30 to excel [link] [comments]

Scaling Reddit Community Points with Arbitrum Rollup: a piece of cake

Scaling Reddit Community Points with Arbitrum Rollup: a piece of cake
https://preview.redd.it/b80c05tnb9e51.jpg?width=2550&format=pjpg&auto=webp&s=850282c1a3962466ed44f73886dae1c8872d0f31
Submitted for consideration to The Great Reddit Scaling Bake-Off
Baked by the pastry chefs at Offchain Labs
Please send questions or comments to [[email protected] ](mailto:[email protected])
1. Overview
We're excited to submit Arbitrum Rollup for consideration to The Great Reddit Scaling Bake-Off. Arbitrum Rollup is the only Ethereum scaling solution that supports arbitrary smart contracts without compromising on Ethereum's security or adding points of centralization. For Reddit, this means that Arbitrum can not only scale the minting and transfer of Community Points, but it can foster a creative ecosystem built around Reddit Community Points enabling points to be used in a wide variety of third party applications. That's right -- you can have your cake and eat it too!
Arbitrum Rollup isn't just Ethereum-style. Its Layer 2 transactions are byte-for-byte identical to Ethereum, which means Ethereum users can continue to use their existing addresses and wallets, and Ethereum developers can continue to use their favorite toolchains and development environments out-of-the-box with Arbitrum. Coupling Arbitrum’s tooling-compatibility with its trustless asset interoperability, Reddit not only can scale but can onboard the entire Ethereum community at no cost by giving them the same experience they already know and love (well, certainly know).
To benchmark how Arbitrum can scale Reddit Community Points, we launched the Reddit contracts on an Arbitrum Rollup chain. Since Arbitrum provides full Solidity support, we didn't have to rewrite the Reddit contracts or try to mimic their functionality using an unfamiliar paradigm. Nope, none of that. We launched the Reddit contracts unmodified on Arbitrum Rollup complete with support for minting and distributing points. Like every Arbitrum Rollup chain, the chain included a bridge interface in which users can transfer Community Points or any other asset between the L1 and L2 chains. Arbitrum Rollup chains also support dynamic contract loading, which would allow third-party developers to launch custom ecosystem apps that integrate with Community Points on the very same chain that runs the Reddit contracts.
1.1 Why Ethereum
Perhaps the most exciting benefit of distributing Community Points using a blockchain is the ability to seamlessly port points to other applications and use them in a wide variety of contexts. Applications may include simple transfers such as a restaurant that allows Redditors to spend points on drinks. Or it may include complex smart contracts -- such as placing Community Points as a wager for a multiparty game or as collateral in a financial contract.
The common denominator between all of the fun uses of Reddit points is that it needs a thriving ecosystem of both users and developers, and the Ethereum blockchain is perhaps the only smart contract platform with significant adoption today. While many Layer 1 blockchains boast lower cost or higher throughput than the Ethereum blockchain, more often than not, these attributes mask the reality of little usage, weaker security, or both.
Perhaps another platform with significant usage will rise in the future. But today, Ethereum captures the mindshare of the blockchain community, and for Community Points to provide the most utility, the Ethereum blockchain is the natural choice.
1.2 Why Arbitrum
While Ethereum's ecosystem is unmatched, the reality is that fees are high and capacity is too low to support the scale of Reddit Community Points. Enter Arbitrum. Arbitrum Rollup provides all of the ecosystem benefits of Ethereum, but with orders of magnitude more capacity and at a fraction of the cost of native Ethereum smart contracts. And most of all, we don't change the experience from users. They continue to use the same wallets, addresses, languages, and tools.
Arbitrum Rollup is not the only solution that can scale payments, but it is the only developed solution that can scale both payments and arbitrary smart contracts trustlessly, which means that third party users can build highly scalable add-on apps that can be used without withdrawing money from the Rollup chain. If you believe that Reddit users will want to use their Community Points in smart contracts--and we believe they will--then it makes the most sense to choose a single scaling solution that can support the entire ecosystem, eliminating friction for users.
We view being able to run smart contracts in the same scaling solution as fundamentally critical since if there's significant demand in running smart contracts from Reddit's ecosystem, this would be a load on Ethereum and would itself require a scaling solution. Moreover, having different scaling solutions for the minting/distribution/spending of points and for third party apps would be burdensome for users as they'd have to constantly shuffle their Points back and forth.
2. Arbitrum at a glance
Arbitrum Rollup has a unique value proposition as it offers a combination of features that no other scaling solution achieves. Here we highlight its core attributes.
Decentralized. Arbitrum Rollup is as decentralized as Ethereum. Unlike some other Layer 2 scaling projects, Arbitrum Rollup doesn't have any centralized components or centralized operators who can censor users or delay transactions. Even in non-custodial systems, centralized components provide a risk as the operators are generally incentivized to increase their profit by extracting rent from users often in ways that severely degrade user experience. Even if centralized operators are altruistic, centralized components are subject to hacking, coercion, and potential liability.
Massive Scaling. Arbitrum achieves order of magnitude scaling over Ethereum's L1 smart contracts. Our software currently supports 453 transactions-per-second for basic transactions (at 1616 Ethereum gas per tx). We have a lot of room left to optimize (e.g. aggregating signatures), and over the next several months capacity will increase significantly. As described in detail below, Arbitrum can easily support and surpass Reddit's anticipated initial load, and its capacity will continue to improve as Reddit's capacity needs grow.
Low cost. The cost of running Arbitrum Rollup is quite low compared to L1 Ethereum and other scaling solutions such as those based on zero-knowledge proofs. Layer 2 fees are low, fixed, and predictable and should not be overly burdensome for Reddit to cover. Nobody needs to use special equipment or high-end machines. Arbitrum requires validators, which is a permissionless role that can be run on any reasonable on-line machine. Although anybody can act as a validator, in order to protect against a “tragedy of the commons” and make sure reputable validators are participating, we support a notion of “invited validators” that are compensated for their costs. In general, users pay (low) fees to cover the invited validators’ costs, but we imagine that Reddit may cover this cost for its users. See more on the costs and validator options below.
Ethereum Developer Experience. Not only does Arbitrum support EVM smart contracts, but the developer experience is identical to that of L1 Ethereum contracts and fully compatible with Ethereum tooling. Developers can port existing Solidity apps or write new ones using their favorite and familiar toolchains (e.g. Truffle, Buidler). There are no new languages or coding paradigms to learn.
Ethereum wallet compatibility. Just as in Ethereum, Arbitrum users need only hold keys, but do not have to store any coin history or additional data to protect or access their funds. Since Arbitrum transactions are semantically identical to Ethereum L1 transactions, existing Ethereum users can use their existing Ethereum keys with their existing wallet software such as Metamask.
Token interoperability. Users can easily transfer their ETH, ERC-20 and ERC-721 tokens between Ethereum and the Arbitrum Rollup chain. As we explain in detail below, it is possible to mint tokens in L2 that can subsequently be withdrawn and recognized by the L1 token contract.
Fast finality. Transactions complete with the same finality time as Ethereum L1 (and it's possible to get faster finality guarantees by trading away trust assumptions; see the Arbitrum Rollup whitepaper for details).
Non-custodial. Arbitrum Rollup is a non-custodial scaling solution, so users control their funds/points and neither Reddit nor anyone else can ever access or revoke points held by users.
Censorship Resistant. Since it's completely decentralized, and the Arbitrum protocol guarantees progress trustlessly, Arbitrum Rollup is just as censorship-proof as Ethereum.
Block explorer. The Arbitrum Rollup block explorer allows users to view and analyze transactions on the Rollup chain.
Limitations
Although this is a bake-off, we're not going to sugar coat anything. Arbitrum Rollup, like any Optimistic Rollup protocol, does have one limitation, and that's the delay on withdrawals.
As for the concrete length of the delay, we've done a good deal of internal modeling and have blogged about this as well. Our current modeling suggests a 3-hour delay is sufficient (but as discussed in the linked post there is a tradeoff space between the length of the challenge period and the size of the validators’ deposit).
Note that this doesn't mean that the chain is delayed for three hours. Arbitrum Rollup supports pipelining of execution, which means that validators can keep building new states even while previous ones are “in the pipeline” for confirmation. As the challenge delays expire for each update, a new state will be confirmed (read more about this here).
So activity and progress on the chain are not delayed by the challenge period. The only thing that's delayed is the consummation of withdrawals. Recall though that any single honest validator knows immediately (at the speed of L1 finality) which state updates are correct and can guarantee that they will eventually be confirmed, so once a valid withdrawal has been requested on-chain, every honest party knows that the withdrawal will definitely happen. There's a natural place here for a liquidity market in which a validator (or someone who trusts a validator) can provide withdrawal loans for a small interest fee. This is a no-risk business for them as they know which withdrawals will be confirmed (and can force their confirmation trustlessly no matter what anyone else does) but are just waiting for on-chain finality.
3. The recipe: How Arbitrum Rollup works
For a description of the technical components of Arbitrum Rollup and how they interact to create a highly scalable protocol with a developer experience that is identical to Ethereum, please refer to the following documents:
Arbitrum Rollup Whitepaper
Arbitrum academic paper (describes a previous version of Arbitrum)
4. Developer docs and APIs
For full details about how to set up and interact with an Arbitrum Rollup chain or validator, please refer to our developer docs, which can be found at https://developer.offchainlabs.com/.
Note that the Arbitrum version described on that site is older and will soon be replaced by the version we are entering in Reddit Bake-Off, which is still undergoing internal testing before public release.
5. Who are the validators?
As with any Layer 2 protocol, advancing the protocol correctly requires at least one validator (sometimes called block producers) that is honest and available. A natural question is: who are the validators?
Recall that the validator set for an Arbitrum chain is open and permissionless; anyone can start or stop validating at will. (A useful analogy is to full nodes on an L1 chain.) But we understand that even though anyone can participate, Reddit may want to guarantee that highly reputable nodes are validating their chain. Reddit may choose to validate the chain themselves and/or hire third-party validators.To this end, we have begun building a marketplace for validator-for-hire services so that dapp developers can outsource validation services to reputable nodes with high up-time. We've announced a partnership in which Chainlink nodes will provide Arbitrum validation services, and we expect to announce more partnerships shortly with other blockchain infrastructure providers.
Although there is no requirement that validators are paid, Arbitrum’s economic model tracks validators’ costs (e.g. amount of computation and storage) and can charge small fees on user transactions, using a gas-type system, to cover those costs. Alternatively, a single party such as Reddit can agree to cover the costs of invited validators.
6. Reddit Contract Support
Since Arbitrum contracts and transactions are byte-for-byte compatible with Ethereum, supporting the Reddit contracts is as simple as launching them on an Arbitrum chain.
Minting. Arbitrum Rollup supports hybrid L1/L2 tokens which can be minted in L2 and then withdrawn onto the L1. An L1 contract at address A can make a special call to the EthBridge which deploys a "buddy contract" to the same address A on an Arbitrum chain. Since it's deployed at the same address, users can know that the L2 contract is the authorized "buddy" of the L1 contract on the Arbitrum chain.
For minting, the L1 contract is a standard ERC-20 contract which mints and burns tokens when requested by the L2 contract. It is paired with an ERC-20 contract in L2 which mints tokens based on whatever programmer provided minting facility is desired and burns tokens when they are withdrawn from the rollup chain. Given this base infrastructure, Arbitrum can support any smart contract based method for minting tokens in L2, and indeed we directly support Reddit's signature/claim based minting in L2.
Batch minting. What's better than a mint cookie? A whole batch! In addition to supporting Reddit’s current minting/claiming scheme, we built a second minting design, which we believe outperforms the signature/claim system in many scenarios.
In the current system, Reddit periodically issues signed statements to users, who then take those statements to the blockchain to claim their tokens. An alternative approach would have Reddit directly submit the list of users/amounts to the blockchain and distribute the tokens to the users without the signature/claim process.
To optimize the cost efficiency of this approach, we designed an application-specific compression scheme to minimize the size of the batch distribution list. We analyzed the data from Reddit's previous distributions and found that the data is highly compressible since token amounts are small and repeated, and addresses appear multiple times. Our function groups transactions by size, and replaces previously-seen addresses with a shorter index value. We wrote client code to compress the data, wrote a Solidity decompressing function, and integrated that function into Reddit’s contract running on Arbitrum.
When we ran the compression function on the previous Reddit distribution data, we found that we could compress batched minting data down to to 11.8 bytes per minting event (averaged over a 6-month trace of Reddit’s historical token grants)compared with roughly 174 bytes of on-chain data needed for the signature claim approach to minting (roughly 43 for an RLP-encoded null transaction + 65 for Reddit's signature + 65 for the user's signature + roughly 8 for the number of Points) .
The relative benefit of the two approaches with respect to on-chain call data cost depends on the percentage of users that will actually claim their tokens on chain. With the above figures, batch minting will be cheaper if roughly 5% of users redeem their claims. We stress that our compression scheme is not Arbitrum-specific and would be beneficial in any general-purpose smart contract platform.
8. Benchmarks and costs
In this section, we give the full costs of operating the Reddit contracts on an Arbitrum Rollup chain including the L1 gas costs for the Rollup chain, the costs of computation and storage for the L2 validators as well as the capital lockup requirements for staking.
Arbitrum Rollup is still on testnet, so we did not run mainnet benchmarks. Instead, we measured the L1 gas cost and L2 workload for Reddit operations on Arbitrum and calculated the total cost assuming current Ethereum gas prices. As noted below in detail, our measurements do not assume that Arbitrum is consuming the entire capacity of Ethereum. We will present the details of our model now, but for full transparency you can also play around with it yourself and adjust the parameters, by copying the spreadsheet found here.
Our cost model is based on measurements of Reddit’s contracts, running unmodified (except for the addition of a batch minting function) on Arbitrum Rollup on top of Ethereum.
On the distribution of transactions and frequency of assertions. Reddit's instructions specify the following minimum parameters that submissions should support:
Over a 5 day period, your scaling PoC should be able to handle:
  • 100,000 point claims (minting & distributing points)
  • 25,000 subscriptions
  • 75,000 one-off points burning
  • 100,000 transfers
We provide the full costs of operating an Arbitrum Rollup chain with this usage under the assumption that tokens are minted or granted to users in batches, but other transactions are uniformly distributed over the 5 day period. Unlike some other submissions, we do not make unrealistic assumptions that all operations can be submitted in enormous batches. We assume that batch minting is done in batches that use only a few percent on an L1 block’s gas, and that other operations come in evenly over time and are submitted in batches, with one batch every five minutes to keep latency reasonable. (Users are probably already waiting for L1 finality, which takes at least that long to achieve.)
We note that assuming that there are only 300,000 transactions that arrive uniformly over the 5 day period will make our benchmark numbers lower, but we believe that this will reflect the true cost of running the system. To see why, say that batches are submitted every five minutes (20 L1 blocks) and there's a fixed overhead of c bytes of calldata per batch, the cost of which will get amortized over all transactions executed in that batch. Assume that each individual transaction adds a marginal cost of t. Lastly assume the capacity of the scaling system is high enough that it can support all of Reddit's 300,000 transactions within a single 20-block batch (i.e. that there is more than c + 300,000*t byes of calldata available in 20 blocks).
Consider what happens if c, the per-batch overhead, is large (which it is in some systems, but not in Arbitrum). In the scenario that transactions actually arrive at the system's capacity and each batch is full, then c gets amortized over 300,000 transactions. But if we assume that the system is not running at capacity--and only receives 300,000 transactions arriving uniformly over 5 days-- then each 20-block assertion will contain about 200 transactions, and thus each transaction will pay a nontrivial cost due to c.
We are aware that other proposals presented scaling numbers assuming that 300,000 transactions arrived at maximum capacity and was executed in a single mega-transaction, but according to our estimates, for at least one such report, this led to a reported gas price that was 2-3 orders of magnitude lower than it would have been assuming uniform arrival. We make more realistic batching assumptions, and we believe Arbitrum compares well when batch sizes are realistic.
Our model. Our cost model includes several sources of cost:
  • L1 gas costs: This is the cost of posting transactions as calldata on the L1 chain, as well as the overhead associated with each batch of transactions, and the L1 cost of settling transactions in the Arbitrum protocol.
  • Validator’s staking costs: In normal operation, one validator will need to be staked. The stake is assumed to be 0.2% of the total value of the chain (which is assumed to be $1 per user who is eligible to claim points). The cost of staking is the interest that could be earned on the money if it were not staked.
  • Validator computation and storage: Every validator must do computation to track the chain’s processing of transactions, and must maintain storage to keep track of the contracts’ EVM storage. The cost of computation and storage are estimated based on measurements, with the dollar cost of resources based on Amazon Web Services pricing.
It’s clear from our modeling that the predominant cost is for L1 calldata. This will probably be true for any plausible rollup-based system.
Our model also shows that Arbitrum can scale to workloads much larger than Reddit’s nominal workload, without exhausting L1 or L2 resources. The scaling bottleneck will ultimately be calldata on the L1 chain. We believe that cost could be reduced substantially if necessary by clever encoding of data. (In our design any compression / decompression of L2 transaction calldata would be done by client software and L2 programs, never by an L1 contract.)
9. Status of Arbitrum Rollup
Arbitrum Rollup is live on Ethereum testnet. All of the code written to date including everything included in the Reddit demo is open source and permissively licensed under the Apache V2 license. The first testnet version of Arbitrum Rollup was released on testnet in February. Our current internal version, which we used to benchmark the Reddit contracts, will be released soon and will be a major upgrade.
Both the Arbitrum design as well as the implementation are heavily audited by independent third parties. The Arbitrum academic paper was published at USENIX Security, a top-tier peer-reviewed academic venue. For the Arbitrum software, we have engaged Trail of Bits for a security audit, which is currently ongoing, and we are committed to have a clean report before launching on Ethereum mainnet.
10. Reddit Universe Arbitrum Rollup Chain
The benchmarks described in this document were all measured using the latest internal build of our software. When we release the new software upgrade publicly we will launch a Reddit Universe Arbitrum Rollup chain as a public demo, which will contain the Reddit contracts as well as a Uniswap instance and a Connext Hub, demonstrating how Community Points can be integrated into third party apps. We will also allow members of the public to dynamically launch ecosystem contracts. We at Offchain Labs will cover the validating costs for the Reddit Universe public demo.
If the folks at Reddit would like to evaluate our software prior to our public demo, please email us at [email protected] and we'd be more than happy to provide early access.
11. Even more scaling: Arbitrum Sidechains
Rollups are an excellent approach to scaling, and we are excited about Arbitrum Rollup which far surpasses Reddit's scaling needs. But looking forward to Reddit's eventual goal of supporting hundreds of millions of users, there will likely come a time when Reddit needs more scaling than any Rollup protocol can provide.
While Rollups greatly reduce costs, they don't break the linear barrier. That is, all transactions have an on-chain footprint (because all calldata must be posted on-chain), albeit a far smaller one than on native Ethereum, and the L1 limitations end up being the bottleneck for capacity and cost. Since Ethereum has limited capacity, this linear use of on-chain resources means that costs will eventually increase superlinearly with traffic.
The good news is that we at Offchain Labs have a solution in our roadmap that can satisfy this extreme-scaling setting as well: Arbitrum AnyTrust Sidechains. Arbitrum Sidechains are similar to Arbitrum Rollup, but deviate in that they name a permissioned set of validators. When a chain’s validators agree off-chain, they can greatly reduce the on-chain footprint of the protocol and require almost no data to be put on-chain. When validators can't reach unanimous agreement off-chain, the protocol reverts to Arbitrum Rollup. Technically, Arbitrum Sidechains can be viewed as a hybrid between state channels and Rollup, switching back and forth as necessary, and combining the performance and cost that state channels can achieve in the optimistic case, with the robustness of Rollup in other cases. The core technical challenge is how to switch seamlessly between modes and how to guarantee that security is maintained throughout.
Arbitrum Sidechains break through this linear barrier, while still maintaining a high level of security and decentralization. Arbitrum Sidechains provide the AnyTrust guarantee, which says that as long as any one validator is honest and available (even if you don't know which one will be), the L2 chain is guaranteed to execute correctly according to its code and guaranteed to make progress. Unlike in a state channel, offchain progress does not require unanimous consent, and liveness is preserved as long as there is a single honest validator.
Note that the trust model for Arbitrum Sidechains is much stronger than for typical BFT-style chains which introduce a consensus "voting" protocols among a small permissioned group of validators. BFT-based protocols require a supermajority (more than 2/3) of validators to agree. In Arbitrum Sidechains, by contrast, all you need is a single honest validator to achieve guaranteed correctness and progress. Notice that in Arbitrum adding validators strictly increases security since the AnyTrust guarantee provides correctness as long as any one validator is honest and available. By contrast, in BFT-style protocols, adding nodes can be dangerous as a coalition of dishonest nodes can break the protocol.
Like Arbitrum Rollup, the developer and user experiences for Arbitrum Sidechains will be identical to that of Ethereum. Reddit would be able to choose a large and diverse set of validators, and all that they would need to guarantee to break through the scaling barrier is that a single one of them will remain honest.
We hope to have Arbitrum Sidechains in production in early 2021, and thus when Reddit reaches the scale that surpasses the capacity of Rollups, Arbitrum Sidechains will be waiting and ready to help.
While the idea to switch between channels and Rollup to get the best of both worlds is conceptually simple, getting the details right and making sure that the switch does not introduce any attack vectors is highly non-trivial and has been the subject of years of our research (indeed, we were working on this design for years before the term Rollup was even coined).
12. How Arbitrum compares
We include a comparison to several other categories as well as specific projects when appropriate. and explain why we believe that Arbitrum is best suited for Reddit's purposes. We focus our attention on other Ethereum projects.
Payment only Rollups. Compared to Arbitrum Rollup, ZK-Rollups and other Rollups that only support token transfers have several disadvantages:
  • As outlined throughout the proposal, we believe that the entire draw of Ethereum is in its rich smart contracts support which is simply not achievable with today's zero-knowledge proof technology. Indeed, scaling with a ZK-Rollup will add friction to the deployment of smart contracts that interact with Community Points as users will have to withdraw their coins from the ZK-Rollup and transfer them to a smart contract system (like Arbitrum). The community will be best served if Reddit builds on a platform that has built-in, frictionless smart-contract support.
  • All other Rollup protocols of which we are aware employ a centralized operator. While it's true that users retain custody of their coins, the centralized operator can often profit from censoring, reordering, or delaying transactions. A common misconception is that since they're non-custodial protocols, a centralized sequencer does not pose a risk but this is incorrect as the sequencer can wreak havoc or shake down users for side payments without directly stealing funds.
  • Sidechain type protocols can eliminate some of these issues, but they are not trustless. Instead, they require trust in some quorum of a committee, often requiring two-third of the committee to be honest, compared to rollup protocols like Arbitrum that require only a single honest party. In addition, not all sidechain type protocols have committees that are diverse, or even non-centralized, in practice.
  • Plasma-style protocols have a centralized operator and do not support general smart contracts.
13. Concluding Remarks
While it's ultimately up to the judges’ palate, we believe that Arbitrum Rollup is the bakeoff choice that Reddit kneads. We far surpass Reddit's specified workload requirement at present, have much room to optimize Arbitrum Rollup in the near term, and have a clear path to get Reddit to hundreds of millions of users. Furthermore, we are the only project that gives developers and users the identical interface as the Ethereum blockchain and is fully interoperable and tooling-compatible, and we do this all without any new trust assumptions or centralized components.
But no matter how the cookie crumbles, we're glad to have participated in this bake-off and we thank you for your consideration.
About Offchain Labs
Offchain Labs, Inc. is a venture-funded New York company that spun out of Princeton University research, and is building the Arbitrum platform to usher in the next generation of scalable, interoperable, and compatible smart contracts. Offchain Labs is backed by Pantera Capital, Compound VC, Coinbase Ventures, and others.
Leadership Team
Ed Felten
Ed Felten is Co-founder and Chief Scientist at Offchain Labs. He is on leave from Princeton University, where he is the Robert E. Kahn Professor of Computer Science and Public Affairs. From 2015 to 2017 he served at the White House as Deputy United States Chief Technology Officer and senior advisor to the President. He is an ACM Fellow and member of the National Academy of Engineering. Outside of work, he is an avid runner, cook, and L.A. Dodgers fan.
Steven Goldfeder
Steven Goldfeder is Co-founder and Chief Executive Officer at Offchain Labs. He holds a PhD from Princeton University, where he worked at the intersection of cryptography and cryptocurrencies including threshold cryptography, zero-knowledge proof systems, and post-quantum signatures. He is a co-author of Bitcoin and Cryptocurrency Technologies, the leading textbook on cryptocurrencies, and he has previously worked at Google and Microsoft Research, where he co-invented the Picnic signature algorithm. When not working, you can find Steven spending time with his family, taking a nature walk, or twisting balloons.
Harry Kalodner
Harry Kalodner is Co-founder and Chief Technology Officer at Offchain Labs where he leads the engineering team. Before the company he attended Princeton as a Ph.D candidate where his research explored economics, anonymity, and incentive compatibility of cryptocurrencies, and he also has worked at Apple. When not up at 3:00am writing code, Harry occasionally sleeps.
submitted by hkalodner to ethereum [link] [comments]

While everyone's still arguing about catering to nolifers/streamers

It's probably time to make a fuss about the turning circle stat.
It is one of the most frustratingly pointless stats, only punishing players that aren't in the know. Or without the knowledge to setup DPI profiles. Or those who really just cannot be fucking bothered (Like me, for example).
That's coming from someone who played Arma 2 mod and standalone DayZ at its peak, and was happy to spend plenty of time fiddling with settings and config files so the damn game ran properly, and to maximize visibility.
I still see GPU_MaxFramesAhead=1; GPU_DetectedFramesAhead=0; and the skyrocketing fps/visibility that came with it in my dreams.
I would bet a good amount of money that a sizeable portion of new players that joined because of seeing the game played on twitch then quit, are quitting because they feel they've plateaued at a lower skill level than they should be.
A huge factor in that will be aim.
Not counting flea market Russian tycoon simulator and inventory tetris, Tarkov is a shooter; ignoring the casual/hardcore/realistic arguments that's pretty set in stone, or at least I hope so.
I've sunk hundreds of hours into this game, and I still don't feel like I can reliably track my targets if they're moving quickly or if i'm flicking to a target at an unexpected angle, and that's entirely because I, and the majority of players have no baseline sensitivity to develop muscle memory on.
It's constantly being changed.
You can learn good habits like crosshair placements, learn hidey hole spots, prefire etc. but a lot of pvp in tarkov are those peripheal vision, just walked around the corner fights that are announced with a mid sentence "oh shit!"
Then someones dead, someone's got a beefy armour repair bill, someones popping pain pills, my dickhead "friend" is taking my kills dogtags for his LedX trade up, and Tarkov is 120 rounds of BP 5.45 lighter despite only 7 hits between all five of the involved parties.
The fifth guy of course didn't mag dump like everyone else because he'd buggered off to loot a stash without telling us a few minutes earlier.
Meta sweat goblins are running the most optimal ergo/roubles efficiency weapons, have charted the optimal ammunition types, have excel spreadsheets to determine loot efficiency despite having a 25 graphics card bitcoin farm, and the only reason they're not manually packing their mags bullet by bullet anymore is because the servers commit sudoku when they do.
Sure not every thicc boy will have DPI profiles set up, but only the most deluded of "Low levels should be allowed makarovs with sports hunting rounds only," would be upset about this element of frustration just being removed.
I get what the intention was, armour is cumbersome.
The ergo and movement speed changes are solid concepts and regardless of your stance on it, the logic is there, but the turning sensitivity is something completely by-passable by someone with a little bit too much time to fiddle with Razr Synapse.
I really can't see why the stat should remain. Other than turning it off might break the servers again.
submitted by Anaferomeni to EscapefromTarkov [link] [comments]

Cryptarbitrage’s Deribit Spreadsheets Calculation Tools

Perpetuals, Futures, and Options can present quite a steep learning curve, fear not though as we have an incredible collection of Google Sheets and Excel Spreadsheets to help both the basic as well as most advanced users! We can also strongly recommend reading our Educational and Market Research articles as many traders find them to be invaluable resources.

One of our talented Community Managers, Cryptarbitrage, has created and maintains to the best of his ability a series of tools to both help Deribit users learn more about BTC & ETH Perpetuals, Futures, and Options as well support more advanced traders increasing technical needs.
A short introduction by Cryptarbitrage:
"Although I was aware of options beforehand I only started properly researching them in early 2018 after I discovered the Bitcoin options on Deribit. I do not need much encouragement to build a spreadsheet for something so quickly set about created an Excel sheet that would show me the profit and loss of any options position I entered.
This was a great way to learn all the profit and loss formulas for each type of option as well as how different option combinations interacted with each other. As soon as this sheet was complete I was building positions I still didn’t even know the proper names for so was very much learning by doing. It was immediately obvious to me though that options were the type of instruments I wanted to trade.
After a few months and once I’d done some more reading and was more confident I actually knew what I was talking about I began creating shareable versions in google sheets and sharing them with the Deribit community."
Feel free to ask for some help or guidance in our English Telegram Community.
Cryptarbitrage’s Twitter: https://twitter.com/cryptarbitrage
Cryptarbitrage’s Telegram: u/Cryptarbitrage
English Telegram Community: https://t.me/deribit

Deribit's Position Builder
Link: pb.deribit.com
It is invaluable to be able to see the potential profit/loss, implied volatility of a single or multiple positions quickly, and adhoc. This allows you to check the results of either simulated positions, the live positions of your account, or a combination of these all across multiple instruments including Perpetuals, Futures, and Options at the same time.
The Position Builder can be used to analyze the results of either existing or simulated results. As it uses market data from Deribit it provides a quick tool to check the results before adding positions into a portfolio.
Development Credit to the core Deribit development team

Scenario Risk Analysis “Maximum Pain” - Excel Spreadsheet
Link: https://drive.google.com/file/d/1ANS1CgApJCDTX5ZjUwO_fegU7Z-QVSdt/view
A resource to visualize the Open Interest at the present moment as well as the current price of maximum pain for option buyers.

Basic Resource Tools

Simple Perpetual/Future Position Size Calculator - Google Sheet
Google Sheet Link: https://docs.google.com/spreadsheets/d/1gQh11IJgb4HOt8B-HDWG_HX9hta1832piynuI4k-v-A/edit?usp=sharing
This spreadsheet allows you, in both BTC, ETH, and USD, to provide the amount you are willing to risk and to determine the relative size of the position you should take to achieve this.

Simple Options Profit/Loss - Google Sheet
Google Sheet Link: https://docs.google.com/spreadsheets/d/1FRbKfvlr721ZIyPNsLwI0_WtGhuvdWfWLC-UOE1Yi1A/edit?usp=sharing
A means to learn how to manually create your own options mathematics which can be applied across your own spreadsheets, programs, and possibly automated trading tools.

Simple Perpetual/Futures Liquidation Price - Google Sheet
Google Sheet Link: https://docs.google.com/spreadsheets/d/1tcb-NzRV_ATDlkKi8LqTorpGYQyv0DQgj9W_AbIFJ2M/edit?usp=sharing
An easy and quick to use tool to assess your estimated liquidation price, present Leverage as well as expected Maintenance Margin requirements.

Deribit Margin Requirement Calculations - Google Sheet
Google Sheet Link: https://docs.google.com/spreadsheets/d/1xSb8Y_nVF1-8ICZHfQNjDWaeqBjqQfGzrYR7Ymgvi84/edit?usp=sharing
A simple tool to understand and visualize both your Initial Margin (IM) and Maintenance Margin (MM) requirements for Perpetuals, Futures, and Options.

Simple Leverage Examples - Google Sheet
Google Sheet Link: https://docs.google.com/spreadsheets/d/1CIcEq-0V2LeNeMos68MdMN-DqEDvKVclcqc5LVhFSAo/edit#gid=0
A quick and easy way to understand how leverage works on Deribit!


Education

Introduction to Cryptocurrency Options (BTC & ETH)
Link: https://insights.deribit.com/exchange-updates/introduction-to-bitcoin-options-profit-loss/
An introduction specifically to BTC Options, which can be applied to ETH Options, describing the basics of options and the specifics of cryptocurrency options on Deribit.
Introduction to Leverage and Margin
Link: https://insights.deribit.com/education/introduction-to-leverage-and-margin/
An introduction to Leverage and Margin on the Deribit Exchange.
Hedging the USD value of your BTC or ETH on Deribit
Link: https://insights.deribit.com/education/hedging-usd-value-by-shorting-1x/
An introduction as to how to peg your present cryptocurrency holdings (BTC or ETH) at the present market value of BTC/USD or ETH/USD for each asset on Deribit.
Comprehensive Resource Tools
Comprehensive Options Profit/Loss - Google Sheet
Google Sheet Link: https://docs.google.com/spreadsheets/d/1vWn9f7kJ73ufuP8qa05Ct76DO58WkwyXVsGcUP2fkMY/edit#gid=1852961659
Learn how to create advanced multi-leg option positions as well as test possible edge cases or specific scenarios.

Market Data

If you are a retail trader and would like to pull historical data we recommend you use our API. If you would like data prepared or more specific data we recommend taking a look at our data providing partners.
Deribit Perpetual Historical Funding Rates - Google Sheet
Google Sheet Link: https://docs.google.com/spreadsheets/d/1XHLiXHdFWKeXBc2WaqCp5-amcHzAyuorp7bW-Y8XfXI/edit?usp=sharing
A simple sheet to either manually check or use as your data source for funding rates across both BTC Perpetuals and ETH Perpetuals on Deribit.

Excel Tools:

Live Deribit Trading Data - Excel Spreadsheet
Link: https://insights.deribit.com/exchange-updates/live-data-in-excel/
A fully-featured Excel spreadsheet that can either serve as your central resource to pull live data from the Deribit Exchange or can form the base of building your own advanced spreadsheet.
Pull Old Data with an Excel Spreadsheet
Link: https://docs.google.com/document/d/1e_cWT2XZ_OXuckobcTMJU4lLI72zrzsdRkZWY-xmghE/edit
This can be appended to the “Live Deribit Trading Data - Excel Spreadsheet” or included in your very own to pull historical data.
Pull Options’ Greeks with an Excel Spreadsheet
Link: https://docs.google.com/document/d/1zaj1YIP6k3sQuG2QSqzkT77rxqdZDTZ5UiJCnqScgPU/edit
This can be appended to the “Live Deribit Trading Data Excel Spreadsheet” or included in your very own spreadsheet.
Pull Open Interest with an Excel Spreadsheet
Link: https://docs.google.com/document/d/1SRRAAmDj8c75AzDwqvDO4i1dCnXQMRLC_C6wUMLAo-E/edit
This can pull the present Open Interest of an instrument using the aforementioned “Live Deribit Trading Data - Excel Spreadsheet” or demonstrate the functionality for you to incorporate in your own spreadsheet.
--------------------------------------------------------------------------------------------------------------------------
Credit must go to Cryptarbitrage for the creation of all Google Sheets and extended Code Snippets for Excel and Lennard for the creation of the original Excel Spreadsheet.
June - 2020
submitted by ElliotP_DeribitCM to DeribitExchange [link] [comments]

A made a Cryptocurrency tracking spreadsheet complete with live crypto price updates, moon math, and a full history of your Portfolio and trading performance (fixed).

A made a Cryptocurrency tracking spreadsheet complete with live crypto price updates, moon math, and a full history of your Portfolio and trading performance (fixed).
I have posted this previously however since then coinmarketcap have changed their api. This version has a workaround for that - with the downside that it takes much longer to fetch price data. You will need to be patient when opening the file and when you press the price refresh button.
This is a spreadsheet that I have developed for myself gradually over the last couple years. I have found it very helpful for keeping track of my bitcoin holdings (great for tax purposes). No need to trust third party apps to keep your personal information - track it yourself.
There is a lot in here including;
Automatically updates prices from coinmarketcap. The top 200 coins included. Just select which ones you want to track by typing in the name.
You can even choose your local Fiat currency and get live conversion rates for any country.
https://preview.redd.it/zmt33x8q6yo41.png?width=1536&format=png&auto=webp&s=734fc117610d6eaa3bcc10670241fbf436e902b1
You don't need to record details of every trade. Just keep track of your crypto purchases (from fiat) and what coins you currently hold. The spreadsheet will calculate the rest and keep a record of how your portfolio and holdings have changed over time (it logs this data every time you save the sheet)

https://preview.redd.it/ha3gel8r6yo41.png?width=1380&format=png&auto=webp&s=7bdbd351b866ff70f160810f2515a32953a5249b
https://preview.redd.it/mzkt96js6yo41.png?width=602&format=png&auto=webp&s=45fefffe6f92f2ad4fefac67320ffe3454a7155b
I find this very handy to see if your trading is actually profitable compared to the HODL method.

https://preview.redd.it/ggg2utxu6yo41.png?width=929&format=png&auto=webp&s=010ab01b6424d525b1913a3d27acdd499cda25b8
Oh yes and there are plenty of 'moon math' and analytics to see how bitcoin is trending. This includes a full history of bitcoins price which updates every time you open the sheet.

https://preview.redd.it/upyy3qzv6yo41.png?width=1455&format=png&auto=webp&s=29db32fa7e6ce9156d27cea99afa35ab6fec2950
This version has some bug fixes and a few new features including a 'Stock to flow' price prediction model;
https://preview.redd.it/3vx5tq3x6yo41.png?width=767&format=png&auto=webp&s=e5d43c1394e979ff9069b9f9dbb40038bdee514a
free download from here. Instructions inside. You will need macros enabled if you want it to do the fancy stuff.
https://www.dropbox.com/s/yjba4y6qdsye2qo/Cryptoprices11%20-%20for%20others.xlsm?dl=0
Let me know if you have any issues.
Edit: there seems to be a problem where there is a link to an old version of the spreadhseet. to fix; Open the workbook and go to Data>edit links https://imgur.com/yRk5juh
Then press 'change source' and select the same excel sheet that you have open (wherever you have it saved locally). https://imgur.com/pBJyZM9
submitted by Fly115 to CryptoCurrency [link] [comments]

A made a Bitcoin tracking spreadsheet complete with live crypto price updates, moon math, and a full history of your Portfolio and trading performance (fixed).

A made a Bitcoin tracking spreadsheet complete with live crypto price updates, moon math, and a full history of your Portfolio and trading performance (fixed).
I have posted this previously however since then coinmarketcap have changed their api. This version has a workaround for that - with the downside that it takes much longer to fetch price data. You will need to be patient when opening the file and when you press the price refresh button.
This is a spreadsheet that I have developed for myself gradually over the last couple years. I have found it very helpful for keeping track of my bitcoin holdings (great for tax purposes). No need to trust third party apps to keep your personal information - track it yourself.
There is a lot in here including;
Automatically updates prices from coinmarketcap. The top 200 coins included. Just select which ones you want to track by typing in the name.
You can even choose your local Fiat currency and get live conversion rates for any country.
https://preview.redd.it/f9w12ene5yo41.png?width=1536&format=png&auto=webp&s=be4af166ad3c3f22ecddac47084b8de358400bf0
No need to record details of every trade. Just keep track of your crypto purchases (from fiat) and what coins you currently hold. The spreadsheet will calculate the rest and keep a record of how your portfolio and holdings have changed over time (it logs this data every time you save the sheet)
https://preview.redd.it/uob5u0sf5yo41.png?width=1380&format=png&auto=webp&s=f24ed6e1a342c97844f9b7f784b03839f2b529e2
https://preview.redd.it/ql1yqsvg5yo41.png?width=602&format=png&auto=webp&s=ebfd082edb817a1d6b614fe127aa685d3414f65c
I find this very handy to see if your trading is actually profitable compared to the HODL method.

https://preview.redd.it/gwagpfth5yo41.png?width=929&format=png&auto=webp&s=cbb9177ff457efa598dc92a61d346ddc38c296cf
There are plenty of 'moon math' and analytics to see how bitcoin is trending. This includes a full history of bitcoins price which updates every time you open the sheet.

https://preview.redd.it/ewafzx4j5yo41.png?width=1455&format=png&auto=webp&s=1b2079600be53d855573707d13822323a9fdacee
This version has some bug fixes and a few new features including a 'Stock to flow' price prediction model;
https://preview.redd.it/g145x5u16yo41.png?width=767&format=png&auto=webp&s=180321b1b8641da48ffeb1de5cfb982d1fccf0da
free download from below. Instructions inside. You will need macros enabled if you want it to do the fancy stuff
https://www.dropbox.com/s/yjba4y6qdsye2qo/Cryptoprices11%20-%20for%20others.xlsm?dl=0
Edit: there seems to be a problem where there is a link to an old version of the spreadhseet. to fix; Open the workbook and go to Data>edit links https://imgur.com/yRk5juh
Then press 'change source' and select the same excel sheet that you have open (wherever you have it saved locally). https://imgur.com/pBJyZM9
submitted by Fly115 to Bitcoin [link] [comments]

How is blockFi going to handle trading?

Since most people bought bitcoin somewhere else and moved it to blockfi, how is blockfi handling the gains/loss aspect of the trades. Are they reporting to the IRS? Also outside of the transactions history that is already provided, are they going to give a formal document? I am just trying to figure out if I should have an excel spreadsheet that tracks this or not.
submitted by artistmattem to blockfi [link] [comments]

TRUE historical data on yearly lows (correcting repetitive historical false information spread on reddit and twitter)

Recently, wrong historical data on the alleged Bitcoin yearly lows could be repetitively read in ill-researched or "blindly copy-pasted" posts and tweets, e.g. falsely claiming a yearly low for 2013 of $65, where $13 is the correct value (wrong by a factor of 5)!
Here is the correct data:
TRUE yearly lows (first historically recorded trade occurred at MtGox exchange on 17th July 2010; bitstamp exchange started operation on 13 Sep 2011*):
*not included: Bitcoin prices of around $0.003 on Bitcoin USD markets recorded since 25th April 2010, consistent with famous two Bitcoin pizzas from 22nd May 2010 worth $30 for 10,000 BTC.
Yearly absolute lows (just omitting obvious implausible data flaws) - not recommended because short outliers of very low trade volumes can bias the view of the real market situation:
Yearly lows of daily weighted averages - more useful because short outliers with very low volumes are not biasing the statistics:
  • 2010: $0.05 (MtGox, 17th & 24th & 25th & 26th July)
  • 2011: $0.29 (MtGox, 4th January)
  • 2011: $2.24 (bitstamp, 21st October)
  • 2012: $4.33 (bitstamp, 19th February)
  • 2013: $13.01 (bitstamp, 1st January)
  • 2014: $305.81 (bitstamp, 5th October)
  • 2015: $189.84 (bitstamp, 14th January)
  • 2016: $370.21 (bitstamp, 3rd February)
  • 2017: $783.46 (bitstamp, 12th January)
  • 2018: $3171.72 (bitstamp, 15th December)
  • 2019: $3365.06 (bitstamp, 7th February)
  • 2020: <= $7030.21 (bitstamp, 2nd January)
Change rates:
  • 2011: x 5.8 (+480%)
  • 2012: x 14.9 (+1390%)
  • 2013: x 3.0 (+200%)
  • 2014: x 23.5 (+2250%)
  • 2015: x 0.6 (-40%)
  • 2016: x 2.0 (+100%)
  • 2017: x 2.1 (+110%)
  • 2018: x 4.0 (+300%)
  • 2019: x 1.1 (+10%)
  • 2020: <= x 2.1 (<= +110%)
How to do this yourself:
Example for 2013:
https://bitcoincharts.com/charts/bitstampUSD#rg60zczsg2013-01-01zeg2013-12-31ztgSzm1g10zm2g25zv
Click on "Load raw data" below the chart, copy-paste to spreadsheet like Libre Calc or MS Excel or Google documents, apply "min" function on the column of daily lows or daily weighted averages.
For year 2013 on bitstamp, the yearly low was reached on 1st January 2013: - Daily absolute low = $12.77 - Daily weighted average = $13.01
submitted by Amichateur to Bitcoin [link] [comments]

Why we won't have a long term bear market, and how to systematically pick your future investments in crypto

With so much uncertainty right now it would be a good time to take some time to go over what happened recently and how to invest moving foward. We've seen a peak bubble at around 850 billion total market cap in the first week of January, consolidated down to $750 billion and have now just experienced a 40% correction.

What's happening now and how bad will it get?

First of all you should realize that there is a January Dip that happens every year, when we see a roughly 20-30% decline around mid January. This year its been much more severe though for several additional factors that have compounded on top.
Different theories exist on why this happens (its actually the mirror opposite of the "January Effect" that happens in the US stock market), but the two major theories are:
1) Asian markets pull into fiat because of Asian New Year spending needs
2) People in the US sell in January to defer their capital gains tax liability an extra year
While this cyclic event has lead to a healthy correction in the last few years, this year we got these new factors making more fear as well:
So in essence we got a storm of scary news along with the usual cyclic downturn. Currently I don't see this as being a systematic crash like Mt.Gox was that would lead to a long term bear market because the fundamental ecosystem is still intact, and I suspect that after about a month we should consolidate around a new low. All the exchanges are still operational and liquid, and there is no breakdown in trust nor uncertainty whether you'll be able to cash out. What range the market trades in will all depend how Bitcoin does, right now we've already broken below 10K but I'm seeing a lot of support at around $8000, which is roughly where the long term MA curve settles. We don't know how bad it will get or what the future will bring, but as of right now we shouldn't be in a bear market yet.
What should you do if you recently entered the market?
If you did buy in the last few months at or near ATH, the very worst thing you can do now is sell in panic and lose your principal. You shouldn't have more money in crypto than you can afford to lose, so it shouldn't be a problem to wait. You have to realize that 30% corrections in crypto are relatively common, just last fall we had a 40% flash correction over more China fears. Unless there is a systematic breakdown like we had during Mt.Gox, the market always recovers.
The other worst thing you can do is unload into Tether as your safety net. If there is one thing that could actually cause a long term destruction of trust within the cryptocurrency investment ecosystem, its Tether having a run up on their liabilities and not having enough reserve to cover the leverage. It would not only bring down exchanges but lead to years of litigation and endless media headlines that will scare off everybody from putting fiat in. I don't know when the next Mt.Gox meltdown will occur but I can almost guarantee it will involve Tether. So stay away from it.
What should long term investors do?
For long term holders a good strategy to follow each year is to capture profit each December and swallow the capital gains taxation liability, park a reserve of fiat at Gemini (whose US dollar deposits are FDIC-insured) and simply wait till around late January to early February to re-enter the market at a discount and hold all year until next December. You can keep a small amount in core coins in order to trade around various Q1 opportunities you anticipate. Others may choose to simply do nothing and just keep holding throughout January which is also a perfectly fine strategy. The cyclical correction usually stabilizes toward late January and early February, then we see a rise in March and generally are recovered by end of April. Obviously this decision whether to sell in December to profit on the dip and pay tax liability or to just hold will depend on your individual tax situation. Do your own math sometime in November and follow suit.
Essentially revaluate your positions and trim your position sizes if you don't feel comfortable with the losses.

How to construct your portfolio going forward

Rather than seeing the correction as a disaster see it as a time to start fresh. If you have been FOMO-ing into bad cryptos and losing money now is a time to start a systematic long term approach to investing rather than gambling.
Follow a methodology for evaluating each cryptocurrency
Memes and lambo dreams are fun and all, but I know many of you are investing thousands of dollars into crypto, so its worth it to put some organized thought into it as well. I can't stress enough how important it is to try and logically contruct your investment decisions. If you follow a set methodology, a checklist and template you will be able to do relative comparisons between cryptocurrencies, to force yourself to consider the negatives and alternative scenarios and also sleep comfortably knowing you have a sound basis for your investment decisions (even if they turn out to be wrong).
There is no ideal or "correct" methodology but I can outline mine:
1) Initial information gathering and filtering
Once I identify something that looks like a good potential investment, I first go to the CoinMarketCap page for that symbol and look at the website and blockchain explorer.
  • Critically evaluate the website. This is the first pass of the bullshit detector and you can tell from a lot from just the website whether its a scam. If it uses terms like "Web 4.0" or other nonsensical buzzwords, if its unprofessional and has anonymous teams, stay away. Always look for a roadmap, compare to what was actually delivered so far. Always check the team, try to find them on LinkedIn and what they did in the past.
  • Read the whitepaper or business development plan. You should fully understand how this crypto functions and how its trying to create value. If there is no use case or if the use case does not require or benefit from a blockchain, move on. Look for red flags like massive portions of the float being assigned to the founders of the coin, vague definition of who would use the coin, anonymous teams, promises of large payouts...etc
  • Check the blockchain explorer. How is the token distribution across accounts? Are the big accounts holding or selling? Which account is likely the foundation account, which is the founders account?
  • Read the subreddit and blogs for the cryptocurrency and also evaluate the community. Try to figure out exactly what the potential use cases are and look for sceptical takes. Look at the Github repos, does it look empty or is there plenty of activity?
2) Fill out an Investment Checklist
I have a checklist of questions that I find important and as I'm researching a crypto I save little snippets in Evernote of things that are relevant to answering those questions:
  • What is the problem or transactional inefficiency the coin is trying to solve?
  • What is the Dev Team like? What is their track record? How are they funded, organized?
  • Who is their competition and how big is the market they're targeting? What is the roadmap they created?
  • What current product exists?
  • How does the token/coin actually derive value for the holder? Is there a staking mechanism or is it transactional?
  • What are the weaknesses or problems with this crypto?
3) Create some sort of consistent valuation model/framework, even if its simple
I have a background in finance so I like to do Excel modeling. For those who are interested in that, this article is a great start and also Chris Burniske has a great blog about using Quantity Theory of Money to build an equivalent of a DCF analysis for crypto.
Here is an Excel file example of OMG done using his model. You can download this and play around with it yourself, see how the formulas link and understand the logic.
Once you have a model set up the way you like in Excel you can simply alter it to account for various float oustanding schedule and market items that are unique to your crypto, and then just start plugging in different assumptions. Think about what is the true derivation of value for the coin, is it a "dividend" coin that you stake within a digital economy and collect fees or is it a currency? Use a realistic monetary velocity (around 5-10 for currency and around 1-2 for staking) and for the discount rate use at least 3x the long term return of a diversified equity fund.
The benefit is that this forces you to think about what actually makes this coin valuable to an actual user within the digital economy its participating in and force you to think about the assumptions you are making about the future. Do your assumptions make sense? What would the assumptions have to be to justify its current price? You can create different scenarios in a matrix (optimistic vs. pessimistic) based on different assumptions for risk (discount rate) and implementation (adoption rates).
If you don't understand the above thats perfectly fine, you don't need to get into full modeling or have a financial background. Even a simple model that just tries to derive a valuation through relative terms will put you above most crypto investors. Some simple valuation methods that anyone can do
  • Metcalfe's Law which states that the value of a network is proportional to the square of the number of connected users of the system (n2). So you can compare various currencies based on their market cap and square of active users or traffic.
  • Another easy one is simply looking at the total market for the industry that the coin is supposedly targeting and comparing it to the market cap of the coin. Think of the market cap not only with circulating supply like its shown on CMC but including total supply. For example the total supply for Dentacoin is 1,841,395,638,392, and when multiplied by its price in early January we get a market cap that is actually higher than the entire industry it aims to disrupt: Dentistry.
  • If its meant to be just used as just a currency: Take a look at the circulating supply and look at the amount that is in cold storage or set to be released/burned. Most cryptos are deflationary so think about how the float schedule will change over time and how this will affect price.
Once you have a model you like set up, you can compare cryptos against each other and most importantly it will require that you build a mental framework within your own mind on why somebody would want to own this coin other than to sell it to another greater fool for a higher price. Modeling out a valuation will lead you to think long term and think about the inherent value, rather than price action.
Once you go through this 3-step methodology, you'll have a pretty good confidence level for making your decision and can comfortably sit back and not panic if some temporary short term condition leads to a price decrease. This is how "smart money" does it.
Think about your portfolio allocation
You should think first in broad terms how you allocate between "safe" and "speculative" cryptos.
For new investors its best to keep a substantial portion in what would be considered largecap safe cryptos, primarily BTC, ETH, LTC. I personally consider XMR to be safe as well. A good starting point is to have between 50-70% of your portfolio in these safe cryptocurrencies. As you become more confident and informed you can move your allocation into speculative small caps.
You should also think in terms of segments and how much of your total portfolio is in each segment:
  • Core holdings - BTC, Ethereum, LTC...etc
  • Platform segment - Ethereum, NEO, Ark...etc
  • Privacy segment - Monero, Zcash, PivX..etc
  • Finance/Bank settlement segment - Ripple, Stellar...etc
  • Enterprise Blockchain solutions segment -VeChain, Walton, WABI...etc
  • Promising/Innovative Tech segment - Raiblocks, IOTA, Cardano...etc
You should also think about where we are in the cycle, as now given so much uncertaintly its probably best to stay heavily in core holdings and pick up a few coins within a segment you understand well. If you don't understand how enterprise solutions work or how the value chain is built through corporations, don't invest in the enteprise blockchain solutions segment. If you are a technie who loves the technology behind Cardano or IOTA, invest in that segment.
Think of your "circle of competence"
This is actually a term Buffet came up with, it refers to your body of knowledge that allows you to evaluate an investment. Think about what you know best and consider investing in those type of coins. If you don't know anything about how supply chains functions, how can you competently judge whether VeChain or WaltonChain will achieve adoption?
This where your portfolio allocation also comes into play. You should diversify but really shouldn't be in much more than around 12 cryptos, because you simply don't have enough competency to accurately access the risk across every segment and for every type of crypto you come across. If you had over 20 different cryptos in your portfolio you should probably think about consolidating to a few sectors you understand well.
Continually educate yourself about the technology and markets
If you aren't already doing it: Read a bit each day about cryptocurrencies. There are decent Youtubers that talk about the market side of crypto, just avoid those that hype specific coins and look for more sceptical ones like CryptoInvestor. If you don't understand how the technology works and what the benefits of a blockchain are or how POS/POW works or what a DAG is or how mining actually works, learn first. If you don't care about the technology or find reading about it tedious, you shouldn't invest in this space at all.

Summing it up

I predicted a few days ago that we would have a major correction in 2018 specifically in the altcoins that saw massive gains in Decemebeearly January, and it seems we've already had a pretty big one. I don't think we'll have a complete meltdown like some are predicting, but some more pain may be incoming.
Basically take this time to think about how you can improve your investment style and strategy. Make a commitment to value things rather than chasing FOMO, and take your time to make a decision. Long term investment will grant you much more returns as will a systematic approach.
Take care and have fun investing :)
Edit March 2018: Lol looking back I'm regretting starting the title with "Why we won't have a long term bear market" now, I was more karma whoring with that catchy title than anything. We recovered up to 11K from this post, but then crashed again hard later in February-March because of a slew of reasons from Tether subpeona to unforseen regulatory issues.
submitted by arsonbunny to CryptoCurrency [link] [comments]

Want to start fresh after the crypto crash? Here is a comprehensive guide on how to invest and prosper over the long term.

Well its happened, the crypto market just experienced the worst crash since 2014, the bubble has burst. The idiocy of newbies FOMO-ing into anything with low nominal value lead to endless twitter timelines like this, and now nobody has any idea where the market settles. What do you do now?
In the following weeks it will be a good time to rethink your investment approach and how you arrive at your decisions. Just buying whatever is shilled on Twitter or Reddit and jumping from one crypto to another isn't going to work like it did these last two months.
The good news is that we're finally back closer and closer to our long term moving average which is much more healthy for entrants, the bad news is that the fear might continue compounding if outstanding issues are not dealt with. Tether is the big concern for me personally for reasons I've stated many times, but some relief in the short term may come if the SEC and CFTC meeting on February 6th goes well. Nobody really knows where the bottom is but I think we're now past the "irrational exhuberance" stage and we're entering a period of more serious inspection where cryptos will actually have to prove themselves as useful. I suspect hype artists like CryptoNick and John McAfee will fall out of favor.
But perhaps most importantly use this as a learning experience, don't try to point fingers now. The type of dumb behavior that people were engaging in that was rewarded in a bull market (chasing pumps, going all in on a shillcoin, following hype..etc) could only ever lead to what we are experiencing now. Just like so many people jumped on the crypto bandwagon during the bull run, they will just as quickly jump on whatever bandwagon is to be used to blame for the deflation of the bubble. Nobody who pumped money into garbage without any use case will accept that they themselves with their own investing behavior were the real reason for the gross overvaluation of most cryptocurrencies, and the inevitable crash.
So if you're looking for a fresh start after the massacre (or just want to get in now), here is a guide:

Part A: Making a Investment Strategy

This is your money, put some effort into investing it with an actual strategy. Some simple yet essential advice that should apply to everyone, regardless of individual strategy:
  1. Slow down and research each crypto that you're buying for at least a week.
  2. Don't buy something just because it has risen.
  3. Don't exit a position just because it has declined.
  4. Invest only as much as you can afford to lose.
  5. Prepare enter and exit strategies in advance.
First take some time to think about your ROI target, set your hold periods for each position and how much you are actually ready to risk losing.
ROI targets
A lot of young investors who are in crypto have unrealistic expectations about returns and risk. A lot of them have never invested in any other type of financial asset, and hence many seem to consider a 5-10% ROI in a month to be unexciting.
But its important to temper your hype and realize why we had this exponential growth in the last year and how unlikely it is that we see 10x returns in the next year. What we saw recently was Greater Fool Theory in action. Those unexciting returns of 5-10% a month are much more of the norm, and much more healthy for an alternative investment class.
You can think about setting a target in terms of the market ROI over a relevant holding period and then add or decrease based on your own risk profile.
Example: Calculating a 2 year ROI target
Lets say you want to hold for 2 years now, how could you set a realistic target to strive for? You could look at a historical 2 year return as a base, preferably during a period similar to what we're facing now. Now that we had a major correction, I think we can look at the two year period starting in 2015 after we had the 2014 crash. To calculate a 2 year CAGR starting in 2015:
Year Total Crypto Market Cap
Jan 1, 2015: $5.5 billion
Jan 1, 2017: $18 billion
Compounded annual growth return (CAGR): [(18/5.5)1/2]-1 = 81%
This annual return rate of 81% comes out to about 4.9% compounded monthly. This may not sound exciting to the lambo moon crowd, but it will keep you grounded in reality. You can aim for a higher return (say 2x of that 81% rate) if you choose to take on more risky propositions. I can't tell you what return target you should set for yourself, but just make sure its not depended on you needing to achieve continual near vertical parabolic price action in small cap shillcoins because that isn't sustainable.
Once you have a target you can construct your risk profile (low risk vs. high risk category coins) in your portfolio based on your target.
Risk Management
Everything you buy in crypto is risky, but it still helps to think of these 3 risk categories:
How much risk should you take on? That depends on your own life situation for one, but also it should be proportional to how much expertise you have in both financial analysis and technology.
The general starting point I would recommend is:
Some more core principles on risk management to consider:
You can think of each crypto having a risk factor that is the summation of the general crypto market risk (Rm), but also its own inherent risk specific to its own goals (Ri).
Rt = Rm +Ri
The market risk is something you cannot avoid, it is essentially the risk that is carried by the entire market over things like regulations. What you can minimize though the Ri, the specific risks with your crypto. That will depend on the team composition, geographic risks (for example Chinese coins like NEO carry regulatory risks specific to China), competition within the space and likelihood of adoption and other factors, which I'll describe in Part 2: Crypto Picking Methodology.
Portfolio Allocation
Along with thinking about your portfolio in terms of risk categories described above, I really find it helpful to think about the segments you are in. OnChainFX has some segment categorization but I generally like to bring it down to:
Think about your "Circle of Competence", your body of knowledge that allows you to evaluate an investment. Your ability to properly judge risk and potential is going to largely correlated to your understanding of the subject matter. If you don't know anything about how supply chains functions, how can you competently judge whether VeChain or WaltonChain will achieve adoption? If you don't understand anything about the tech when you read the Cardano paper, are you really able to determine how likely it is to be adopted?
Consider the historic correlations between your holdings. Generally when Bitcoin pumps, altcoins dump but at what rate depends on the coin. When Bitcoin goes sideways we tend to see pumping in altcoins, while when Bitcoin goes down, everything goes down.
You should diversify but really shouldn't be in much more than around 12 cryptos, because you simply don't have enough competency to accurately access the risk across every segment and for every type of crypto you come across. If you have over 20 different cryptos in your portfolio you should probably think about consolidating to a few sectors you understand well.

Part B: Crypto Picking Methodology (Due Dilligence)

Do you struggle on how to fundamentally analyze cryptocurrencies? Here is a 3-step methodology to follow to perform your due dilligence:

Step 1: Filtering and Research

There is so much out there that you can get overwhelmed. The best way to start is to think back to your own portfolio allocation strategy and what you would like to get more off. For example in my view enterprise-focused blockchain solutions will be important in the next few years, and so I look to create a list of various cryptos that are in that segment.
Upfolio has brief descriptions of the top 100 cryptos and is filterable by categories, for example you can click the "Enterprise" category and you have a neat list of VEN, FCT, WTC...etc.
Once you have a list of potential candidates, its time to read about them:
  • Critically evaluate the website. If it's a cocktail of nonsensical buzzwords, if its unprofessional and poorly made, stay away. Always look for a roadmap, compare to what was actually delivered so far. Always check the team, try to find them on LinkedIn and what they did in the past.
  • Read the whitepaper or business development plan. You should fully understand how this crypto functions and how its trying to create value. If there is no use case or if the use case does not require or benefit from a blockchain, move on.
  • Check the blockchain explorer. How is the token distribution across accounts? Are the big accounts selling? Try to figure out who the whales are (not always easy!) and what the foundation/founder account is based on the initial allocation.
  • Look at the Github repos, does it look empty or is there plenty of activity?
  • Search out the subreddit and look at a few Medium or Steem blogs about the coin. How "shilly" is the community, and how much engagement is there between developer and the community?
  • I would also go through the BitcoinTalk thread and Twitter mentions, judge both the length and quality of the discussion.
You can actually filter out a lot of scams and bad investments by simply keeping your eye out on the following red flags:
  • allocations that give way too much to the founder
  • guaranteed promises of returns (Bitcooonnneeeect!)
  • vague whitepapers filled with buzzwords
  • vague timelines and no clear use case
  • Github with no useful code and sparse activity
  • a team that is difficult to find information on

Step 2: Passing a potential pick through a checklist

Once you feel fairly confident that a pick is worth analyzing further, run them through a standardized checklist of questions. This is one I use, you can add other questions yourself:
Crypto Analysis Checklist
What is the problem or transactional inefficiency the coin is trying to solve?
What is the Dev Team like? What is their track record? How are they funded, organized?
How big is the market they're targeting?
Who is their competition and what does it do better?
What is the roadmap they created and how well have they kept to it?
What current product exists?
How does the token/coin actually derive value for the holder? Is there a staking mechanism or is it transactional?
Is there any new tech, and is it informational or governance based?
Can it be easily copied?
What are the weaknesses or problems with this crypto?
The last question is the most important.
This is where the riskiness of your crypto is evaluated, the Ri I talked about above. Here you should be able to accurate place the crypto into one of the three risk categories. I also like to run through this checklist of blockchain benefits and consider which specific properties of the blockchain are being used by the specific crypto to provide some increased utility over the current transactional method:
Benefits of Cryptocurrency
Decentralization - no need for a third party to agree or validate transactions.
Transparency and trust - As blockchain are shared, everyone can see what transactions occur. Useful for something like an online casino.
Immutability - It is extremely difficult to change a transaction once its been put onto a blockchain
Distributed availability - The system is spread on thousands of nodes on a P2P network, so its difficult to take the system down.
Security - cryptographically secured transactions provide integrity
Simplification and consolidation - a blockchain can serve as a shared ledger in industries where multiple entities previously kept their own data sources
Quicker Settlement - In the financial industry when we're dealing with post-trade settlement, a blockchain can drastically increase the speed of verification
Cost - in some cases avoiding a third party verification would drastically reduce costs.

Step 3: Create a valuation model

You don't need to get into full modeling or have a financial background. Even a simple model that just tries to derive a valuation through relative terms will put you above most crypto investors. Some simple valuation methods that anyone can do:
Probablistic Scenario Valuation
This is all about thinking of scenarios and probability, a helpful exercise in itself. For example: Bill Miller, a prominent value investor, wrote a probabilistic valuation case for Bitcoin in 2015. He looked at two possible scenarios for probabalistic valuation:
  1. becoming a store-of-value equal to gold (a $6.4 trillion value), with a .25% probability of occurring
  2. replacing payment processors like VISA, MasterCard, etc. (a $350 million dollar value) with a 2.5% probability
Combining those scenarios would give you the total expected market cap: (0.25% x 6.4 trillion) + (2.5% x 350 million). Divide this by the outstanding supply and you have your valuation.
Metcalfe's Law
Metcalfe's Law which states that the value of a network is proportional to the square of the number of connected users of the system (n2). So you can compare various currencies based on their market cap and square of active users or traffic. We can alter this to crypto by thinking about it in terms of both users and transactions:
For example, compare the Coinbase pairs:
Metric Bitoin Ethereum Litecoin
Market Cap $152 Billion $93 Billion $7.3 Billion
Daily Transactions (last 24hrs) 249,851 1,051,427 70,397
Active Addresses (Peak 1Yr) 1,132,000 1,035,000 514,000
Metcalfe Ratio (Transactions Based) 2.43 0.08 1.47
Metcalfe Ratio (Address Based) 0.12 0.09 0.03
Generally the higher the ratio, the higher the valuation given for each address/transaction.
Market Cap to Industry comparisons
Another easy one is simply looking at the total market for the industry that the coin is supposedly targeting and comparing it to the market cap of the coin. Think of the market cap not only with circulating supply like its shown on CMC but including total supply. For example the total supply for Dentacoin is 1,841,395,638,392, and when multiplied by its price in early January we get a market cap that is actually higher than the entire industry it aims to disrupt: Dentistry.
More complex valuation models
If you would like to get into more fleshed out models with Excel, I highly recommend Chris Burniske's blog about using Quantity Theory of Money to build an equivalent of a DCF analysis for crypto.
Here is an Excel file example of OMG done by Nodar Janashia using Chris' model .
You should create multiple scenarios with multiple assumptions, both positive and negative. Have a base scenario and then moderately optimistic/pessimistic and highly optimistic/pessimistic scenario.
Personally I like to see at least a 50% upward potential before investing from my moderately pessimistic scenario, but you can set your own safety margin.
The real beneficial thing about modelling isn't even the price or valuation comparisons it spits out, but that it forces you to think about why the coin has value and what your own assumption about the future are. For example the discount rate you apply to the net present utility formula drastically affects the valuation, and it reflects your own assumptions of how risky the crypto is. What exactly would be a reasonable discount rate? What about the digital economy you are assuming for the coin, what levers affects its size and adoption and how likely are your assumptions to come true? You'll be a drastically more intelligent investor if you think about the fundamental variables that give your coin the market cap you think it should hold.

Summing it up

The time for lambo psychosis is over. But that's no reason to feel down, this is a new day and what many were waiting for. I've put together in one place here how to construct a portfolio allocation (taking into consideration risk and return targets), and how to go through a systematic crypto picking method. I'm won't tell you what to buy, you should always decide that for yourself and DYOR. But as long as you follow a rational and thorough methodology (feel free to modify anything I said above to suit your own needs) you will feel pretty good about your investments, even in times like these.
Edit: Also get a crypto prediction ferret. You won't regret it.
submitted by arsonbunny to CryptoCurrency [link] [comments]

Proposal for ICON to reconsider additional exchange listings

It has been known for a while that ICON team has a stance on only focusing on getting to exchanges with fiat on-ramps, and other exchanges are not important to them. I would like to propose for the ICON team to take a second look at this matter.
It has always puzzled me that why is this the case with ICON, but only recently with the Binance hack and deposit/withdrawal suspension, has it really dawned on me how bad this is. Due to this hack I have not been able to transfer my ICON between my cold wallet and Binance, and Binance just happens to be the only exchange I'm registered to that has ICX listed. And don't get me wrong, I have accounts for quite a few exchanges. Yes, you could say that why don't I just open a new account at another exchange where ICX is traded but that's just a workaround for the real problem here.
If you take a look at OpenMarketCap's ICON page, then you can see that the only two trusted exchanges (that are known not to fake trading volume) are Binance and Upbit. Does that not seem like a problem to anyone?
What is perhaps the strangest to me, is that why does ICON have such a firm position on not listing on additional exchanges? Is it about the listing fees? Lack of manpower to do the necessary work?
BitttBurger said in his recent post that he has even offered the ICON team to do some of the legwork to get on additional exchanges, but his offer was refused.
We could have three community members create an Excel spreadsheet over the next three weeks with a simple 1, 2, 3 step, easy to read instructions on how to get on another 30-40 exchanges. Of those, 5-10 would probably be very meaningful and good. The others maybe just good to have the exposure. A couple may be a waste of energy, but is there really a downside to being as ubiquitous as possible? As an extreme example, Bitcoin is on over 300 exchanges and I don’t think that’s considered “a negative”.
As an ICON holder and community member from the start, I would kindly ask the ICON team to revisit this issue. Not to decide anything right away but just consider the pros and cons of additional listings. If the initial reasons for not listing still exist today, then so be it... but if there's a chance things have changed during that time, then I think moving towards additional listings would greatly improve ICX liquidity and public's opinion of the project.
TL/DR; ICON team, please revisit your priorities on additional exchange listings.
submitted by Arthur_C_Doge to helloicon [link] [comments]

Which are your Top 5 favourite coins out of the Top 100? An analysis.

I am putting together my investment portfolio for 2018 and made a complete summary of the current Top 100. Interestingly, I noticed that all coins can be categorized into 12 markets. Which markets do you think will play the biggest role in the coming year?
Here is a complete overview of all coins in an excel sheet including name, market, TPS, risk profile, time since launch (negative numbers mean that they are launching that many months in the future) and market cap. You can also sort by all of these fields of course. Coins written in bold are the strongest contenders within their market either due to having the best technology or having a small market cap and still excellent technology and potential. https://docs.google.com/spreadsheets/d/1s8PHcNvvjuy848q18py_CGcu8elRGQAUIf86EYh4QZo/edit#gid=0
The 12 markets are
  1. Currency 13 coins
  2. Platform 25 coins
  3. Ecosystem 9 coins
  4. Privacy 10 coins
  5. Currency Exchange Tool 8 coins
  6. Gaming & Gambling 5 coins
  7. Misc 15 coins
  8. Social Network 4 coins
  9. Fee Token 3 coins
  10. Decentralized Data Storage 4 coins
  11. Cloud Computing 3 coins
  12. Stable Coin 2 coins
Before we look at the individual markets, we need to take a look of the overall market and its biggest issue scalability first:
Cryptocurrencies aim to be a decentralized currency that can be used worldwide. Its goal is to replace dollar, Euro, Yen, all FIAT currencies worldwide. The coin that will achieve that will be worth several trillion dollars.
Bitcoin can only process 7 transactions per second (TPS). In order to replace all FIAT, it would need to perform at at least VISA levels, which usually processes around 3,000 TPS, up to 25,000 TPS during peak times and a maximum of 64,000 TPS. That means that this cryptocurrency would need to be able to perform at least several thousand TPS. However, a ground breaking technology should not look at current technology to set a goal for its use, i.e. estimating the number of emails sent in 1990 based on the number of faxes sent wasn’t a good estimate.
For that reason, 10,000 TPS is the absolute baseline for a cryptocurrency that wants to replace FIAT. This brings me to IOTA, which wants to connect all 80 billion IoT devices that are expected to exist by 2025, which constantly communicate with each other, creating 80 billion or more transactions per second. This is the benchmark that cryptocurrencies should be aiming for. Currently, 8 billion devices are connected to the Internet.
With its Lightning network recently launched, Bitcoin is realistically looking at 50,000 possible soon. Other notable cryptocurrencies besides IOTA and Bitcoin are Nano with 7,000 TPS already tested, Dash with several billion TPS possible with Masternodes, Neo, LISK and RHOC with 100,000 TPS by 2020, Ripple with 50,000 TPS, Ethereum with 10,000 with Sharding.
However, it needs to be said that scalability usually goes at the cost of decentralization and security. So, it needs to be seen, which of these technologies can prove itself resilient and performant.
Without further ado, here are the coins of the first market

Market 1 - Currency:

  1. Bitcoin: 1st generation blockchain with currently bad scalability currently, though the implementation of the Lightning Network looks promising and could alleviate most scalability concerns, scalability and high energy use.
  2. Ripple: Centralized currency that might become very successful due to tight involvement with banks and cross-border payments for financial institutions; banks and companies like Western Union and Moneygram (who they are currently working with) as customers customers. However, it seems they are aiming for more decentralization now.https://ripple.com/dev-blog/decentralization-strategy-update/. Has high TPS due to Proof of Correctness algorithm.
  3. Bitcoin Cash: Bitcoin fork with the difference of having an 8 times bigger block size, making it 8 times more scalable than Bitcoin currently. Further block size increases are planned. Only significant difference is bigger block size while big blocks lead to further problems that don't seem to do well beyond a few thousand TPS. Opponents to a block size argue that increasing the block size limit is unimaginative, offers only temporary relief, and damages decentralization by increasing costs of participation. In order to preserve decentralization, system requirements to participate should be kept low. To understand this, consider an extreme example: very big blocks (1GB+) would require data center level resources to validate the blockchain. This would preclude all but the wealthiest individuals from participating.Community seems more open than Bitcoin's though.
  4. Litecoin : Little brother of Bitcoin. Bitcoin fork with different mining algorithm but not much else.Copies everything that Bitcoin does pretty much. Lack of real innovation.
  5. Dash: Dash (Digital Cash) is a fork of Bitcoin and focuses on user ease. It has very fast transactions within seconds, low fees and uses Proof of Service from Masternodes for consensus. They are currently building a system called Evolution which will allow users to send money using usernames and merchants will find it easy to integrate Dash using the API. You could say Dash is trying to be a PayPal of cryptocurrencies. Currently, cryptocurrencies must choose between decentralization, speed, scalability and can pick only 2. With Masternodes, Dash picked speed and scalability at some cost of decentralization, since with Masternodes the voting power is shifted towards Masternodes, which are run by Dash users who own the most Dash.
  6. IOTA: 3rd generation blockchain called Tangle, which has a high scalability, no fees and instant transactions. IOTA aims to be the connective layer between all 80 billion IOT devices that are expected to be connected to the Internet in 2025, possibly creating 80 billion transactions per second or 800 billion TPS, who knows. However, it needs to be seen if the Tangle can keep up with this scalability and iron out its security issues that have not yet been completely resolved.
  7. Nano: 3rd generation blockchain called Block Lattice with high scalability, no fees and instant transactions. Unlike IOTA, Nano only wants to be a payment processor and nothing else, for now at least. With Nano, every user has their own blockchain and has to perform a small amount of computing for each transaction, which makes Nano perform at 300 TPS with no problems and 7,000 TPS have also been tested successfully. Very promising 3rd gen technology and strong focus on only being the fastest currency without trying to be everything.
  8. Decred: As mining operations have grown, Bitcoin’s decision-making process has become more centralized, with the largest mining companies holding large amounts of power over the Bitcoin improvement process. Decred focuses heavily on decentralization with their PoW Pos hybrid governance system to become what Bitcoin was set out to be. They will soon implement the Lightning Network to scale up. While there do not seem to be more differences to Bitcoin besides the novel hybrid consensus algorithm, which Ethereum, Aeternity and Bitcoin Atom are also implementing, the welcoming and positive Decred community and professoinal team add another level of potential to the coin.
  9. Aeternity: We’ve seen recently, that it’s difficult to scale the execution of smart contracts on the blockchain. Crypto Kitties is a great example. Something as simple as creating and trading unique assets on Ethereum bogged the network down when transaction volume soared. Ethereum and Zilliqa address this problem with Sharding. Aeternity focuses on increasing the scalability of smart contracts and dapps by moving smart contracts off-chain. Instead of running on the blockchain, smart contracts on Aeternity run in private state channels between the parties involved in the contracts. State channels are lines of communication between parties in a smart contract. They don’t touch the blockchain unless they need to for adjudication or transfer of value. Because they’re off-chain, state channel contracts can operate much more efficiently. They don’t need to pay the network for every time they compute and can also operate with greater privacy. An important aspect of smart contract and dapp development is access to outside data sources. This could mean checking the weather in London, score of a football game, or price of gold. Oracles provide access to data hosted outside the blockchain. In many blockchain projects, oracles represent a security risk and potential point of failure, since they tend to be singular, centralized data streams. Aeternity proposes decentralizing oracles with their oracle machine. Doing so would make outside data immutable and unchangeable once it reaches Aeternity’s blockchain. Of course, the data source could still be hacked, so Aeternity implements a prediction market where users can bet on the accuracy and honesty of incoming data from various oracles.It also uses prediction markets for various voting and verification purposes within the platform. Aeternity’s network runs on on a hybrid of proof of work and proof of stake. Founded by a long-time crypto-enthusiast and early colleague of Vitalik Buterin, Yanislav Malahov. Promising concept though not product yet
  10. Bitcoin Atom: Atomic Swaps and hybrid consenus. This looks like the only Bitcoin clone that actually is looking to innovate next to Bitcoin Cash.
  11. Dogecoin: Litecoin fork, fantastic community, though lagging behind a bit in technology.
  12. Bitcoin Gold: A bit better security than bitcoin through ASIC resistant algorithm, but that's it. Not that interesting.
  13. Digibyte: Digibyte's PoS blockchain is spread over a 100,000+ servers, phones, computers, and nodes across the globe, aiming for the ultimate level of decentralization. DigiByte rebalances the load between the five mining algorithms by adjusting the difficulty of each so one algorithm doesn’t become dominant. The algorithm's asymmetric difficulty has gained notoriety and been deployed in many other blockchains.DigiByte’s adoption over the past four years has been slow. It’s still a relatively obscure currency compared its competitors. The DigiByte website offers a lot of great marketing copy and buzzwords. However, there’s not much technical information about what they have planned for the future. You could say Digibyte is like Bitcoin, but with shorter blocktimes and a multi-algorithm. However, that's not really a difference big enough to truly set themselves apart from Bitcoin, since these technologies could be implemented by any blockchain without much difficulty. Their decentralization is probably their strongest asset, however, this also change quickly if the currency takes off and big miners decide to go into Digibyte.
  14. Bitcoin Diamond Asic resistant Bitcoin and Copycat

Market 2 - Platform

Most of the cryptos here have smart contracts and allow dapps (Decentralized apps) to be build on their platform and to use their token as an exchange of value between dapp services.
  1. Ethereum: 2nd generation blockchain that allows the use of smart contracts. Bad scalability currently, though this concern could be alleviated by the soon to be implemented Lightning Network aka Plasma and its Sharding concept.
  2. EOS: Promising technology that wants to be able do everything, from smart contracts like Ethereum, scalability similar to Nano with 1000 tx/second + near instant transactions and zero fees, to also wanting to be a platform for dapps. However, EOS doesn't have a product yet and everything is just promises still. Highly overvalued right now. However, there are lots of red flags, have dumped $500 million Ether over the last 2 months and possibly bought back EOS to increase the size of their ICO, which has been going on for over a year and has raised several billion dollars. All in all, their market cap is way too high for that and not even having a product.
  3. Cardano: Similar to Ethereum/EOS, however, only promises made with no delivery yet, highly overrated right now. Interesting concept though. Market cap way too high for not even having a product. Somewhat promising technology.
  4. VeChain: Singapore-based project that’s building a business enterprise platform and inventory tracking system. Examples are verifying genuine luxury goods and food supply chains. Has one of the strongest communities in the crypto world. Most hyped token of all, with merit though.
  5. Neo: Neo is a platform, similar to Eth, but more extensive, allowing dapps and smart contracts, but with a different smart contract gas system, consensus mechanism (PoS vs. dBfT), governance model, fixed vs unfixed supply, expensive contracts vs nearly free contracts, different ideologies for real world adoption. There are currently only 9 nodes, each of which are being run by a company/entity hand selected by the NEO council (most of which are located in china) and are under contract. This means that although the locations of the nodes may differ, ultimately the neo council can bring them down due to their legal contracts. In fact this has been done in the past when the neo council was moving 50 million neo that had been locked up. Also dbft (or neo's implmentation of it) has failed underload causing network outages during major icos. The first step in decentralization is that the NEO Counsel will select trusted nodes (Universities, business partners, etc.) and slowly become less centralized that way. The final step in decentralization will be allowing NEO holders to vote for new nodes, similar to a DPoS system (ARK/EOS/LISK). NEO has a regulation/government friendly ideology. Finally they are trying to work undewith the Chinese government in regards to regulations. If for some reason they wanted it shut down, they could just shut it down.
  6. Stellar: PoS system, similar goals as Ripple, but more of a platform than only a currency. 80% of Stellar are owned by Stellar.org still, making the currency centralized.
  7. Ethereum classic: Original Ethereum that decided not to fork after a hack. The Ethereum that we know is its fork. Uninteresing, because it has a lot of less resources than Ethereum now and a lot less community support.
  8. Ziliqa: Zilliqa is building a new way of sharding. 2400 tpx already tested, 10,000 tps soon possible by being linearly scalable with the number of nodes. That means, the more nodes, the faster the network gets. They are looking at implementing privacy as well.
  9. QTUM: Enables Smart contracts on the Bitcoin blockchain. Useful.
  10. Icon: Korean ethereum. Decentralized application platform that's building communities in partnership with banks, insurance providers, hospitals, and universities. Focused on ID verification and payments. No big differentiators to the other 20 Ethereums, except that is has a product. That is a plus. Maybe cheap alternative to Ethereum.
  11. LISK: Lisk's difference to other BaaS is that side chains are independent to the main chain and have to have their own nodes. Similar to neo whole allows dapps to deploy their blockchain to. However, Lisk is currently somewhat centralized with a small group of members owning more than 50% of the delegated positions. Lisk plans to change the consensus algorithm for that reason in the near future.
  12. Rchain: Similar to Ethereum with smart contract, though much more scalable at an expected 40,000 TPS and possible 100,000 TPS. Not launched yet. No product launched yet, though promising technology. Not overvalued, probably at the right price right now.
  13. ARDR: Similar to Lisk. Ardor is a public blockchain platform that will allow people to utilize the blockchain technology of Nxt through the use of child chains. A child chain, which is a ‘light’ blockchain that can be customized to a certain extent, is designed to allow easy self-deploy for your own blockchain. Nxt claims that users will "not need to worry" about security, as that part is now handled by the main chain (Ardor). This is the chief innovation of Ardor. Ardor was evolved from NXT by the same company. NEM started as a NXT clone.
  14. Ontology: Similar to Neo. Interesting coin
  15. Bytom: Bytom is an interactive protocol of multiple byte assets. Heterogeneous byte-assets (indigenous digital currency, digital assets) that operate in different forms on the Bytom Blockchain and atomic assets (warrants, securities, dividends, bonds, intelligence information, forecasting information and other information that exist in the physical world) can be registered, exchanged, gambled and engaged in other more complicated and contract-based interoperations via Bytom.
  16. Nxt: Similar to Lisk
  17. Stratis: Different to LISK, Stratis will allow businesses and organizations to create their own blockchain according to their own needs, but secured on the parent Stratis chain. Stratis’s simple interface will allow organizations to quickly and easily deploy and/or test blockchain functionality of the Ethereum, BitShares, BitCoin, Lisk and Stratis environements.
  18. Status: Status provides access to all of Ethereum’s decentralized applications (dapps) through an app on your smartphone. It opens the door to mass adoption of Ethereum dapps by targeting the fastest growing computer segment in the world – smartphone users.16. Ark: Fork of Lisk that focuses on a smaller feature set. Ark wallets can only vote for one delegate at a time which forces delegates to compete against each other and makes cartel formations incredibly hard, if not impossible.
  19. Neblio: Similar to Neo, but 30x smaller market cap.
  20. NEM: Is similar to Neo No marketing team, very high market cap for little clarilty what they do.
  21. Bancor: Bancor is a Decentralized Liquidity Network that allows you to hold any Ethereum token and convert it to any other token in the network, with no counter party, at an automatically calculated price, using a simple web wallet.
  22. Dragonchain: The Purpose of DragonChain is to help companies quickly and easily incorporate blockchain into their business applications. Many companies might be interested in making this transition because of the benefits associated with serving clients over a blockchain – increased efficiency and security for transactions, a reduction of costs from eliminating potential fraud and scams, etc.
  23. Skycoin: Transactions with zero fees that take apparently two seconds, unlimited transaction rate, no need for miners and block rewards, low power usage, all of the usual cryptocurrency technical vulnerabilities fixed, a consensus mechanism superior to anything that exists, resistant to all conceivable threats (government censorship, community infighting, cybenucleaconventional warfare, etc). Skycoin has their own consensus algorithm known as Obelisk written and published academically by an early developer of Ethereum. Obelisk is a non-energy intensive consensus algorithm based on a concept called ‘web of trust dynamics’ which is completely different to PoW, PoS, and their derivatives. Skywire, the flagship application of Skycoin, has the ambitious goal of decentralizing the internet at the hardware level and is about to begin the testnet in April. However, this is just one of the many facets of the Skycoin ecosystem. Skywire will not only provide decentralized bandwidth but also storage and computation, completing the holy trinity of commodities essential for the new internet. Skycion a smear campaign launched against it, though they seem legit and reliable. Thus, they are probably undervalued.

Market 3 - Ecosystem

The 3rd market with 11 coins is comprised of ecosystem coins, which aim to strengthen the ease of use within the crypto space through decentralized exchanges, open standards for apps and more
  1. Nebulas: Similar to how Google indexes webpages Nebulas will index blockchain projects, smart contracts & data using the Nebulas rank algorithm that sifts & sorts the data. Developers rewarded NAS to develop & deploy on NAS chain. Nebulas calls this developer incentive protocol – basically rewards are issued based on how often dapp/contract etc. is used, the more the better the rewards and Proof of devotion. Works like DPoS except the best, most economically incentivised developers (Bookkeeppers) get the forging spots. Ensuring brains stay with the project (Cross between PoI & PoS). 2,400 TPS+, DAG used to solve the inter-transaction dependencies in the PEE (Parallel Execution Environment) feature, first crypto Wallet that supports the Lightening Network.
  2. Waves: Decentralized exchange and crowdfunding platform. Let’s companies and projects to issue and manage their own digital coin tokens to raise money.
  3. Salt: Leveraging blockchain assets to secure cash loands. Plans to offer cash loans in traditional currencies, backed by your cryptocurrency assets. Allows lenders worldwide to skip credit checks for easier access to affordable loans.
  4. CHAINLINK: ChainLink is a decentralized oracle service, the first of its kind. Oracles are defined as an ‘agent’ that finds and verifies real-world occurrences and submits this information to a blockchain to be used in smart contracts.With ChainLink, smart contract users can use the network’s oracles to retrieve data from off-chain application program interfaces (APIs), data pools, and other resources and integrate them into the blockchain and smart contracts. Basically, ChainLink takes information that is external to blockchain applications and puts it on-chain. The difference to Aeternity is that Chainlink deploys the smart contracts on the Ethereum blockchain while Aeternity has its own chain.
  5. WTC: Combines blockchain with IoT to create a management system for supply chains Interesting
  6. Ethos unifyies all cryptos. Ethos is building a multi-cryptocurrency phone wallet. The team is also building an investment diversification tool and a social network
  7. Aion: Aion is the token that pays for services on the Aeternity platform.
  8. USDT: is no cryptocurrency really, but a replacement for dollar for trading After months of asking for proof of dollar backing, still no response from Tether.

Market 4 - Privacy

The 4th market are privacy coins. As you might know, Bitcoin is not anonymous. If the IRS or any other party asks an exchange who is the identity behind a specific Bitcoin address, they know who you are and can track back almost all of the Bitcoin transactions you have ever made and all your account balances. Privacy coins aim to prevent exactly that through address fungability, which changes addresses constantly, IP obfuscation and more. There are 2 types of privacy coins, one with completely privacy and one with optional privacy. Optional Privacy coins like Dash and Nav have the advantage of more user friendliness over completely privacy coins such as Monero and Enigma.
  1. Monero: Currently most popular privacy coin, though with a very high market cap. Since their privacy is all on chain, all prior transactions would be deanonymized if their protocol is ever cracked. This requires a quantum computing attack though. PIVX is better in that regard.
  2. Zcash: A decentralized and open-source cryptocurrency that hide the sender, recipient, and value of transactions. Offers users the option to make transactions public later for auditing. Decent privacy coin, though no default privacy
  3. Verge: Calls itself privacy coin without providing private transactions, multiple problems over the last weeks has a toxic community, and way too much hype for what they have.
  4. Bytecoin: First privacy-focused cryptocurrency with anonymous transactions. Bytecoin’s code was later adapted to create Monero, the more well-known anonymous cryptocurrency. Has several scam accusations, 80% pre-mine, bad devs, bad tech
  5. Bitcoin Private: A merge fork of Bitcoin and Zclassic with Zclassic being a fork of Zcash with the difference of a lack of a founders fee required to mine a valid block. This promotes a fair distribution, preventing centralized coin ownership and control. Bitcoin private offers the optional ability to keep the sender, receiver, and amount private in a given transaction. However, this is already offered by several good privacy coins (Monero, PIVX) and Bitcoin private doesn't offer much more beyond this.
  6. Komodo: The Komodo blockchain platform uses Komodo’s open-source cryptocurrency for doing transparent, anonymous, private, and fungible transactions. They are then made ultra-secure using Bitcoin’s blockchain via a Delayed Proof of Work (dPoW) protocol and decentralized crowdfunding (ICO) platform to remove middlemen from project funding. Offers services for startups to create and manage their own Blockchains.
  7. PIVX: As a fork of Dash, PIVX uses an advanced implementation of the Zerocoin protocol to provide it’s privacy. This is a form of zeroknowledge proofs, which allow users to spend ‘Zerocoins’ that have no link back to them. Unlike Zcash u have denominations in PIVX, so they can’t track users by their payment amount being equal to the amount of ‘minted’ coins, because everyone uses the same denominations. PIVX is also implementing Bulletproofs, just like Monero, and this will take care of arguably the biggest weakness of zeroknowledge protocols: the trusted setup.
  8. Zcoin: PoW cryptocurrency. Private financial transactions, enabled by the Zerocoin Protocol. Zcoin is the first full implementation of the Zerocoin Protocol, which allows users to have complete privacy via Zero-Knowledge cryptographic proofs.
  9. Enigma: Monero is to Bitcoin what enigma is to Ethereum. Enigma is for making the data used in smart contracts private. More of a platform for dapps than a currency like Monero. Very promising.
  10. Navcoin: Like bitcoin but with added privacy and pos and 1,170 tps, but only because of very short 30 second block times. Though, privacy is optional, but aims to be more user friendly than Monero. However, doesn't really decide if it wants to be a privacy coin or not. Same as Zcash.Strong technology, non-shady team.
  11. Tenx: Raised 80 million, offers cryptocurrency-linked credit cards that let you spend virtual money in real life. Developing a series of payment platforms to make spending cryptocurrency easier. However, the question is if full privacy coins will be hindered in growth through government regulations and optional privacy coins will become more successful through ease of use and no regulatory hindrance.

Market 5 - Currency Exchange Tool

Due to the sheer number of different cryptocurrencies, exchanging one currency for the other it still cumbersome. Further, merchants don’t want to deal with overcluttered options of accepting cryptocurrencies. This is where exchange tool like Req come in, which allow easy and simple exchange of currencies.
  1. Cryptonex: Fiat and currency exchange between various blockchain services, similar to REQ.
  2. QASH: Qash is used to fuel its liquid platform which will be an exchange that will distribute their liquidity pool. Its product, the Worldbook is a multi-exchange order book that matches crypto to crypto, and crypto to fiat and the reverse across all currencies. E.g., someone is selling Bitcoin is USD on exchange1 not owned by Quoine and someone is buying Bitcoin in EURO on exchange 2 not owned by Quoine. If the forex conversions and crypto conversions match then the trade will go through and the Worldbook will match it, it'll make the sale and the purchase on either exchange and each user will get what they wanted, which means exchanges with lower liquidity if they join the Worldbook will be able to fill orders and take trade fees they otherwise would miss out on.They turned it on to test it a few months ago for an hour or so and their exchange was the top exchange in the world by 4x volume for the day because all Worldbook trades ran through it. Binance wants BNB to be used on their one exchange. Qash wants their QASH token embedded in all of their partners. More info here https://www.reddit.com/CryptoCurrency/comments/8a8lnwhich_are_your_top_5_favourite_coins_out_of_the/dwyjcbb/?context=3
  3. Kyber: network Exchange between cryptocurrencies, similar to REQ. Features automatic coin conversions for payments. Also offers payment tools for developers and a cryptocurrency wallet.
  4. Achain: Building a boundless blockchain world like Req .
  5. Req: Exchange between cryptocurrencies.
  6. Bitshares: Exchange between cryptocurrencies. Noteworthy are the 1.5 second average block times and throughput potential of 100,000 transactions per second with currently 2,400 TPS having been proven. However, bitshares had several Scam accusations in the past.
  7. Loopring: A protocol that will enable higher liquidity between exchanges and personal wallets.
  8. ZRX: Open standard for dapps. Open, permissionless protocol allowing for ERC20 tokens to be traded on the Ethereum blockchain. In 0x protocol, orders are transported off-chain, massively reducing gas costs and eliminating blockchain bloat. Relayers help broadcast orders and collect a fee each time they facilitate a trade. Anyone can build a relayer.

Market 6 - Gaming

With an industry size of $108B worldwide, Gaming is one of the largest markets in the world. For sure, cryptocurrencies will want to have a share of that pie.
  1. Storm: Mobile game currency on a platform with 9 million players.
  2. Fun: A platform for casino operators to host trustless, provably-fair gambling through the use of smart contracts, as well as creating their own implementation of state channels for scalability.
  3. Electroneum: Mobile game currency They have lots of technical problems, such as several 51% attacks
  4. Wax: Marketplace to trade in-game items

Market 7 - Misc

There are various markets being tapped right now. They are all summed up under misc.
  1. OMG: Omise is designed to enable financial services for people without bank accounts. It works worldwide and with both traditional money and cryptocurrencies.
  2. Power ledger: Australian blockchain-based cryptocurrency and energy trading platform that allows for decentralized selling and buying of renewable energy. Unique market and rather untapped market in the crypto space.
  3. Populous: A platform that connects business owners and invoice buyers without middlemen. Invoice sellers get cash flow to fund their business and invoice buyers earn interest. Similar to OMG, small market.
  4. Monacoin: The first Japanese cryptocurrency. Focused on micro-transactions and based on a popular internet meme of a type-written cat. This makes it similar to Dogecoin. Very niche, tiny market.
  5. Revain: Legitimizing reviews via the blockchain. Interesting concept, though market not as big.
  6. Augur: Platform to forecast and make wagers on the outcome of real-world events (AKA decentralized predictions). Uses predictions for a “wisdom of the crowd” search engine. Not launched yet.
  7. Substratum: Revolutionzing hosting industry via per request billing as a decentralized internet hosting system. Uses a global network of private computers to create the free and open internet of the future. Participants earn cryptocurrency. Interesting concept.
  8. Veritaseum: Is supposed to be a peer to peer gateway, though it looks like very much like a scam.
  9. TRON: Tronix is looking to capitalize on ownership of internet data to content creators. However, they plagiarized their white paper, which is a no go. They apologized, so it needs to be seen how they will conduct themselves in the future. Extremely high market cap for not having a product, nor proof of concept.
  10. Syscoin: A cryptocurrency with a decentralized marketplace that lets people buy and sell products directly without third parties. Trying to remove middlemen like eBay and Amazon.
  11. Hshare: Most likely scam because of no code changes, most likely pump and dump scheme, dead community.
  12. BAT: An Ethereum-based token that can be exchanged between content creators, users, and advertisers. Decentralized ad-network that pays based on engagement and attention.
  13. Dent: Decentralizeed exchange of mobile data, enabling mobile data to be marketed, purchased or distributed, so that users can quickly buy or sell data from any user to another one.
  14. Ncash: End to end encrypted Identification system for retailers to better serve their customers .
  15. Factom Secure record-keeping system that allows companies to store their data directly on the Blockchain. The goal is to make records more transparent and trustworthy .

Market 8 - Social network

Web 2.0 is still going strong and Web 3.0 is not going to ignore it. There are several gaming tokens already out there and a few with decent traction already, such as Steem, which is Reddit with voting through money is a very interesting one.
  1. Mithril: As users create content via social media, they will be rewarded for their contribution, the better the contribution, the more they will earn
  2. Steem: Like Reddit, but voting with money. Already launched product and Alexa rank 1,000 Thumbs up.
  3. Rdd: Reddcoin makes the process of sending and receiving money fun and rewarding for everyone. Reddcoin is dedicated to one thing – tipping on social networks as a way to bring cryptocurrency awareness and experience to the general public.
  4. Kin: Token for the platform Kik. Kik has a massive user base of 400 million people. Replacing paying with FIAT with paying with KIN might get this token to mass adoption very quickly.

Market 9 - Fee token

Popular exchanges realized that they can make a few billion dollars more by launching their own token. Owning these tokens gives you a reduction of trading fees. Very handy and BNB (Binance Coin) has been one of the most resilient tokens, which have withstood most market drops over the last weeks and was among the very few coins that could show growth.
  1. BNB: Fee token for Binance
  2. Gas: Not a Fee token for an exchange, but it is a dividend paid out on Neo and a currency that can be used to purchase services for dapps.
  3. Kucoin: Fee token for Kucoin

Market 10 - Decentralized Data Storage

Currently, data storage happens with large companies or data centers that are prone to failure or losing data. Decentralized data storage makes loss of data almost impossible by distributing your files to numerous clients that hold tiny pieces of your data. Remember Torrents? Torrents use a peer-to-peer network. It is similar to that. Many users maintain copies of the same file, when someone wants a copy of that file, they send a request to the peer-to-peer network., users who have the file, known as seeds, send fragments of the file to the requester., he requester receives many fragments from many different seeds, and the torrent software recompiles these fragments to form the original file.
  1. Gbyte: Byteball data is stored and ordered using directed acyclic graph (DAG) rather than blockchain. This allows all users to secure each other's data by referencing earlier data units created by other users, and also removes scalability limits common for blockchains, such as blocksize issue.
  2. Siacoin: Siacoin is decentralized storage platform. Distributes encrypted files to thousands of private users who get paid for renting out their disk space. Anybody with siacoins can rent storage from hosts on Sia. This is accomplish via "smart" storage contracts stored on the Sia blockchain. The smart contract provides a payment to the host only after the host has kept the file for a given amount of time. If the host loses the file, the host does not get paid.
  3. Maidsafecoin: MaidSafe stands for Massive Array of Internet Disks, Secure Access for Everyone.Instead of working with data centers and servers that are common today and are vulnerable to data theft and monitoring, SAFE’s network uses advanced P2P technology to bring together the spare computing capacity of all SAFE users and create a global network. You can think of SAFE as a crowd-sourced internet. All data and applications reside in this network. It’s an autonomous network that automatically sets prices and distributes data and rents out hard drive disk space with a Blockchain-based storage solutions.When you upload a file to the network, such as a photo, it will be broken into pieces, hashed, and encrypted. The data is then randomly distributed across the network. Redundant copies of the data are created as well so that if someone storing your file turns off their computer, you will still have access to your data. And don’t worry, even with pieces of your data on other people’s computers, they won’t be able to read them. You can earn MadeSafeCoins by participating in storing data pieces from the network on your computer and thus earning a Proof of Resource.
  4. Storj: Storj aims to become a cloud storage platform that can’t be censored or monitored, or have downtime. Your files are encrypted, shredded into little pieces called 'shards', and stored in a decentralized network of computers around the globe. No one but you has a complete copy of your file, not even in an encrypted form.

Market 11 - Cloud computing

Obviously, renting computing power, one of the biggest emerging markets as of recent years, e.g. AWS and Digital Ocean, is also a service, which can be bought and managed via the blockchain.
  1. Golem: Allows easy use of Supercomputer in exchange for tokens. People worldwide can rent out their computers to the network and get paid for that service with Golem tokens.
  2. Elf: Allows easy use of Cloud computing in exchange for tokens.

Market 12 - Stablecoin

Last but not least, there are 2 stablecoins that have established themselves within the market. A stable coin is a coin that wants to be independent of the volatility of the crypto markets. This has worked out pretty well for Maker and DGD, accomplished through a carefully diversified currency fund and backing each token by 1g or real gold respectively. DO NOT CONFUSE DGD AND MAKER with their STABLE COINS DGX and DAI. DGD and MAKER are volatile, because they are the companies of DGX and DAI. DGX and DAI are the stable coins.
  1. DGD: Platform of the Stablecoin DGX. Every DGX coin is backed by 1g of gold and make use proof of asset consensus.
  2. Maker: Platform of the Stablecoin DAI that doesn't vary much in price through widespread and smart diversification of assets.
EDIT: Added a risk factor from 0 to 10. The baseline is 2 for any crypto. Significant scandals, mishaps, shady practices, questionable technology, increase the risk factor. Not having a product yet automatically means a risk factor of 6. Strong adoption and thus strong scrutiny or positive community lower the risk factor.
EDIT2: Added a subjective potential factor from 0 to 10, where its overall potential and a small or big market cap is factored in. Bitcoin with lots of potential only gets a 9, because of its massive market cap, because if Bitcoin goes 10x, smaller coins go 100x, PIVX gets a 10 for being as good as Monero while carrying a 10x smaller market cap, which would make PIVX go 100x if Monero goes 10x.
submitted by galan77 to CryptoCurrency [link] [comments]

Download historical Bitcoin data directly into Excel Mining Bitcoin with Excel - YouTube Cryptocurrency Tracker Spreadsheet £,$ & More Free. Track Altcoins and Bitcoin Ultimate Day Trading Stock Market Excel Spreadsheet ... Balance of any Bitcoin address into Excel (Macro included)

When trading bitcoin versus altcoins it might be a little bit complicated to track your portfolio changes as here we are Continue reading >> Excel Spreadsheet For Cryptocurrency Investment Fund Model. Excel spreadsheet for cryptocurrency investment fund model I am looking to start managing a small cryptocurrency fund. Friends will basically ... The API tracker link can be seen on the tools page and is: 3) Go into the Excel spreadsheet and click the Data tab. Select New Query -> From Other Sources -> From Web, here is a screenshot . ... This is especially relevant in trading, where so much of the change in price is dictated by emotions: When it is applied to trading, sentiment can be ... Best FIFO Excel tool with Google sheet for calculation of trading gains in bitcoin, crypto and stocks using FIFO method. bitcoin gain cryptocurrency gain bitcoin tax cryptocurrency tax fifo gain calculator I made a complete bitcoin spreadsheet (excel) with live crypto price updates, moon math, and a full history of your Portfolio and trading performance. This is a spreadsheet that I have developed for myself over the last year or so. Introducing Cryptosheets, the world's first real-time cryptocurrency data add-in for Microsoft Excel. Discover the program thousands of traders are using on a daily basis.

[index] [591] [28] [772] [782] [520] [327] [706] [420] [413] [572]

Download historical Bitcoin data directly into Excel

CellBot v1 - Live Crypto #Bitcoin #Trading with an #EXCEL Sheet Fully Automatic on Binance - Duration: 10:10. CellBot - Excel Crypto Trading Bot Recommended for you 10:10 This Video shows how to create Simple Trading Journal. you can take it to next level by adding formula, Graphs and so on. ⌚️ What's in this Video? : 00:00 Cr... Fully automated day trading excel spreadsheet platform after only inputting the following information (date, symbol, buying price, shares, selling price). Fu... Learn how to mine Bitcoin with an Excel spreadsheet. Check out the following video for info on 21's Bitcoin computer, which can actually be used to mine Bitc... The macro in the very first comment below lets you import the current value held in any Bitcoin address into Excel. Thanks to https://blockchain.info for their API. See reply to Juan Lopez's ...

#