Through The Spreadsheet,Traders are Introduced to

Neo

[link]

Horizen

Horizen is an inclusive ecosystem built on its massively scalable blockchain platform where everyone is empowered and rewarded for their contributions. Launched in 2017, our leading-edge platform enables real-life uses outside of our cryptocurrency, ZEN.
[link]

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

I made a Cryptocurrency tracking spreadsheet complete with live crypto price updates, moon math, and a full history of your Portfolio and trading performance (Updated).
This is a spreadsheet that I have developed for myself gradually over the last couple years. I have found it very helpful for keeping track of my bitcoin holdings (great for tax purposes). No need to trust third party apps to keep your personal information - track it yourself.
There is a lot in here including;
Automatically updates prices from coinmarketcap. The top 100 coins included. Just select which ones you want to track by typing in the name.
You can even choose your local Fiat currency and get live conversion rates for any country.

https://preview.redd.it/wwdn2wb1w1q31.png?width=1536&format=png&auto=webp&s=d4ea1b16931969c97f7885881e05a090e61b3939
You don't need to record details of every trade. Just keep track of your crypto purchases (from fiat) and what coins you currently hold. The spreadsheet will calculate the rest and keep a record of how your portfolio and holdings have changed over time (it logs this data every time you save the sheet)
https://preview.redd.it/av1zv113w1q31.png?width=1380&format=png&auto=webp&s=461c5d0563f12016d8197a6cc1076eec3f2064c4

https://preview.redd.it/exjlvbj4w1q31.png?width=602&format=png&auto=webp&s=52a06ee3fe6d9b1cfa92c31807ed0f0dc503df00
I find this very handy to see if your trading is actually profitable compared to the HODL method.
https://preview.redd.it/124eage5w1q31.png?width=929&format=png&auto=webp&s=3a0e1b625463e7d732e2a844c67297d45fa2dca1
Oh yes and there are plenty of 'moon math' and analytics to see how bitcoin is trending. This includes a full history of bitcoins price which updates every time you open the sheet.
https://preview.redd.it/hen0sdb7w1q31.png?width=602&format=png&auto=webp&s=d95ec2f3fe7fcb4834a995baf05b158ed7aa8d4f
This version has some bug fixes and a few new features including a 'Stock to flow' price prediction model;

https://preview.redd.it/75ufw499w1q31.png?width=881&format=png&auto=webp&s=f4df7e89286f0a0a470a7e3f67a5666188507c73
free download from here. Instructions inside. You will need macros enabled if you want it to do the fancy stuff.
https://www.dropbox.com/s/5vq8lglmnrt9dfv/Cryptoprices10%20-%20For%20others.xlsm?dl=0
Let me know if you have any issues.
submitted by Fly115 to CryptoCurrency [link] [comments]

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

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

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

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

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

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

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

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

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

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

submitted by scgco to GGCrypto [link] [comments]

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

I made bitcoin tracking spreadsheet complete with live crypto price updates, moon math, and a full history of your Portfolio and trading performance (Updated).
This is a spreadsheet that I have developed for myself gradually over the last couple years. I have found it very helpful for keeping track of my bitcoin holdings (great for tax purposes). No need to trust third party apps to keep your personal information - track it yourself.
There is a lot in here including;
Automatically updates prices from coinmarketcap. The top 100 coins included. Just select which ones you want to track by typing in the name.
You can even choose your local Fiat currency and get live conversion rates for any country.

https://preview.redd.it/t0bg64lyt1q31.png?width=1536&format=png&auto=webp&s=040df5efdc4fcc2ae8b73b7dc1420ae9c0ea5c5a
No need to record details of every trade. Just keep track of your crypto purchases (from fiat) and what coins you currently hold. The spreadsheet will calculate the rest and keep a record of how your portfolio and holdings have changed over time (it logs this data every time you save the sheet)
https://preview.redd.it/2wc7s07ut1q31.png?width=1380&format=png&auto=webp&s=5d56680f5ea83ed3c57b16668fc6b086f35c2b46

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

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

https://preview.redd.it/s2uymtibu1q31.png?width=1455&format=png&auto=webp&s=546065830266655eafbb25b4b8bcfd29fa6261f3
This version has some bug fixes and a few new features including a 'Stock to flow' price prediction model;

https://preview.redd.it/phvt1lr2t1q31.png?width=881&format=png&auto=webp&s=5ea3d6d1d7a031c3834a1f878ccd752d8530bfdc
free download from below. Instructions inside. You will need macros enabled if you want it to do the fancy stuff.
https://www.dropbox.com/s/5vq8lglmnrt9dfv/Cryptoprices10%20-%20For%20others.xlsm?dl=0
Let me know if you have any issues.
submitted by Fly115 to Bitcoin [link] [comments]

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

I made a Cryptocurrency tracking spreadsheet complete with live crypto price updates, moon math, and a full history of your Portfolio and trading performance (Updated). submitted by scgco to GGCrypto [link] [comments]

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

I made a Cryptocurrency tracking spreadsheet complete with live crypto price updates, moon math, and a full history of your Portfolio and trading performance (Updated). submitted by Mixagen to u/Mixagen [link] [comments]

Google Spreadsheet for Historical Crypto Market Data Recording & Trading Strategy Backtesting

Google Spreadsheet for Historical Crypto Market Data Recording & Trading Strategy Backtesting submitted by dsonder to CryptoCurrencyTrading [link] [comments]

Google Spreadsheet for Historical Crypto Data Recording and Trading Strategy Backtesting

Google Spreadsheet for Historical Crypto Data Recording and Trading Strategy Backtesting submitted by dsonder to Bitcoin [link] [comments]

Spreadsheet for crypto exchanges that support Canadian CAD. Includes: funding, withdrawing, and trading options ands fees. Compare for yourself!

submitted by Enecsehtnokcab to BitcoinCA [link] [comments]

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

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

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

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

This data gets saved every time you save the spreadsheet.

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

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

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


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

I made a complete crypto portfolio tracking spreadsheet (excel) with live price updates and a full history of your Portfolio and trading performance

I made a complete crypto portfolio tracking spreadsheet (excel) with live price updates and a full history of your Portfolio and trading performance
This is a spreadsheet that I have developed for myself over the last year or so. I have found it very helpful for keeping track of my crypto holdings (great for tax purposes) and how well my trading decisions have been (not great). I figure it's time to share.

There is a lot in here including;

Automatically updates crypto prices from coinmarketcap. Nearly 2000 coins. Just select which ones you want to track by typing in the name.
You can even choose your local Fiat currency and get live conversion rates for any country.
https://preview.redd.it/ts3717egfkk11.png?width=602&format=png&auto=webp&s=c4ff0033cab639e9e8ae7809cba8faab4fa3173d

No need to record details of every trade. Just keep track of your crypto purhcases (from fiat) and what coins you currently hold. The spreadsheet will calculate the rest and keep a record of how your portfolio and holdings have changed over time.
https://preview.redd.it/zeon8s8xfkk11.png?width=602&format=png&auto=webp&s=d60791ce434aa6c3b33cdda2f2bf8b22643b1b6d
This data gets saved every time you save the spreadsheet.
https://preview.redd.it/gne0jd2agkk11.png?width=602&format=png&auto=webp&s=4c4bd70ab88f597b66a5a552b111a160aedcf07d
I find this very handy to see if your trading is actually profitable compared to the HODL method.
https://preview.redd.it/x71gvgj2ikk11.png?width=929&format=png&auto=webp&s=0f7987b48997a97f18ad30aa53bad369de6ddab4
Oh yes and there are plenty of 'moon math' and analytics to see how bitcoin is trending and how far off you are from a lambo. This includes a full history of bitcoins price which updates every time you open the sheeet.

https://preview.redd.it/cyn98q63hkk11.png?width=602&format=png&auto=webp&s=094ee5528d48984b29f47e1aba9ba208f2086b4d
Plenty more bits and pieces that I have tinkered with over time.
free download from here. Instructions inside. You probably need a fairly recent version of microsft excel with macros enabled (if you want it to do the fancy stuff).
https://www.dropbox.com/s/2n8xpn9r8oyetli/Cryptoprices9%20-%20For%20others.xlsm?dl=0

Let me know if you have any issues.

submitted by Fly115 to CryptoCurrency [link] [comments]

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
Databases currently included (updated daily)
All datasets are available as a tab-delimited, CSV file. The datasets are a mix between raw tick data, OHLCV, spreads, mining and economic statistics. They can be used for backtesting, analysis, and charting.
Investing/Trading Templates and Strategies
On The Horizon
Potential Ideas
I'm open to answer questions or talk more about the project if there's interest. Hope it helps the traders and investors out there.
John
submitted by 1kexperimentdotcom to CryptoMarkets [link] [comments]

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

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

How can I change the crypto amount to dollar amount in the attached crypto currency trade spreadsheet?

I'm trying to edit an excel spreadsheet which I use to log trades I make in crypto currency/forex and calculates the data into a summary on another sheet. Everything on it is fine, except for the 7th column which asks "crypto amount" (how much of an asset I bought/sold) needs to have the value in the specific crypto currency, but I need to somehow change this to USD, and of course have the summary calculated correctly.
Does anyone know how to do this?
This is the spreadsheet: https://we.tl/t-pEMoOpQgLR
submitted by Spanki003 to excel [link] [comments]

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
submitted by everyonesastudent to CryptoCurrency [link] [comments]

Bitcoin Newcomers FAQ - Please read!

Welcome to the /Bitcoin Sticky FAQ

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

Key properties of Bitcoin

Where can I buy bitcoins?

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

Securing your bitcoins

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

Watch out for scams

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

Where can I spend bitcoins?

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

Merchant Resources

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

Can I mine bitcoin?

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

Earning bitcoins

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

Bitcoin-Related Projects

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

Bitcoin Units

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

Chainlink analysis - my thoughts and research

Necessary Disclaimer: no rule breaking intended. No price manipulation intended. I only want to share verifiable facts/links and my analysis. If I am doing anything against the rules please let me know and I will do my best to fix it ASAP. I trade crypto, including LINK, and I am currently short on LINK. This is not financial advice; this is just for my own record and to start a discussion for anyone who might want more transparency around LINK.

TL;DR:

I believe there is a lot of misinformation, uncertainty, and unanswered questions about the LINK token, the Chainlink ecosystem, the SmartContract parent company. I also believe that LINK's current price is unjustified based on fundamental factors like usage/business case/current customers/future potential. So I'm raising some points and asking some questions.
What is this post? Why should I care? How do I use it?
Read or skim it. It's about the LINK token, the Chainlink ecosystem, and the parent company SmartContract. It's about why I believe the price of the LINK token may be currently driven mostly by hype and not backed by standard market fundamentals like usage/economics.
Update 9 AUG: reorganizing, rewriting this post and moving supporting data/sources into "appendix" comments below on this post. The previous versions of this post and my comments elsewhere were too emotionally charged and caused more division rather than honest, evidence-based, productive discussion and I sincerely apologize for that. I have now rewritten it and will continue to update it.

PARTNERSHIPS

Who has Chainlink partnered with? Who is using Chainlink's technology and network? Who is contributing to developing Chainlink?
Google - this is the pinned tweet on Chainlink's official page. Nothing there about Google using Chainlink services or co-developing with them. Just that blockchains/oracles CAN use google cloud services (APIs?). This is Google Cloud's June 13, 2019 blog post: https://cloud.google.com/blog/products/data-analytics/building-hybrid-blockchain-cloud-applications-with-ethereum-and-google-cloud
Oracle - (TODO. This seems to have potential as some product manager at Oracle has posted that chainlink integration is coming Q3/Q4 of 2020)
SWIFT - the best they've got is a 30 second video with NOBODY from SWIFT present, with a *hypothetical* use case using SWIFT API.
Intel This is the only google result for "chainlink site:intel.com", and it casually mentions that Intel's TEE (trusted execution environment) technology can be used to improve the security of oracles/blockchains. Nothing about Intel themselves using or developing with Chainlink. https://software.intel.com/content/www/us/en/develop/articles/new-confidential-computing-solutions-emerge-on-the-hyperledger-avalon-trusted-compute.html
Another 240+ claimed project integrations:
[TODO] There are so many to keep track of. Every week or even more frequent is yet another integration *announcement*
Current DeFi usage: we've heard that Chainlink "secures" $1 billion in DeFi. But that's not in value locked: https://defipulse.com/ (LINK doesn't even appear on that list). That's just with DeFi data supposedly being priced using Chainlink nodes.
EG Synthetix:
https://blog.synthetix.io/chainlink-decentralizes-first-wave-of-synthetix-price-feeds/ yet where does Synthetix actually PAY to use an oracle? Not visible on-chain, maybe someone will find it.
https://defipulse.com/blog/3-defi-dapps-starting-2020-off-strong/ "... Chainlink's following includes partnerships big and small, including Intel and Google Cloud services" example of misleading/exaggerated partnership claims being circulated.

Chainlink's ROADMAP

Threshold signatures, staking, on-chain SLAs:
How real are these, is there a roadmap, how will this benefit users, is there any evidence of users currently *wanting* to use chainlink but needing these features and actively waiting for Chainlink to launch these?
Staking: for there to be a valid incentive for users to stake LINK, it has to return around 5% annually because anything substantially under that would have users putting their money elsewhere (https://www.stakingrewards.com/cryptoassets) (not counting speculative capital gains in terms of LINK's price, but price gain per token/coin applies to all other crypto projects as well).
Currently, for stakable cryptos, around 30-80% of their total supply is staked, and a good adjusted reward is on the order of 5% as well (some actually negative, some 10%+). The promise of staking incentivises people to buy and hold more LINK tokens (again, many other crypto projects have staking already live). That 5% reward will ultimately have to come from the customers who pay Chainlink oracle nodes to use their services, so it's an extra 5% fee for them. Of course, in the near future, the staking rewards *could* be subsidized by the founders' reserve wallets.
Threshold signatures: addressed below in a comment.
On-chain SLAs: [TODO]
Here's supposedly Chainlink's agile/project planning board. (TODO: verify that it is indeed Chainlink's, and then analyse it)
https://www.pivotaltracker.com/n/projects/2129823

LINK wallet addresses

As LINK is an ERC20 token on the Ethereum blockchain, all its movements are visible, all the way from the genesis creation of 1,000,000,000 LINK tokens through to aggregator nodes through to cashing out on exchanges. Below are some examples and some reasons why this may be concerning to investors/holders of LINK.
This is one LINK address whale with over 6 million LINK. Looks like some of the funds end up on a Turkish exchange Paribu. https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0xc6bed363b30df7f35b601a5547fe56cd31ec63da This wallet has moved out >200,000 LINK in the last 24 hours. Don't know where, go trace it.
Typical data provider example. Lots of named Chainlink oracle nodes pay this address: https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0x72f3dff4cd17816604dd2df6c2741e739484ca62 Usually 0.16 LINK to this address every few minutes, sometimes 2 LINK. This data provider has sent out ~11,620 LINK out to the following wallet: https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0xa5d0084a766203b463b3164dfc49d91509c12dab That wallet has cashed out 9,560 LINK to 1inch.exchange (a DEX) over the past year. Has also transferred 6000 LINK to a currently loaded wallet (possibly exchange account ready to sell?): https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0x088d50c0bb5381a1205d1182cc21496c6fdc4c62 Another destination accumulation wallet (~493,000 LINK with no out transfers yet) https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0x7758e507850da48cd47df1fb5f875c23e3340c50 (unrelated but a sell order of this size would drop LINK's price by 10-30% on Binance, someone check my maths on this) Now tracing back who funds the 0x72f3... data provider, we see a number of named Chainlink Aggregator nodes. Picking one at random, say the TUSD/ETH one: https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0x73ead35fd6a572ef763b13be65a9db96f7643577 It was last funded March 12 2020 with 5000 LINK. Tracing back the funds we ultimately come to the genesis wallet of the Chainlink network itself, the original source of the 1,000,000,000 LINK tokens in existence. (side note: some interesting-looking transactions there) This is the first child of the genesis wallet that received 100,000,000 from the genesis wallet. https://etherscan.io/tokentxns?a=0xf37c348b7d19b17b29cd5cfa64cfa48e2d6eb8db Last time this wallet transferred out was YESTERDAY for 500,000 LINK. Now this doesn't prove anything, DYOR, but to me it looks like the genesis wallets are slowly cashing out through the aggregator nodes, making it look like the oracle node network is being actively used (which it is, but it's not the end customers like AAVE/NEXO paying the LINK required to power oracles, it's SmartContract itself). I know that this is just ONE aggregator node, but I've seen the same behaviour from their other named nodes - go check for yourselves.
If you trace chainlink oracle funds to their source, you can find some of the original addresses. Some of these early on (around 1000 days ago) were linked to AfroDex labs, which looks like now doesn’t work. http://afrodex.net/#!/trade/AfroX-ETH
Who currently pays Chainlink nodes?
How much of the revenue that Chainlink nodes receive is from potentially third party customers vs internal funding by the Chainlink team wallets?
For example, this is the "Chainlink: LINK / USD Aggregator" wallet.
It has had a total 8,200 LINK deposited from 5 transactions in round amounts (on any of the below links, click the "Analytics" tab to see In/Out balance history), and has so far paid out ~5,156 LINK.
https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0x32dbd3214ac75223e27e575c53944307914f7a90
It typically pays ~10 wallets 0.16 Link each, a few times an hour, like so:
https://etherscan.io/tx/0x02c595981b935a57cfbe6170656181faac9a16d7a33a123930a716c4abec615a ($45 in ETH fees to transfer $22 worth of LINK, sounds like a lot of overheads)
Where does this aggregator wallet get its LINK funding from?
From ONLY here: https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0x27158157136384c713bc09a0a7ae81c8391d7f11 (current net balance ~50,000 LINK, total ~5,000,000 million in and out)
Which in turn gets it from ONLY these three, in HUGE amounts:
https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0xf37c348b7d19b17b29cd5cfa64cfa48e2d6eb8db (6,000,000 LINK)
https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0xaf40738c6f940519516e043f924b8d05fc0292b8 (just a jump address into the one above, only 3 total tx)
https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0x1f9e26f1c050b5c018ab0e66fcae8e4394eb0165 (147,000 LINK)
the 0x1f9e2... one got its funding from:
  1. 6098.8 LINK from Binance about a year ago: https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0x161cdd891e04a77e0458a3ef65c563c4d2064cd6
  2. 12,600,000 from the genesis wallet through one jump address https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0xdad22a85ef8310ef582b70e4051e543f3153e11f
  3. 13,000,000 from the 0xf37... wallet above
the 0xf37... in turn got its 50,000,000 (!) LINK from the genesis address which minted the original 1 billion tokens:
https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0xf55037738604fddfc4043d12f25124e94d7d1780
So the 0x27158... wallet is basically a genesis wallet.
Now let's do the most popular feed on feeds.chain.link, the ETH/USD feed: https://feeds.chain.link/eth-usd, with a wallet address of: https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0xF79D6aFBb6dA890132F9D7c355e3015f15F3406F#tokenAnalytics
It was first funded in Jan 2020 and has been funded a total of 9 times for a total influx of 108,437.533 LINK, by:
  1. "Chainlink: Deployer" 10 LINK: https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0x6f61507f902e1c22bcd7aa2c0452cd2212009b61
  2. The 0x27158... genesis-sourced wallet, 20,000 LINK
  3. An intermediary/middle very active wallet (which is 99.998% funded by the 0x27158... genesis-sourced wallet), 52,000 LINK https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0x2f0acb9c5dd2a3511bc1d9d67258e5c9434ba569
  4. "Chainlink: Aggregator", 36,427.533 LINK, https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0x79febf6b9f76853edbcbc913e6aae8232cfb9de9#tokenAnalytics
I manually traced EVERY single inbound transaction/source of funds for the above 4 (not counting #1 as 10 LINK is negligible). 2 & 3 are 99.99%+ genesis-funded, being ACTIVELY topped up by a genesis wallet, last tx 4 days ago, 500,000 LINK. #4 has been funded 36 times over the past year and a half (that's 36 manual exports and I did them all). They all come from the 0x27158..., 0x2f0acb..., and https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0x1f9e26f1c050b5c018ab0e66fcae8e4394eb0165 (another address like the 0x2f0acb that I went through and checked EVERY SINGLE inbound source of funds, and it's also >99.9% genesis-funded - one tx from Binance for 6098 LINK out of a total ~6,560,000 inbound LINK from genesis wallets), and two other addresses linked to Binance (0x1b185c8611d157a67d9a9d5261b0d2bd52c0bb78, 10,000 LINK and 0x039ac18afe298747c51c85e7c8f0d67c327f3883, 1,000,000 LINK)
The 0x039ac... address funded the "Chainlink: Aggregator" address with 127,900 LINK, and the 0x1b185... with about ~9,600 LINK). So yes, it's technically possible that someone not related to Chainlink paid for the ETH / USD price feed because some funds do come from Binance. However, they only come from two distinct addresses. Surely for "240+" claimed partnerships, more than TWO would pay to use Chainlink's MOST POPULAR price feed? That is, unless they don't pay directly but to another address and then Chainlink covers this one from their own wallets. I will check if that's in line with Chainlink's whitepaper, but doesn't that throw doubt on the whole model of end-users paying to use oracles/aggregators, even if it's subsidized?
I provide you this much detail not to bore you but to show you that I went through BY HAND and checked every single source (detailed sources in Appendix B) of funds for the OFFICIAL, Chainlink-listed "ETH/USD" aggregator that's supposedly sponsored by 10 DeFi partners (Synthetix, LoopSpring, OpenLaw, 1inch, ParaSwap, MCDEX, FuturesSwap, DMM, Aave, The Force Protocol). Yet where are the transactions showing that those 10 partners have EVER paid for this ETH/USD oracle? Perhaps the data is there so what am I missing? This ETH/USD aggregator has transferred out ~76,000 LINK to I guess the data providers in increments of .33 LINK. It has 21 data providers responding. I will begin investigating the data providers themselves soon.
And those middle addresses like 0x1f9e26... and 0x2f0acb...? They have transferred out hundreds of thousands if not millions of LINK to exchanges. And that's just ONE price pair aggregator. Chainlink has around 40 of these (albeit this one's one of the more popular ones).

SNX / ETH aggregator is funded 100% by genesis-sourced wallets, only 3 inbound transactions:
https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0xe23d1142de4e83c08bb048bcab54d50907390828

Some random examples (for later, ignore these for now) ***********
https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0x039ac18afe298747c51c85e7c8f0d67c327f3883 bought 1,000,000 LINK from Binance in Sept 12 & 15, 2019. (one of the possible funding sources for the ETH / USD aggregator example above)
This address got 500,000 LINK from 0x27158... and has distributed them into ~5-10,000 LINK wallets that haven't had any out transactions yet
https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0x5bcf3edc0bb7119e35f322ba40793b99d4620f1e
**************
Another example with an unnamed aggregator-node-like wallet that was only spun up 5 days ago, Aug 5:
https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0x2cbfd29947f774b8cf338f776915e6fee052f236
It was funded 2,000 LINK SOLELY by the 0x27158... wallet and has so far paid out ~500 LINK in 0.43 LINK amounts to 9 wallets at a time. For example, this is one of the wallets it cashes out to:
https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0x64fe692be4b42f4ac9d4617ab824e088350c11c2#tokenAnalytics
That wallet extremely consistently collects small amounts of LINK since Oct 2019. It must be a data provider because a lot of Chainlink named wallets pay it small amounts of LINK regularly. It has transferred out 20 times. The most recent transfer out:
https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0xc8c30fa803833dd1fd6dbcdd91ed0b301eff87cf which then immediately transferred to the named "1inch.exchange" wallet, so I assume this was a "cash-out" transaction. It has cashed out via this address a lot.
Granted, it also has transfer-out transactions that haven't (yet) ended up in an exchange wallet, eg https://etherscan.io/token/0x514910771af9ca656af840dff83e8264ecf986ca?a=0x88e5353a73f38f25a9611e6083de6f361f9b537b with a current balance of 3000 LINK. This could be a user's exchange wallet, ready to be sold, or could be something else. No way for me to tell as there are no out txs from it.

LINK overall transaction, volume, and tx fees

This is to understand how much $ moves through the LINK ecosystem through: nodes, data providers, reserve wallets, wallets linked to exchanges, others.
A typical aggregator node tx (payout?): https://etherscan.io/tx/0xef9e8e6dd94ebe9bbac8866f18c2ea0a07408ced1aa77fa04826043eaa55e772 This is their ETH/USD aggregator paying out 1 LINK to each of 21 addresses. Value of 21 LINK ~= $210. Total eth tx fees: .233 ETH (~$88.5, ~42% of the total tx value. If LINK was $4.2 instead of $10, the tx fees would be 100% of the value of the tx). Transactions like this happen every few minutes, and the payout amounts are most often 0.16, 0.66, 1.0, and 2.0 Link.
Chainlink’s node/job listing site, https://market.link, lists 86 nodes, 195 feeds, 801 jobs, ~1,080,000 job runs (I can’t tell if this is over the past 2 months or 1.5 years). Only 20 nodes have over 1000 job runs, and 62 nodes have ZERO runs. Usual job cost is listed as 0.1 link, but the overall payout to the nodes is 10-20 times this. The nodes then cash out usually through a few jump addresses to exchanges. Some quick maths: (being generous and assuming it’s 1mil jobs every 2 months = ~6mil link/year = $60,000,000 revenue a year. This is the most generous estimate towards link’s valuation I’ve found so far. If we ignore the below examples where on multi-node payouts the tx fees are more than the node revenue itself, then it’s almost in line with an over-valued (but real) big tech company.
For example, one of the latest CHF/USD job runs paid 0.1 LINK to 9 addresses (data providers?) - total $14.4 payout - and paid 0.065 ETH ($24.5) in fees. That’s a $10.1 LOSS on a $14.4 revenue: https://etherscan.io/tx/0xa6351bab810b6864bfebb0f6e1e3bde3c8856f8aac3ba769dd2e6d1a39c0d23f
Linkpool’s (one of the biggest node operators) “ETH-USD CryptoCompare” job costs 0.1 link and has 33 runs in the past 24 hours (once every ~44min), total ~78,000 runs since May 30 2019 (once every ~8min). https://market.link/jobs/64bb0845-c4e1-4681-8853-0b5aa7366101/runs (PS cryptocompare has a free API that does this. Not sure why it costs $1 at current link prices to access an API once)

Token distribution:

Top 100 wallets (0.05% of ~186,000 total) hold 83% of tokens. 8 wallets each hold over 1% of total, 58 hold over 0.1%. Of these 58, 9 are named exchange/lending pool wallets.
For comparison, for Tether (TUSD), the top 100 wallets (0.006% of ~1,651,000 total) hold 35.9% of the supply. 3 addresses hold over 1% of the supply and 135 hold over 0.1%. Of these 135, at least 15 are named exchange/lending pool wallets.
LINK’s market cap is $3.5B (or $10B fully diluted, if we count the foundedev-controlled tokens, which we should as there's nothing preventing them from being moved at a moment's notice). Tether’s is $6.9B. Tether has 10 times more addresses and less distribution inequality. Both LINK and Tether are ERC20 tokens, and even if we temporarily ignore any arguments related to management/roadmap/teams etc, Tether has a clear, currently functional, single use case: keep 1 USDT = $1 USD by printing/burning USDT (and yet as of April 2019, only 74% of Tether's market cap is backed by real funds - https://en.wikipedia.org/wiki/Tether_(cryptocurrency))). Given that Chainlink's market cap is now 50% bigger than Tether's, surely by now there's AT LEAST one clear, currently functional use case for LINK? What is it? Can we *see* it happening on-chain?

Chainlink’s actual deliverable products

"What do I currently get for my money if I buy LINK 1) as an investor and 2) as a tech business/startup thinking of using oracles?”
Codebase (Chainlink’s github has around 140-200,000 lines of code (not counting html/css). What else is not counted in this? Town crier? Proprietary code that we don't know about yet? How much CODING has Chainlink done other than what's on github?
Current network of oracles - only ~20 active nodes - are there many more than the ones listed on market.link and reputation.link? If so, would be nice to know about these if we're allowed!
Documentation - they have what seems like detailed instructions on how to launch and use oracle nodes (and much more, I haven't investigated yet) (TODO this part more - what else do they offer to me as an end consumer, and eg as a tech startup needing oracle services that I can’t code myself?)

Network utilization statistics:

Etherscan.io allows csv export of the first 5000 txs from each day. From Jul 31 to Aug 6 2020, I thus downloaded 30,000 tx from midnight every day to an average of 7:10am (so 24 hour totals are 3.34x these numbers if we assume the same network utilization throughout the day).
(Summary of all LINK token activity on the ETH blockchain from 31.07 to 06.08, first 5000 txs of each day (30k total) shown Appendix A comment below this post.)
If we GENEROUSLY assume that EVERY SINGLE transaction under 10.0 LINK is ACTUAL chainlink nodes doing ACTUAL work, that’s still under 0.1% of the LINK network’s total volume being used for ACTUAL ecosystem functioning. The rest is speculation, trading, node funding by foundedev wallets, or dumping to exchanges (anything I missed?)
Assuming the above, the entire turnover of the actual LINK network is currently (18,422 LINK) * ($10/LINK) * (3.34 as etherscan.io’s data only gives first 5000 tx per day which averages to 7:10am) * (52 wk/year) = USD $31,995,329 turnover a year.
Note: the below paragraph is old analysis using traditional stock market Price/Earnings ratios which several users have now pointed out isn't really applicable in crypto. I leave it for the record. Assuming all of that is profit (which it’s not given tx fees at the very least), LINK would need a PE ratio (Price/Earnings) of 100 times to justify its current (undiluted) valuation of $3.5 billion of 300 if you count the other 65% of tokens that haven’t been dumped by the founders/devs yet. For comparison, common PE ratios are 32 (facebook), 29 (google), 37 (uber), 20 (twitter on a good year), 10 (good hedge fund returning 10% annual).

Thoughts on DeFi & yield-farming - [TODO]

Why would exchanges who do their due diligence list LINK, let alone at a leverage? 1) that's their business, they take a cut of every transaction, overhyped or not, 2) they're not safe from listing openly bearish tokens like EIDOS (troll token that incentivized users to make FAKE transactions, response to EOS) https://www.coindesk.com/defi-yield-farming-comp-token-explained
The current ANNUAL yield on liquidity/yield farming is something like 2% on STABLE tokens like USDC and TETHER which at least have most of their supply backed by real-world assets. If Chainlink LINK staking is to be successful, they'll have to achieve at LEAST that same 2% at end-state. IF LINK is in bubble territory and drops, that's a lot of years at 2% waiting to recoup losses.

SmartContract Team & Past Projects

Normally I don't like focussing on people because it leads too easily to ad-hominem attacks on personality rather than on technology/numbers as I've done above, but I came across this and didn't like what I saw.
Steve Ellis, SmartContract's current CTO, co-founded and worked in "Secure Asset Exchange" from 2014 to 2016. They developed the NXT blockchain, issued 1,000,000,000 NXT tokens (remind you of anything?), NXT was listed end of 2013 and saw 3 quick 500%-1000% pumps and subsequent dumps in early in mid 2014, and then declined to . SecureAE officially shut down in Jan 2016. Then at some point a company called Jelurida acquired the rights to NXT (presumably after SecureAE?), then during the 2017 altcoin craze NXT pumped 300 times to a market cap of $1.8 BILLION and then dumped back down 100 times and now it's a dead project with a market cap of $13 million.
https://www.linkedin.com/in/steveellis0606/
https://trade.secureae.com/
https://coinmarketcap.com/currencies/nxt/
https://www.jelurida.com/news/lawsuit-against-apollo-license-violations
As an investor or business owner, would you invest/hire a company whose co-founders/CTO's last project was a total flop with a price history chart that's textbook pump-and-dump behaviour? (and in this case, we KNOW the end result - 99% losses for investors) If you're Google/Oracle/SWIFT/Intel, would you partner with them?

Open questions for the Chainlink community and investors:

  1. Network activity: Are there any other currently active chainlink nodes other than those listed on market.link and reputation.link? If so, is there a list of them with usage statistics? Do they use some other token than LINK and thus making simple analytics of the LINK ERC20 token not an accurate representation of Chainlink’s actual activity? If the nodes listed on the two sites above ARE currently the main nodes, then
  2. PR, partnership announcements: Why is the google tweet still pinned to the top of Chainlink’s twitter? Due to the frequently circulated Chainlink promotion material (https://chainlinkecosystem.com/) that lists Google as one of the key partners, this tweet being pinned is potentially misleading as there isn't anything in there to merit calling Google a "collaborator" or "partner" - just that blockchains/oracles *can* use Google's APIs (but so can most software in the world). Is there something else going on with the SmartContract-Google relationship that warrants calling Google a partner that we're simply not aware of yet?
  3. By buying LINK, what backs YOUR money: If you have bought and currently hold LINK tokens, how comfortable are you that the future promise of your investment growing is supported on verifiable business and technological grounds versus pure, parabolic hype? If after reading this post you still are, I kindly ask you to reply and show how even one of the points I provided is either incorrect or not applicable, and I will edit my post and include your feedback in the relevant section as I have already done from other users.
  4. What have I missed? Of course not 100% of what I've said is infallible truth. I am a real human, and I have plenty of biases and blind spots. Even if what I've provided is technically correct, there may be other much more important info that I've missed that eclipses what I've provided here. Ask yourself: if the current hype around LINK is indeed valid and points to a $100/$1000 future LINK price, then Where’s Chainlink’s missing financial/performance/usage evidence to justify LINK’s current valuation of $10+?

Conclusion

For your consideration, I have provided evidence with links that you can follow and verify, and draw your own conclusions. I have made my case as to why I believe the LINK token is currently priced much higher than evidence supports, and I ask you to peer-review my analysis and share your thoughts with me and with the wider LINK/crypto community.
Thank you for your time, I realize this is a long post. All questions and feedback welcome, feel free to comment or PM. I won't delete/censoblock (except for personal threats, safety considerations etc). I am a real human but I am not revealing my true identity for obvious privacy/harassment reasons.
(If anyone is wondering about my credentials ability to add 2+2 and work with basic spreadsheets: I have previously won a math competition in a USA state, I won an English-speaking country's physics olympiad, my university education is in mathematical physics/optimization engineering, and I worked for a few years in a global manufacturing company doing data analytics, obviously I'm not posting my CV here to verify that but I promise you it's the truth)
I’m not looking to spread neither FUD, nor blind faith, nor pure hype, and I want an honest transparent objective discussion. I personally believe more that LINK is overvalued, but my beliefs have evolved and may continue to do so as I research more and understand more about Chainlink, LINK, Ethereum, DeFi, and other related topics, and as I incorporate YOUR feedback. If you think I haven't disclosed something, ask.
As always, this is not financial advice and I am not liable for anything that may happen as a result of you reading this!
submitted by Stratocatter to CryptoCurrency [link] [comments]

How the TFSA works

(Updated August 9th, 2020)

Background


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.

Introduction


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:


Insurance


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:


What You Cannot Trade


You cannot trade:

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 to 2012 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.

Examples


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:



  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. TFSATFSA direct transfer from one institution to another: this has no impact on your contributions or withdrawals as it counts as neither.
  8. 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.
  9. Withdrawals that convert into contribution room in the next year. Do they carry forward indefinitely if not used in the next year? Answer :yes.
  10. 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.
  11. 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.
  12. 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
  13. 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.
  14. 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.
  15. 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.
  16. 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.
  17. 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.
  18. 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.
  19. 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.
  20. 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.
  21. 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.
  22. 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.
  23. 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.
  24. 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.
  25. 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.
  26. 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.
  27. 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.
  28. 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.
  29. 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.

How Margin Loans Work - a Primer

submitted by KhingoBhingo to CanadianInvestor [link] [comments]

How are you supposed to buy / sell without losing profits?

I'm new to crypto, but familiar with stocks.
I'm cruising around to buy bitcoin and the ask / sell price is about 0.5% + / - the stock value it seems.
So just like stocks I want to buy bitcoins at the current market value, but no matter what limit I set to, I cannot buy anything unless I'm bidding at the ask price which automatically makes me lose money because it's higher than the market value. I set buy limits for an hour that is hovering just around the market value and I don't get any buys.
This whole thing is going to turn me off if I have to eat a 0.5% - 1.0% loss upfront which is a lot of money when I'm buying multiple bitcoins.
submitted by ExpertPerformer to BitcoinBeginners [link] [comments]

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.
submitted by brokemac to CryptoCurrency [link] [comments]

Become a Verasity Influencer

Read full story: medium.com/verasity
Are you passionate about the Verasity project? Do you think you could help us increase Verasity’s brand awareness and reach on social media? We are looking for Verasity Influencers who can help us to take our project to the next level.
If YOU are social media savvy and think you have what it takes to become a Verasity Influencer, here’s what we want you to do:
  1. Register on verawallet.tvand set up a VeraWallet, if you haven’t already done so.
  2. To join the campaign please fill the form below and wait for the approval.
-Your tweets/comments will be evaluated on a **weeklybasis
- Results can be viewed in this evaluation sheet 5. Tweets/comments must be of **good quality. Spam, low-quality tweets/comments, copying others’ tweets will cause you to be banned from the campaign. 6. Participants’ tweets/comments will be evaluated once a week and the rewards will be sent to your VeraWalletonce a month. 7. Verasity has the right to change campaign rules at any time.
You could earn $$$s in VRA for being a Verasity Influencer on Twitter and Reddit
Photo by Sara Kurfeß on UnsplashRules for Twitter Posts:
How We Reward You
Photo by Sam Dan Truong on UnsplashTips on How to get More Engagement (RTs & Likes) on your tweets;
Write high quality, informative tweets that people will love to read
Use the correct hashtags for optimal reach
Use visuals such as colorful images and video
Use funny memes, images and engaging quotes. Make your reader laugh :)
Share your tweets with your friends, invite them to retweet, like and comment
Share your tweets on crypto-related Telegram groups and forums
The most quality tweets will be shared by us on Verasity Telegram groups
Begin a thread/topic of conversation and invite people to respond
Photo by Kon Karampelas on UnsplashRules for Reddit
How We Reward You
About Verasity.tv
REWARDS BASED PLATFORM FOR ESPORTS, GAMING AND VIDEO ENTERTAINMENT
Verasity is a leading company providing proprietary technology, uniquely rewarding gamers, viewers and publishers.
Verasity revenue streams include:
Game subscriptions, jackpot revenue rake, betting revenue rake and video ad revenues. Read about the tokenomics, forecast, buy back and burn here.
📖 Read our latest adoption metrics and one page overview
📈 Find where VRA (ticker) is trading onCoinMarketCap
VRA can be staked for 36.5% annual interest at https://verawallet.tv.
Follow Us:
Medium: https://medium.com/verasity
Twitter: https://twitter.com/verasitytech
Website: https://verasity.io
Telegram Token Discussion: http://t.me/verasitychat
Telegram Token Announcements: https://t.me/verasity
Verasity Esports Fight Club: https://t.me/verasity_mobile
Kakao: https://open.kakao.com/o/gh8ZK0cb
Facebook: https://facebook.com/verasitytech
LinkedIn: https://www.linkedin.com/company/verasity
Reddit: https://www.reddit.com/verasity
Blockfolio Signals: Follow VRA to receive updates straight from the team
Join our local groups, we have support in the following languages
Russian chat 🇷🇺 — https://t.me/VerasityRU
Korean chat 🇰🇷 — https://open.kakao.com/o/gh8ZK0cb
Turkish chat 🇹🇷 — https://t.me/VerasityTR
Vietnamese chat 🇻🇳 — https://t.me/Verasity_Vietnam
Brazilian chat 🇧🇷 — https://t.me/Verasity_BR
Spanish Chat 🇪🇸 — https://t.me/verasity_spanish
Persian Chat 🇮🇷 — https://t.me/verasity_irn
Japanese Chat 🇯🇵 — [https://t.me/verasityjapanese
](https://t.me/verasityjapanese)Indian Chat🇮🇳- https://t.me/VerasityIndia
WeChat — PM @cryptomeo on Telegram
If you are a Game Developer or Video Publisher and want to grow your audience and revenue by 500% click thelinkto talk to the team
Become a Verasity Influencer was originally published in Verasity on Medium, where people are continuing the conversation by highlighting and responding to this story.
-- Integrate with Verasity:
👩‍💻verasity.tv
👊esportfightclub.com
🎮games.verasity.tv
🕊twitter.com/verasitytech
submitted by IndependentYoga to Verasity [link] [comments]

The Basic Principles Of Crypto trade spreadsheet - Che bella scoperta Cryptocurrency Tracker Spreadsheet £,$ & More Free. Track Altcoins and Bitcoin Free crypto spreadsheets Chutch's Crypto Trading - E01 - Setting Up Tracker Spreadsheet SpreadSheet Programming Crypto Trade

The spreadsheet gives the client relevant information regarding conditions relating to cryptocurrency trading and other assets: one lot's value, floating spreads, commissions, and leverage. Cryptosheet is intuituve to use, but we’ve included a user guide that explains exactly how to input your crypto transactions into the spreadsheet. Ease-of-use was a top priority, and providing easy-to-follow instructions is part of that effort. 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. The Cryptosheet services come in the form of a downloadable spreadsheet that comes with preprogrammed functionalities to enable secure and accurate analysis of the investor's portfolio. The advanced worksheet is carefully designed to allow beginners to understand the use of a spreadsheet to monitor crypto investments. 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. I decided to give them a try

[index] [1172] [2362] [1778] [215] [1326] [117] [1313] [1375] [498] [363]

The Basic Principles Of Crypto trade spreadsheet - Che bella scoperta

Watch the video below to see how it works, how add new coins and you can download the Cryptocurrency Spreadsheet tracker for FREE below. You can if you wish Donate on the links below. How to Create Crypto portfolio using Power Query in Excel (pull ... 5:03. Str82ThePoint 7,576 views. 5:03. Trading Journal - My Excel Spreadsheet Trading Journal (+ Free Trading Journal ... Our Website Link: https://bit.ly/2WTdO3z - A Biased View of Crypto Trading Journal Spreadsheet - Was Ist Iso Light I have actually made modifications and attached version 2 here. 2 Likes Hey There ... I have decided to start swing trading Bitcoin (BTC) and Ethereum (ETH), so I set up a google sheet to track my trades. In this video I walk through the google sheet and explain how it works. Once ... Crypto Trading Game of Life 2018.02.19 - Duration: 29:23. Money Charts 140 views. ... Simple Share Trading Spreadsheet - Duration: 10:25. The Aussie Share Trader 7,203 views.

#