We’re waiting longer than ever for our favorite TV shows to return
November 28th, 2024
2 min
This article is brought to you by Datawrapper, a data visualization tool for creating charts, maps, and tables. Learn more.
Hi, this is Eddie. Most of the time, you can find me on the other side of suport@datawrapper.de or Datawrapper’s Twitter, Facebook, and LinkedIn account. This week, I will dive into a phenomenon that has left many investors clueless: Bitcoin.
Like most people out there, I was late to the Bitcoin party. When I first heard about it in 2014, I didn’t understand what was going, and it all sounded like a foreign language to me. I was unfamiliar with terms like mining, blockchain, or encryption, so I didn’t overthink it and continued with my life.
That was until 2017 when Bitcoin went from $830 to $19,300, and Ethereum —the second-largest cryptocurrency in terms of market capitalization— started the same year at less than $10 and closed it at $715. Back then, news from people that became millionaires thanks to crypto made headlines everywhere. But also from those that wasted fortunes over a pizza or a sushi dinner with friends.
The same thing happened again in 2021: Bitcoin made it to the front page when Thursday last week, it topped $40,000 for the first time in its history. This record came just some days after the cryptocurrency hit another all-time high of $34,800 and celebrated its 12th anniversary on January 3rd.
While some experts set exorbitant targets for Bitcoin for 2021 of between $220,000 and $300,000, others call for caution. “When any asset climbs in price this fast for an extended period of time I become cautious, and I’d urge anyone trading BTC to not get caught up in the euphoria,” explains Nicholas Pelecanos, head of trading at the cryptocurrency firm NEM.
The model Stock-to-Flow provides a middle point between these extremes. It’s devised by a person known as Plan B and has so far proved to be surprisingly accurate. According to this model, Bitcoin could come closer to $90,000 by the end of 2021. Plan B built his model on an exciting premise: That Bitcoin can be compared with commodities such as gold or silver, which are known for retaining value over time due to their scarcity. Bitcoin is known to be the first digital object which is scarce, since it’s limited to 21 million, with around 18.5 million already mined.
While it’s hard to truly anticipate what will happen with Bitcoin in the short and long term, let’s see what could have happened if I (or you) had joined the trend a year ago:
If I had put 100 USD in Bitcoin at the beginning of 2020, I could have had 300 USD more now. But the real money-maker of cryptocurrencies last year was Chainlink, which performed exceptionally well. If I had bought 100 USD of that one and sold it in August, I could have made almost a thousand. If I had waited until the end of the year, the benefit would still be close to 600 USD.
The American and Chinese electric vehicle companies Tesla and Nio turned out to be an even better bet. Those companies would have given me a benefit of 700 USD and 1,200 USD respectively by the end of the year. Looking back at it now, I do regret not investing some hundreds at the beginning of 2020.
The numbers for both line charts come from Yahoo Finance, a platform that offers historical financial data in CSV form. The process to download it was effortless, and it only took me a couple of minutes to write and run this script using the language Bash:
#!/bin/bash
# Coin pairs
CoinsVal="TSLA ETSY NVDA AMZN NFLX NIO NKE BABA SNE UBER BTC-USD ETH-USD XRP-USD LTC-USD BCH-USD ADA-USD DOT-USD LINK-USD XLM-USD USDT-USD"
# Download each pair via Yahoo Finance
for val in $CoinsVal; do
echo "Downlading $val"
curl -o "$val.csv" "https://query1.finance.yahoo.com/v7/finance/download/$val?period1=1577836800&period2=1609459200&interval=1d&events=history&includeAdjustedClose=false"
done
The variable CoinsVal contains a list of the stocks and cryptocurrencies I wanted to get data from, while $val operates as a placeholder for those names. The query in quotation marks includes period1, which is the first date I want to get data from (01/01/2020), and period2, the last day (31/12/2020). You can run this script directly in the terminal. If you would like to use this script and struggle with this process, just let me know, and I’ll be happy to help!
Here are a few articles and tutorials that helped me create this Weekly Chart:
And that’s all from me this week! If you have any comments or questions about today’s Weekly Chart, you are always welcome to drop me an email at edurne@datawrapper.de or write me a message on Twitter (@EdurneMG). Next week it will be the turn of our developer Simon Jockers, and I’m excited to see what he makes!
Comments