I created a website where Crypto 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 Digital Currency traders and investors could go to get easy access to datasets and trading tools (such as add-ins, charting, and 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 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
Currently over 3,000+ datasets spanning 800+ currencies, and more being added every week (see below for full list)
Excel add-in to automatically pull the datasets directly into a spreadsheet
Spreadsheet based trading templates (currently technical analysis, will expand to other areas in the future)
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 and Strategies
Ethereum Daily Trading Strategy
12 and 26 day EMA
Relative Strength Index
Moving Average Convergence-Divergence
Average True Range
Many more to come as I find time to build them out
On The Horizon
Google sheets add-in
Giving premium users a partial currency of their choice every month, based on sub price, almost like a savings/investing/trading vehicle
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
Has anyone created their own excel spreadsheet for calculating crypto currency tax lisbilities? In particular for crypto to crypto trades
Thinking about trying to create a template but would be great if I could see someone’s blank template to give me a headstart. Thanks for any input I’m sure others must be in the same boat would be great if someone could post a link to allow downloads of it. Thank you
Just learned how claiming losses on crypto works and it is pure evil.
If you lose 100% of an asset because it is lost or stolen, the latest tax law disallows you from claiming any loss whatsoever. But if you still have the coins and they have 90% of their value, you can sell them and claim a loss. What in the actual fuck? I guess I am going to go restock whatever worthless shitcoins I used to have so I can pretend that I never lost them and then sell them so I can show the IRS how I lost money on the coins that I lost. Fucking crazy.
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:
Limited Supply - There will only ever be 21,000,000 bitcoins created and they are issued in a predictable fashion, you can view the inflation schedule here. Once they are all issued Bitcoin will be truly deflationary. The halving countdown can be found here.
Open source - Bitcoin code is fully auditable. You can read the source code yourself here.
Accountable - The public ledger is transparent, all transactions are seen by everyone.
Decentralized - Bitcoin is globally distributed across thousands of nodes with no single point of failure and as such can't be shut down similar to how Bittorrent works. You can even run a node on a Raspberry Pi.
Censorship resistant - No one can prevent you from interacting with the bitcoin network and no one can censor, alter or block transactions that they disagree with, see Operation Chokepoint.
Push system - There are no chargebacks in bitcoin because only the person who owns the address where the bitcoins reside has the authority to move them.
Low fee scaling - On chain transaction fees depend on network demand and how much priority you wish to assign to the transaction. Most wallets calculate on chain fees automatically but you can view current fees here and mempool activity here. On chain fees may rise occasionally due to network demand, however instant micropayments that do not require confirmations are happening via the Lightning Network, a second layer scaling solution currently rolling out on the Bitcoin mainnet.
Borderless - No country can stop it from going in/out, even in areas currently unserved by traditional banking as the ledger is globally distributed.
Portable - Bitcoins are digital so they are easier to move than cash or gold. They can even be transported by simply memorizing a string of words for wallet recovery (while cool this method is generally not recommended due to potential for insecure key generation by inexperienced users. Hardware wallets are the preferred method for new users due to ease of use and additional security).
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.
If you prefer to "Be your own bank" and have direct control over your coins without having to use a trusted third party, then you will need to create your own wallet and keep it secure. If you want easy and secure storage without having to learn computer security best practices, then a hardware wallet such as the Trezor, Ledger or ColdCard is recommended. Alternatively there are many software wallet options to choose from here depending on your use case.
If you prefer to let third party "Bitcoin banks" manage your coins, try Gemini but be aware you may not be in control of your private keys in which case you would have to ask permission to access your funds and be exposed to third party risk.
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.
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.
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.
Just like any other form of money, you can also earn bitcoins by being paid to do a job.
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.
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.
One Bitcoin is quite large (hundreds of £/$/€) so people often deal in smaller units. The most common subunits are listed below:
one bitcoin is equal to 100 million satoshis
1,000 per bitcoin
used as default unit in recent Electrum wallet releases
1,000,000 per bitcoin
colloquial "slang" term for microbitcoin (μBTC)
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!
You may have heard about off-shore tax havens of questionable legality where wealthy people invest their money in legal "grey zones" and don't pay any tax, as featured for example, in Netflix's drama, The Laundromat. The reality is that the Government of Canada offers 100% tax-free investing throughout your life, with unlimited withdrawals of your contributions and profits, and no limits on how much you can make tax-free. There is also nothing to report to the Canada Revenue Agency. Although Britain has a comparable program, Canada is the only country in the world that offers tax-free investing with this level of power and flexibility. Thank you fellow Redditors for the wonderful Gold Award and Today I Learned Award! (Unrelated but Important Note: I put a link at the bottom for my margin account explainer. Many people are interested in margin trading but don't understand the math behind margin accounts and cannot find an explanation. If you want to do margin, but don't know how, click on the link.) As a Gen-Xer, I wrote this post with Millennials in mind, many of whom are getting interested in investing in ETFs, individual stocks, and also my personal favourite, options. Your generation is uniquely positioned to take advantage of this extremely powerful program at a relatively young age. But whether you're in your 20's or your 90's, read on! Are TFSAs important? In 2020 Canadians have almost 1 trillion dollars saved up in their TFSAs, so if that doesn't prove that pennies add up to dollars, I don't know what does. The TFSA truly is the Great Canadian Tax Shelter. I will periodically be checking this and adding issues as they arise, to this post. I really appreciate that people are finding this useful. As this post is now fairly complete from a basic mechanics point of view, and some questions are already answered in this post, please be advised that at this stage I cannot respond to questions that are already covered here. If I do not respond to your post, check this post as I may have added the answer to the FAQs at the bottom.
How to Invest in Stocks
A lot of people get really excited - for good reason - when they discover that the TFSA allows you to invest in stocks, tax free. I get questions about which stocks to buy. I have made some comments about that throughout this post, however; I can't comprehensively answer that question. Having said that, though, if you're interested in picking your own stocks and want to learn how, I recommmend starting with the following videos: The first is by Peter Lynch, a famous American investor in the 80's who wrote some well-respected books for the general public, like "One Up on Wall Street." The advice he gives is always valid, always works, and that never changes, even with 2020's technology, companies and AI: https://www.youtube.com/watch?v=cRMpgaBv-U4&t=2256s The second is a recording of a university lecture given by investment legend Warren Buffett, who expounds on the same principles: https://www.youtube.com/watch?v=2MHIcabnjrA Please note that I have no connection to whomever posted the videos.
TFSAs were introduced in 2009 by Stephen Harper's government, to encourage Canadians to save. The effect of the TFSA is that ordinary Canadians don't pay any income or capital gains tax on their securities investments. Initial uptake was slow as the contribution rules take some getting used to, but over time the program became a smash hit with Canadians. There are about 20 million Canadians with TFSAs, so the uptake is about 70%- 80% (as you have to be the age of majority in your province/territory to open a TFSA).
Eligibility to Open a TFSA
You must be a Canadian resident with a valid Social Insurance Number to open a TFSA. You must be at the voting age in the province in which you reside in order to open a TFSA, however contribution room begins to accumulate from the year in which you turned 18. You do not have to file a tax return to open a TFSA. You do not need to be a Canadian citizen to open and contribute to a TFSA. No minimum balance is required to open a TFSA.
Where you Can Open a TFSA
There are hundreds of financial institutions in Canada that offer the TFSA. There is only one kind of TFSA; however, different institutions offer a different range of financial products. Here are some examples:
The Canadian big 5 bank branches and most other financial institutions offer a TFSA that allows you to buy mutual funds, hold cash, GICs, term deposits, and possibly ETFs. This is a good choice if you want guaranteed returns or diversified investing.
There are a number of on-line banks such as Tangerine, Simplii Financial, Oaken Financial, and many more that offer the TFSA.
The discount DIY brokerage arms of the big 5 banks give you more choices, including stocks, warrants, bonds and options. There are also standalone brokers like IBKR Canada, Questrade, Qtrade, and Virtual Brokers, among others, that offer this.
Some brokerages and financial advisors also offer TFSAs that give you these investment choices, in different formats such as:
Traditional brokerage, where a stockbroker invests your money (BMO Nesbitt Burns, RBC Dominion Securities and others)
Financial advisor who will invest your money according to a plan you put together with the advisor (TSI Network and many others)
"Robo" advisors such as Wealthsimple, RBC InvestEase, BMO SmartFolio, or Wealthbar
BMO's AdviceDirect, which is a semi-directed hybrid between standalone DIY investing and fully-advised investing, where you operate on a DIY basis but have access to a registered investment advisor (a live person) who can give you suggetions and advice.
Your TFSA may be covered by either CIFP or CDIC insuranceor both. Ask your bank or broker for details.
What You Can Trade and Invest In
You can trade the following:
GICS, mutual funds, term deposits
individual common and preferred stocks listed on an "approved exchange" which is the TSX, TSX-V, NASDAQ, NYSE, and about 20 other exchanges worldwide, but not the US OTC pink sheets. Many examples, such as Suncor, Linamar, Apple, any of the big banks, and many thousands of others, when you want to buy into an individual company
stock-like securities like REITS, ETFs and ETNs, including 2x and 3x leveraged
gold and silver certificates
cash of many countries (CAD/USD/EUGBP/AUD/NZD/JPY/CHF and many others)
government bills and bonds of most countries, subsovereigns like Canadian provincial bills and bonds, and most corporations
options that trade on the Montreal Exchange or various options exchanges in the USA and the rest of the word (see FAQ for details)
gold, silver bullion certificates
shares in certain private companies -- but consult your tax advisor on this
What You Cannot Trade
You cannot trade:
commodity futures contracts
option spread positions (see FAQ for details)
anything that requires a margin account, meaning, a special kind of account that allows you to borrow money directly from the broker against the assets you have in your account and the assets you intend to buy.
crypto (although there exist crypto ETNs that you can buy)
Again, if it requires a margin account, it's out. You cannot buy on margin in a TFSA. Nothing stopping you from borrowing money from other sources as long as you stay within your contribution limits, but you can't trade on margin in a TFSA. You can of course trade long puts and calls which give you leverage.
Rules for Contribution Room
Starting at 18 you get a certain amount of contribution room. According to the CRA: You will accumulate TFSA contribution room for each year even if you do not file an Income Tax and Benefit Return or open a TFSA. The annual TFSA dollar limit for the years 2009 to2012 was $5,000. The annual TFSA dollar limit for the years 2013 and 2014 was $5,500. The annual TFSA dollar limit for the year 2015 was $10,000. The annual TFSA dollar limit for the years 2016 to 2018 was $5,500. The annual TFSA dollar limit for the year 2019 is $6,000. The TFSA annual room limit will be indexed to inflation and rounded to the nearest $500. Investment income earned by, and changes in the value of TFSA investments will not affect your TFSA contribution room for the current or future years. https://www.canada.ca/en/revenue-agency/services/tax/individuals/topics/tax-free-savings-account/contributions.html If you don't use the room, it accumulates indefinitely. Trades you make in a TFSA are truly tax free. But you cannot claim the dividend tax credit and you cannot claim losses in a TFSA against capital gains whether inside or outside of the TFSA. So do make money and don't lose money in a TFSA. You are stuck with the 15% withholding tax on U.S. dividend distributions unlike the RRSP, due to U.S. tax rules, but you do not pay any capital gains on sale of U.S. shares. You can withdraw *both* contributions *and* capital gains, no matter how much, at any time, without penalty. The amount of the withdrawal (contributions+gains) converts into contribution room in the *next* calendar year. So if you put the withdrawn funds back in the same calendar year you take them out, that burns up your total accumulated contribution room to the extent of the amount that you re-contribute in the same calendar year.
E.g. Say you turned 18 in 2016 in Alberta where the age of majority is 18. It is now sometime in 2020. You have never contributed to a TFSA. You now have $5,500+$5,500+$5,500+$6,000+$6,000 = $28,500 of room in 2020. In 2020 you manage to put $20,000 in to your TFSA and you buy Canadian Megacorp common shares. You now have $8,500 of room remaining in 2020. Sometime in 2021 - it doesn't matter when in 2021 - your shares go to $100K due to the success of the Canadian Megacorp. You also have $6,000 worth of room for 2021 as set by the government. You therefore have $8,500 carried over from 2020+$6,000 = $14,500 of room in 2021. In 2021 you sell the shares and pull out the $100K. This amount is tax-free and does not even have to be reported. You can do whatever you want with it. But: if you put it back in 2021 you will over-contribute by $100,000 - $14,500 = $85,500 and incur a penalty. But if you wait until 2022 you will have $14,500 unused contribution room carried forward from 2021, another $6,000 for 2022, and $100,000 carried forward from the withdrawal 2021, so in 2022 you will have $14,500+$6,000+$100,000 = $120,500 of contribution room. This means that if you choose, you can put the $100,000 back in in 2022 tax-free and still have $20,500 left over. If you do not put the money back in 2021, then in 2022 you will have $120,500+$6,000 = $126,500 of contribution room. There is no age limit on how old you can be to contribute, no limit on how much money you can make in the TFSA, and if you do not use the room it keeps carrying forward forever. Just remember the following formula: This year's contribution room = (A) unused contribution room carried forward from last year + (B) contribution room provided by the government for this year + (C) total withdrawals from last year. EXAMPLE 1: Say in 2020 you never contributed to a TFSA but you were 18 in 2009. You have $69,500 of unused room (see above) in 2020 which accumulated from 2009-2020. In 2020 you contribute $50,000, leaving $19,500 contribution room unused for 2020. You buy $50,000 worth of stock. The next day, also in 2020, the stock doubles and it's worth $100,000. Also in 2020 you sell the stock and withdraw $100,000, tax-free. You continue to trade stocks within your TFSA, and hopefully grow your TFSA in 2020, but you make no further contributions or withdrawals in 2020. The question is, How much room will you have in 2021? Answer: In the year 2021, the following applies: (A) Unused contribution room carried forward from last year, 2020: $19,500 (B) Contribution room provided by government for this year, 2021: $6,000 (C) Total withdrawals from last year, 2020: $100,000 Total contribution room for 2021 = $19,500+6,000+100,000 = $125,500. EXAMPLE 2: Say between 2020 and 2021 you decided to buy a tax-free car (well you're still stuck with the GST/PST/HST/QST but you get the picture) so you went to the dealer and spent $25,000 of the $100,000 you withdrew in 2020. You now have a car and $75,000 still burning a hole in your pocket. Say in early 2021 you re-contribute the $75,000 you still have left over, to your TFSA. However, in mid-2021 you suddenly need $75,000 because of an emergency so you pull the $75,000 back out. But then a few weeks later, it turns out that for whatever reason you don't need it after all so you decide to put the $75,000 back into the TFSA, also in 2021. You continue to trade inside your TFSA but make no further withdrawals or contributions. How much room will you have in 2022? Answer: In the year 2022, the following applies: (A) Unused contribution room carried forward from last year, 2021: $125,500 - $75,000 - $75,000 = -$24,500. Already you have a problem. You have over-contributed in 2021. You will be assessed a penalty on the over-contribution! (penalty = 1% a month). But if you waited until 2022 to re-contribute the $75,000 you pulled out for the emergency..... In the year 2022, the following would apply: (A) Unused contribution room carried forward from last year, 2021: $125,500 -$75,000 =$50,500. (B) Contribution room provided by government for this year, 2022: $6,000 (C) Total withdrawals from last year, 2020: $75,000 Total contribution room for 2022 = $50,500 + $6,000 + $75,000 = $131,500. ...And...re-contributing that $75,000 that was left over from your 2021 emergency that didn't materialize, you still have $131,500-$75,000 = $56,500 of contribution room left in 2022. For a more comprehensive discussion, please see the CRA info link below.
FAQs That Have Arisen in the Discussion and Other Potential Questions:
Equity and ETF/ETN Options in a TFSA: can I get leverage? Yes. You can buy puts and calls in your TFSA and you only need to have the cash to pay the premium and broker commissions. Example: if XYZ is trading at $70, and you want to buy the $90 call with 6 months to expiration, and the call is trading at $2.50, you only need to have $250 in your account, per option contract, and if you are dealing with BMO IL for example you need $9.95 + $1.25/contract which is what they charge in commission. Of course, any profits on closing your position are tax-free. You only need the full value of the strike in your account if you want to exercise your option instead of selling it. Please note: this is not meant to be an options tutorial; see the Montreal Exchange's Equity Options Reference Manual if you have questions on how options work.
Equity and ETF/ETN Options in a TFSA: what is ok and not ok? Long puts and calls are allowed. Covered calls are allowed, but cash-secured puts are not allowed. All other option trades are also not allowed. Basically the rule is, if the trade is not a covered call and it either requires being short an option or short the stock, you can't do it in a TFSA.
Live in a province where the voting age is 19 so I can't open a TFSA until I'm 19, when does my contribution room begin? Your contribution room begins to accumulate at 18, so if you live in province where the age of majority is 19, you'll get the room carried forward from the year you turned 18.
If I turn 18 on December 31, do I get the contribution room just for that day or for the whole year? The whole year.
Do commissions paid on share transactions count as withdrawals? Unfortunately, no. If you contribute $2,000 cash and you buy $1,975 worth of stock and pay $25 in commission, the $25 does not count as a withdrawal. It is the same as if you lost money in the TFSA.
How much room do I have? If your broker records are complete, you can do a spreadsheet. The other thing you can do is call the CRA and they will tell you.
TFSATFSA direct transfer from one institution to another: this has no impact on your contributions or withdrawals as it counts as neither.
More than 1 TFSA: you can have as many as you want but your total contribution room does not increase or decrease depending on how many accounts you have.
Withdrawals that convert into contribution room in the next year. Do they carry forward indefinitely if not used in the next year? Answer :yes.
Do I have to declare my profits, withdrawals and contributions? No. Your bank or broker interfaces directly with the CRA on this. There are no declarations to make.
Risky investments - smart? In a TFSA you want always to make money, because you pay no tax, and you want never to lose money, because you cannot claim the loss against your income from your job. If in year X you have $5,000 of contribution room and put it into a TFSA and buy Canadian Speculative Corp. and due to the failure of the Canadian Speculative Corp. it goes to zero, two things happen. One, you burn up that contribution room and you have to wait until next year for the government to give you more room. Two, you can't claim the $5,000 loss against your employment income or investment income or capital gains like you could in a non-registered account. So remember Buffett's rule #1: Do not lose money. Rule #2 being don't forget the first rule. TFSA's are absolutely tailor-made for Graham-Buffett value investing or for diversified ETF or mutual fund investing, but you don't want to buy a lot of small specs because you don't get the tax loss.
Moving to/from Canada/residency. You must be a resident of Canada and 18 years old with a valid SIN to open a TFSA. Consult your tax advisor on whether your circumstances make you a resident for tax purposes. Since 2009, your TFSA contribution room accumulates every year, if at any time in the calendar year you are 18 years of age or older and a resident of Canada. Note: If you move to another country, you can STILL trade your TFSA online from your other country and keep making money within the account tax-free. You can withdraw money and Canada will not tax you. But you have to get tax advice in your country as to what they do. There restrictions on contributions for non-residents. See "non residents of Canada:" https://www.canada.ca/content/dam/cra-arc/formspubs/pub/rc4466/rc4466-19e.pdf
The U.S. withholding tax. Dividends paid by U.S.-domiciled companies are subject to a 15% U.S. withholding tax. Your broker does this automatically at the time of the dividend payment. So if your stock pays a $100 USD dividend, you only get $85 USD in your broker account and in your statement the broker will have a note saying 15% U.S. withholding tax. I do not know under what circumstances if any it is possible to get the withheld amount. Normally it is not, but consult a tax professional.
The U.S. withholding tax does not apply to capital gains. So if you buy $5,000 USD worth of Apple and sell it for $7,000 USD, you get the full $2,000 USD gain automatically.
Tax-Free Leverage. Leverage in the TFSA is effectively equal to your tax rate * the capital gains inclusion rate because you're not paying tax. So if you're paying 25% on average in income tax, and the capital gains contribution rate is 50%, the TFSA is like having 12.5%, no margin call leverage costing you 0% and that also doesn't magnify your losses.
Margin accounts. These accounts allow you to borrow money from your broker to buy stocks. TFSAs are not margin accounts. Nothing stopping you from borrowing from other sources (such as borrowing cash against your stocks in an actual margin account, or borrowing cash against your house in a HELOC or borrowing cash against your promise to pay it back as in a personal LOC) to fund a TFSA if that is your decision, bearing in mind the risks, but a TFSA is not a margin account. Consider options if you want leverage that you can use in a TFSA, without borrowing money.
Dividend Tax Credit on Canadian Companies. Remember, dividends paid into the TFSA are not eligible to be claimed for the credit, on the rationale that you already got a tax break.
FX risk. The CRA allows you to contribute and withdraw foreign currency from the TFSA but the contribution/withdrawal accounting is done in CAD. So if you contribute $10,000 USD into your TFSA and withdraw $15,000 USD, and the CAD is trading at 70 cents USD when you contribute and $80 cents USD when you withdraw, the CRA will treat it as if you contributed $14,285.71 CAD and withdrew $18,75.00 CAD.
OTC (over-the-counter stocks). You can only buy stocks if they are listed on an approved exchange ("approved exchange" = TSX, TSX-V, NYSE, NASDAQ and about 25 or so others). The U.S. pink sheets "over-the-counter" market is an example of a place where you can buy stocks, that is not an approved exchange, therefore you can't buy these penny stocks. I have however read that the CRA make an exception for a stock traded over the counter if it has a dual listing on an approved exchange. You should check that with a tax lawyer or accountant though.
The RRSP. This is another great tax shelter. Tax shelters in Canada are either deferrals or in a few cases - such as the TFSA - outright tax breaks, The RRSP is an example of a deferral. The RRSP allows you to deduct your contributions from your income, which the TFSA does not allow. This deduction is a huge advantage if you earn a lot of money. The RRSP has tax consequences for withdrawing money whereas the TFSA does not. Withdrawals from the RRSP are taxable whereas they are obviously not in a TFSA. You probably want to start out with a TFSA and maintain and grow that all your life. It is a good idea to start contributing to an RRSP when you start working because you get the tax deduction, and then you can use the amount of the deduction to contribute to your TFSA. There are certain rules that claw back your annual contribution room into an RRSP if you contribute to a pension. See your tax advisor.
Pensions. If I contribute to a pension does that claw back my TFSA contribution room or otherwise affect my TFSA in any way? Answer: No.
The $10K contribution limit for 2015. This was PM Harper's pledge. In 2015 the Conservative government changed the rules to make the annual government allowance $10,000 per year forever. Note: withdrawals still converted into contribution room in the following year - that did not change. When the Liberals came into power they switched the program back for 2016 to the original Harper rules and have kept the original Harper rules since then. That is why there is the $10,000 anomaly of 2015. The original Harper rules (which, again, are in effect now) called for $500 increments to the annual government allowance as and when required to keep up with inflation, based on the BofC's Consumer Price Index (CPI). Under the new Harper rules, it would have been $10,000 flat forever. Which you prefer depends on your politics but the TFSA program is massively popular with Canadians. Assuming 1.6% annual CPI inflation then the annual contribution room will hit $10,000 in 2052 under the present rules. Note: the Bank of Canada does an excellent and informative job of explaining inflation and the CPI at their website.
Losses in a TFSA - you cannot claim a loss in a TFSA against income. So in a TFSA you always want to make money and never want to lose money. A few ppl here have asked if you are losing money on your position in a TFSA can you transfer it in-kind to a cash account and claim the loss. I would expect no as I cannot see how in view of the fact that TFSA losses can't be claimed, that the adjusted cost base would somehow be the cost paid in the TFSA. But I'm not a tax lawyeaccountant. You should consult a tax professional.
Transfers in-kind to the TFSA and the the superficial loss rule. You can transfer securities (shares etc.) "in-kind," meaning, directly, from an unregistered account to the TFSA. If you do that, the CRA considers that you "disposed" of, meaning, equivalent to having sold, the shares in the unregistered account and then re-purchased them at the same price in the TFSA. The CRA considers that you did this even though the broker transfers the shares directly in the the TFSA. The superficial loss rule, which means that you cannot claim a loss for a security re-purchased within 30 days of sale, applies. So if you buy something for $20 in your unregistered account, and it's trading for $25 when you transfer it in-kind into the TFSA, then you have a deemed disposition with a capital gain of $5. But it doesn't work the other way around due to the superficial loss rule. If you buy it for $20 in the unregistered account, and it's trading at $15 when you transfer it in-kind into the TFSA, the superficial loss rule prevents you from claiming the loss because it is treated as having been sold in the unregistered account and immediately bought back in the TFSA.
Day trading/swing trading. It is possible for the CRA to try to tax your TFSA on the basis of "advantage." The one reported decision I'm aware of (emphasis on I'm aware of) is from B.C. where a woman was doing "swap transactions" in her TFSA which were not explicitly disallowed but the court rules that they were an "advantage" in certain years and liable to taxation. Swaps were subsequently banned. I'm not sure what a swap is exactly but it's not that someone who is simply making contributions according to the above rules would run afoul of. The CRA from what I understand doesn't care how much money you make in the TFSA, they care how you made it. So if you're logged on to your broker 40 hours a week and trading all day every day they might take the position that you found a way to work a job 40 hours a week and not pay any tax on the money you make, which they would argue is an "advantage," although there are arguments against that. This is not legal advice, just information.
The U.S. Roth IRA. This is a U.S. retirement savings tax shelter that is superficially similar to the TFSA but it has a number of limitations, including lack of cumulative contribution room, no ability for withdrawals to convert into contribution room in the following year, complex rules on who is eligible to contribute, limits on how much you can invest based on your income, income cutoffs on whether you can even use the Roth IRA at all, age limits that govern when and to what extent you can use it, and strict restrictions on reasons to withdraw funds prior to retirement (withdrawals prior to retirement can only be used to pay for private medical insurance, unpaid medical bills, adoption/childbirth expenses, certain educational expenses). The TFSA is totally unlike the Roth IRA in that it has none of these restrictions, therefore, the Roth IRA is not in any reasonable sense a valid comparison. The TFSA was modeled after the U.K. Investment Savings Account, which is the only comparable program to the TFSA.
The UK Investment Savings Account. This is what the TFSA was based off of. Main difference is that the UK uses a 20,000 pound annual contribution allowance, use-it-or-lose-it. There are several different flavours of ISA, and some do have a limited recontribution feature but not to the extent of the TFSA.
Is it smart to overcontribute to buy a really hot stock and just pay the 1% a month overcontribution penalty? If the CRA believes you made the overcontribution deliberately the penalty is 100% of the gains on the overcontribution, meaning, you can keep the overcontribution, or the loss, but the CRA takes the profit.
Speculative stocks-- are they ok? There is no such thing as a "speculative stock." That term is not used by the CRA. Either the stock trades on an approved exchange or it doesn't. So if a really blue chip stock, the most stable company in the world, trades on an exchange that is not approved, you can't buy it in a TFSA. If a really speculative gold mining stock in Busang, Indonesia that has gone through the roof due to reports of enormous amounts of gold, but their geologist somehow just mysteriously fell out of a helicopter into the jungle and maybe there's no gold there at all, but it trades on an approved exchange, it is fine to buy it in a TFSA. Of course the risk of whether it turns out to be a good investment or not, is on you.
Remember, you're working for your money anyway, so if you can get free money from the government -- you should take it! Follow the rules because Canadians have ended up with a tax bill for not understanding the TFSA rules. Appreciate the feedback everyone. Glad this basic post has been useful for many. The CRA does a good job of explaining TFSAs in detail at https://www.canada.ca/content/dam/cra-arc/formspubs/pub/rc4466/rc4466-19e.pdf
Unrelated but of Interest: The Margin Account
Note: if you are interested in how margin accounts work, I refer you to my post on margin accounts, where I use a straightforward explanation of the math behind margin accounts to try and give readers the confidence that they understand this powerful leveraging tool.
Have you ever traded with statistical edge?Our Allen trade talks about backing up the trading network and leveraging it from excellent newspapering. This is a stage that is undermined by many traders but fairly, it can be a crucial factor in boosting your trust and believing in your system. For those interested in this sort of research, you can check out the FTMOStatistical Application. Trading with a Statistical edge Although many traders back-test and record their trades to verify the trading system 's feasibility, monitoring and using the data to maximize both your stop loss and profit goal is a tremendous advantage. Two of the most critical pieces of data that I record when reporting trades is the drawdown and the benefit potential. The drawdown, to be sure, is how far a trade goes against my place before it goes in my favour. Whereas the benefit potential is the maximum distance from my entry which the trade moves in my favor. It isn't important and it's uncommon, in general, that I actually exit the trade. Yet definitely coming out at or as close as can be. Firstly, I record my trades in two ways, using screenshots of the charts themselves where I annotate my entry, date, type of trade and all other relevant details related to my methodology, such as strength and weakness analysis , multiple time frame analysis and correlation. I also note on the map the drawdown and benefit potential of the trade. Then I go through my Excel spreadsheet with main details. See "excel" below. Excel spreadsheet with main details. This includes the date, day, session, pair, time, route, entry price, closing price, type of setup, type of entry, type of exit, drawdown, potential for benefit and outcome. I then let excel do all the heavy lifting for myself as I can sort my trades numerous ways, by day, by session, by pair, by route, by type of set-up etc. But where the really cool stuff is under the "Mind-blowing stats" tab where I have some of the above filterable statistics that will help me to optimize both my stop loss and my benefit goal. Here is a summary of the specification. When you use a risk percentage account to calculate your position size (as you should), so the lower the pause, the larger a position size you will trade in. The stop must, therefore, have a high likelihood of remaining. The vast majority of trading books, guides, videos, etc., advise that after a recent high / low swing, the stop will be many pips. But my trade documents helped me to come up with a statistical advantage for my stoppage placement. As can be seen in the "Drawdown" tag, Trading my Type 1 BO (breakout out) on GBPAUD, 79.55 percent of the time my drawdown was less than 25 pips, although it was just 81.82 percent at 30 pips and 84.09 percent at 35 pips. Statistical Edge Trading So when using a larger pause, an extra loss or 2, the advantage of having a greater size of the place and thereby netting more money makes the extra loss(s) inconsequential. Furthermore, the income goal can also be optimized. Looking at the "Profit Potential" connection and remaining on GBPAUD again for my Type 1 BO trades, we can easily see that almost 80 percent of the time, those trades get between 20 and 30 pips. Statistical Edge Trading (b) It is a perfect place to take off 1/2 of the spot and push the stop to flat. So we can let the rest of the half run to about 50 pips where 59.09 percent of the trades touch. Obviously market conditions aren't always the same, so if you can recognise when they are, i.e. linked moves or strengthening or weakening other classes (commodity pairs or safe haven pairs), then you can make educated decisions about how far a trade will go. Statistical Edge Trading (meme) I hope this information 's helpful to you. Eva " Forex " Canares . Cheers and Profitable Trading to All. About FTMO - They fund forex traders. Just Pass their risk management rules and begin trading for their company. They'll provide you capital up to $300k USD for trading the financial markets. 70% of profits you keep and losses are covered by them. How does it work? How to Become a Funded Forex ,Stocks or CryptoCurrency Trader?
Hey there. It's tax season and the ATO (Australian IRS) are on to me! They have asked for my capital gains on crypto investments for the first time this year, and whilst I've sent the logs from Binance to my accountant this time, I see the necessity of having some way of tracking the profit/loss throughout the year, not only at tax time. I have been investigating Coinmarketcap's API and trying to incorporate it into an Excel spreadsheet which will update the price, and subsequently the profit and loss of my folio in real time but I'm having a great deal of trouble getting it to pull the figures in for the coins I'm holding in Australian Dollars (or at all actually, I'm not a code minded person). After friggin around with this most of the day, it is beginning to seem all too hard. I have downloaded Gem app on my phone which connects to Binance, which is awesome. It's really a beautiful app, but I'd like to have more control over the figures and have the option of adding holdings that are on paper or hardware wallets too. Any suggestions? How do you track your trades and P/L?
I wasnt able to find an ability to export excel/cvs spreadsheets from the crypto.com exchange. Tax time will be a nightmare if we have to manually enter all our trades. Is this feature coming on the road map at all?
Seeking Excel Pro Who Can Port My BTC Trades Into a Spreadsheet
As the title suggests I am seeking someone who is fluent in Microsoft Excel or other spreadsheet software that can take an account statement from a margin trading exchange where I trade, and turn it into an Excel spreadsheet that is formatted a different way (the format is required for my tax software). This is a bit over my head, so I would like to have some assistance. I am looking for this in one of two options, depending on your price: A) Someone to do one or two transactions for me, with instructions on how to do the rest myself. B) Someone to do all the transactions for me. Potentially thousands of trades. Please send me a DM with your fee in BTC and which method you prefer (A or B). I will weigh out my options and select the right candidate. If at all possible, having some type of reference would be great and move you to the front of the line. Payment will be sent after the spreadsheet is completed - to be clear - however, I am a somewhat well-known journalist in the crypto space, and I will publicly tweet details that I commit to making this payment, whatever we agree upon. A small payment is not worth my reputation and career. I really would like this done and would be more than happy to see the payment is through. I'd even be willing to post public blockchain information to show the transaction is completed after. EDIT ---- Confirming this was completed by a very helpful Redditor. They offered such a low price, I paid ten times the amount they had requested as a thank you for their fast work and turnaround.
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:
We had a new breed of speculators come in during the NovembeDecember timeframe after media made cryptocurrency mainstream following the Bitcoin 10K landmark. While cryptocurrency markets have always had too much hype, the latest rise wasn't just over-enthusiasm in fundamentally sound cryptocurrencies like Monero and Ethereum, but mass inflows of fiat into vaporware and complete nonsense without any use case. Many people came in to essentially gamble on symbols on an exchange, and are thus short term oriented and quick to sell on any slight downturn, which such further adds to selling pressure.
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:
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.
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:
Slow down and research each crypto that you're buying for at least a week.
Don't buy something just because it has risen.
Don't exit a position just because it has declined.
Invest only as much as you can afford to lose.
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:
Total Crypto Market Cap
Jan 1, 2015:
Jan 1, 2017:
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:
Core holdings - This is the exchange pairing cryptos and those that are well established. These are almost sure to be around in 5 years, and will recover after any bear market. The Coinbase pairs (Bitcoin, Litecoin and Ethereum) are in this class of risk, and I would also argue Monero.
Medium Risk Speculative - These would be cryptos which generally have a working product and niche, but higher risk than Core. Things like ZCash and Ripple, relatively established history but still uncertainty over long term viability.
High Risk Speculative - This is anything created within the last few months, ICOs, low caps, shillcoins...etc. Most cryptos are in this category.
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:
50-70% for newbies in Low Risk Core, then you can go down to 30% as you gains confidence and experience
Always try to keep at least a 1/3rd in safe core positions
Don't go all in on speculative picks.
Some more core principles on risk management to consider:
Diversify across sectors and rebalance your allocations periodically.
Consider using dollar cost averaging to enter a position. This generally means investing a X amount over several periods, instead of at once. You can also use downward biased dollar cost averaging to mitigate against downward risk. For example instead of investing $1000 at once in a position at market price, you can buy $500 at the market price today then set several limit orders at slightly lower intervals (for example $250 at 5% lower than market price, $250 at 10% lower than market price). This way your average cost of acquisition will be lower if the crypto happens to decline over the short term.
Don't have more than 5-10% of your net worth in crypto.
Have the majority of your holdings in things you feel good holding for at least 2 years. Don't use the majority of your investment for day trading or short term investing.
Remember you didn't actually make any money until you take some profits, so take do some profits when everyone else is at peak FOMO-ing mode.
Have some fiat in reserve at a FDIC-insured exchange (ex. Gemini), and be ready to add to your winning positions on a pullback. This should be part of your entry strategy.
Consider what level of loss you can't accept in a position with a high risk factor, and use stop-limit orders to hedge against sudden crashes. Set you stop price at about 5-10% above your lowest limit. Stop-limit orders aren't perfect but they're better than having no hedging strategy for a risky microcap in case of some meltdown. Only you can determine what bags you are unwilling to hold.
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:
becoming a store-of-value equal to gold (a $6.4 trillion value), with a .25% probability of occurring
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:
Daily Transactions (last 24hrs)
Active Addresses (Peak 1Yr)
Metcalfe Ratio (Transactions Based)
Metcalfe Ratio (Address Based)
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.
I'm a new crypto day trader and was wondering if there's a service or script that can convert the Binance Trade History to a nice Excel Spreadsheet, so I'll be able to log all my trades without having to type them all. I know that you can export the trade histroy from Binance, but this file doesn't show profit/losses on each trade. Since the buy and sell orders are seperated in the binance export, I don't know how to implement this in an Excel spreadsheet (if that's even possible). Anyone who has a solution for this?
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
Currency 13 coins
Platform 25 coins
Ecosystem 9 coins
Privacy 10 coins
Currency Exchange Tool 8 coins
Gaming & Gambling 5 coins
Misc 15 coins
Social Network 4 coins
Fee Token 3 coins
Decentralized Data Storage 4 coins
Cloud Computing 3 coins
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:
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.
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.
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.
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.
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.
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.
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.
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.
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
Bitcoin Atom: Atomic Swaps and hybrid consenus. This looks like the only Bitcoin clone that actually is looking to innovate next to Bitcoin Cash.
Dogecoin: Litecoin fork, fantastic community, though lagging behind a bit in technology.
Bitcoin Gold: A bit better security than bitcoin through ASIC resistant algorithm, but that's it. Not that interesting.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
QTUM: Enables Smart contracts on the Bitcoin blockchain. Useful.
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.
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.
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.
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.
Ontology: Similar to Neo. Interesting coin
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.
Nxt: Similar to Lisk
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.
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.
Neblio: Similar to Neo, but 30x smaller market cap.
NEM: Is similar to Neo No marketing team, very high market cap for little clarilty what they do.
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.
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.
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
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.
Waves: Decentralized exchange and crowdfunding platform. Let’s companies and projects to issue and manage their own digital coin tokens to raise money.
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.
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.
WTC: Combines blockchain with IoT to create a management system for supply chains Interesting
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
Aion: Aion is the token that pays for services on the Aeternity platform.
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.
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.
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
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.
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
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.
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.
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.
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.
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.
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.
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.
Cryptonex: Fiat and currency exchange between various blockchain services, similar to REQ.
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
Kyber: network Exchange between cryptocurrencies, similar to REQ. Features automatic coin conversions for payments. Also offers payment tools for developers and a cryptocurrency wallet.
Achain: Building a boundless blockchain world like Req .
Req: Exchange between cryptocurrencies.
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.
Loopring: A protocol that will enable higher liquidity between exchanges and personal wallets.
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.
Storm: Mobile game currency on a platform with 9 million players.
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.
Electroneum: Mobile game currency They have lots of technical problems, such as several 51% attacks
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.
OMG: Omise is designed to enable financial services for people without bank accounts. It works worldwide and with both traditional money and cryptocurrencies.
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.
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.
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.
Revain: Legitimizing reviews via the blockchain. Interesting concept, though market not as big.
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.
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.
Veritaseum: Is supposed to be a peer to peer gateway, though it looks like very much like a scam.
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.
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.
Hshare: Most likely scam because of no code changes, most likely pump and dump scheme, dead community.
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.
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.
Ncash: End to end encrypted Identification system for retailers to better serve their customers .
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.
Mithril: As users create content via social media, they will be rewarded for their contribution, the better the contribution, the more they will earn
Steem: Like Reddit, but voting with money. Already launched product and Alexa rank 1,000 Thumbs up.
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.
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.
BNB: Fee token for Binance
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.
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.
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.
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.
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.
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.
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.
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.
DGD: Platform of the Stablecoin DGX. Every DGX coin is backed by 1g of gold and make use proof of asset consensus.
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.
There are different ways to make some money from crypto but among them, trading is perhaps the most profitable one.. If you want to get started, you can begin with just a crypto wallet, some funds, and an exchange platform. After you’ve secured those, maximize the opportunities you can have with trading cryptocurrencies by making use of certain trading tools. Behold, the Ultimate Guide to Importing Cryptocurrency Data! To import cryptocurrency data into a spreadsheet or an Excel document, you could either… Use Cryptofinance (which uses CoinMarketCap behind the scenes) with Google Docs. Download a JSON file from CoinMarketCap Make Excel API calls to CoinMarketCap Method 1: Use Google Sheet’s Cryptofinance (My Personal Favorite): How […] 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. Google Spreadsheet To Track Btc/altcoin Trading On Monthly Basis. Track your altcoin/BTC investment portfolio with Google Spreadsheets Google Spreadsheet To Track BTC/Altcoin Trading on Monthly Basis Share on Facebook Share Share on Twitter Tweet Share Share Investments in crypto-currencies are among one of the most interesting findings for me this year. The spreadsheet lists OHLC (Open,High,Low,Close) Prices from the crypto markets and makes it simple for you to create any auto trading algorithms/strategies using excel formulas and cells! You can choose any crypto currency pairs from Binance Exchange (more than 500 crypto-pairs).
Quick explanation of my risk/reward spreadsheet. Click this link to download for free: https://drive.google.com/open?id=0BzJh5rMoj57MMjdINVNXaUdaSXc https://CryptoInvestingInsider.com Click to get our free course and see how to make high returns in the cryptocurrency space. https://CryptoInvestingInsider.... How to Create Crypto portfolio using Power Query in Excel (pull data from CoinMarketCap ... Str82ThePoint 7,576 views. 5:03. Trading Journal - My Excel Spreadsheet Trading Journal (+ Free Trading ... Excel Trading Spreadsheet created with VBA. Enters up to 80 orders at a time with one click! www.ExcelTradingSpreadsheet.com. TOP 5 Cryptocurrency Trading Bots - Crypto Trading Bot Review - Duration: 8:09. Marc Zwygart 234,035 views. 8:09. ... Cryptocurrency Excel Spreadsheet Tracker - Duration: 7:29.