Crypto Currencies as an investment vehicle

Posted on Oct 12, 2017


The goal of this document is to provide an overview of crypto currencies, also identified simply as “coins” and derive preliminary recommendations for investors in this space. The Bitcoin white paper was written in late 2008. Today many more currencies than Bitcoin exist. Some of the questions we will answer include: what are the coins relative importance (by total value)? How have prices behaved in the last few years? How would basic investing strategies have performed during that timeframe?


The data file studied here contains OHLC (Open-High-Low-Close) data for about 1100 crypto currencies during the last 5 years. The data was scraped from by Jvent and uploaded to Kaggle.

Source file: link

Here is a sample of the data:

Note: The 'market' column means market capitalization and is the sum of the values of all coins in circulation.

The file contains 1129 different coins. Here is a random sample:

Coins creation

The following graph shows the constant rise of reported coins. We observe some volatility in the number of new coins in last few months. One factor was China’s decision to ban initial coin offerings (ICOs) on September, 4th. Nevertheless, the pace of new ICOs globally remains strong.

Market Capitalisation Distribution

Looking at the distribution of coin market caps, we observe a large skew towards smaller valuations. In fact 230 (20.37%) of coins have no market capitalisation as of September 28th, 2017 (the market cap reported by the website is $0). 678 (60.05%) have a market cap below $1 million.

Coins Market Cap graph

This graph shows the evolution of each coin total market cap over time (only top coins are shown).

As a few coins clearly dominate trading, we will look at their relative share of the overall crypto currency pie as measured by market cap. This graph shows a key trend in the past year: the emergence of other coins such as Ethereum and Ripple (22% and 5% of total market cap respectively) and a reduction of the Bitcoin total share from 90% to 50%.
Note: when we say 'emerge', we are talking about market cap, not when these companies started.

Return distribution

In the graph below, all coins prices were normalized to start trade at $1 on April 28th, 2013. Plotting prices or log prices for all coins isn’t a viable option here. The coins should be clustered so that it’s possible to read the data. This analysis is outside the scope of this document.

Trading Strategies

In order to better understand the behavior of these coins, I implemented a basic dollar averaging trading strategy. Starting 5 years ago when data is available, everytime the daily trading volume passes a certain threshold ($100,000 to start) for a given coin, I buy $1 of it and hold it forever. The composition of the portfolio on the last day where data is available (September 28th, 2017) is shown below:

Conclusion: 50% of the portfolio is made of just 6 coins. Stratis, the biggest position, went up 200,000 times. The next step would be to check if those coins indeed could have been purchased at the initial ‘low’ prices reported on Historical exchange data would be needed for this.

The value of the portfolio over time (net of the cash investment represented in red) is plotted below. Investing in about 600 coins would have resulted in a net gain of $3400. This represents a significant return, but concentrated in the last year. Very few long strategies would have failed in 2017 and this basic one is no exception.

Finally I plotted the value of the final portfolio as a function of the volume threshold at which I would buy each coin. The gains get exponentially higher as the threshold diminishes. That means that if I buy each coin “right away” -say when the daily volume is only above $1000, then some of the coins will experience a meteoric rise and the portfolio will grow more during the holding period. The same conclusion applies here: we would need to check with exchange data if these coins were truly available at such small volumes. At the very least we can conclude that this trading strategy would only be available to small players.

Additional studies

In response to comments from the author of the data file, I created 2 more graphs. The first one looked into the alleged strong returns of Bitcoin in the first days of the month. This is not supported by the data which shows no relationship. Note that I focused on the last 12 months for this analysis as there was limited activity in the previous 4 years.

The second shows the returns of a coins index (with ‘traditional’ market cap weights) in relation to Bitcoin returns. Supposedly Bitcoin price surges were causing alternative coin holders to sell their holdings in exchange for Bitcoin. We see that in fact all crypto currencies seem to move in tandem.


Although those weren't covered here, coins carry significant risks as investments, including:

  • technology risk (e.g. hackers stealing from exchanges and sapping investor's confidence)
  • technology obsolescence with new algorithms such as hashgraph
  • regulatory risk
  • absence of intrinsic value such as cash flow streams

Because coins are highly correlated to Bitcoin, an investor in crypto currencies couldn't meaningfully diversify his holdings across coins. Following this basic analysis, I would recommend considering any allocation to a basket of crypto currencies to be conservatively sized.

About Author


Quentin holds a BS in Electrical Engineering with a minor in Computer Science from Telecom ParisTech in France.
View all posts by QUENTIN PICARD >

Related Articles

Leave a Comment

No comments found.

View Posts by Categories

Our Recent Popular Posts

View Posts by Tags

#python #trainwithnycdsa 2019 2020 Revenue 3-points agriculture air quality airbnb airline alcohol Alex Baransky algorithm alumni Alumni Interview Alumni Reviews Alumni Spotlight alumni story Alumnus ames dataset ames housing dataset apartment rent API Application artist aws bank loans beautiful soup Best Bootcamp Best Data Science 2019 Best Data Science Bootcamp Best Data Science Bootcamp 2020 Best Ranked Big Data Book Launch Book-Signing bootcamp Bootcamp Alumni Bootcamp Prep boston safety Bundles cake recipe California Cancer Research capstone car price Career Career Day citibike classic cars classpass clustering Coding Course Demo Course Report covid 19 credit credit card crime frequency crops D3.js data data analysis Data Analyst data analytics data for tripadvisor reviews data science Data Science Academy Data Science Bootcamp Data science jobs Data Science Reviews Data Scientist Data Scientist Jobs data visualization database Deep Learning Demo Day Discount disney dplyr drug data e-commerce economy employee employee burnout employer networking environment feature engineering Finance Financial Data Science fitness studio Flask flight delay gbm Get Hired ggplot2 googleVis H20 Hadoop hallmark holiday movie happiness healthcare frauds higgs boson Hiring hiring partner events Hiring Partners hotels housing housing data housing predictions housing price hy-vee Income Industry Experts Injuries Instructor Blog Instructor Interview insurance italki Job Job Placement Jobs Jon Krohn JP Morgan Chase Kaggle Kickstarter las vegas airport lasso regression Lead Data Scienctist Lead Data Scientist leaflet league linear regression Logistic Regression machine learning Maps market matplotlib Medical Research Meet the team meetup methal health miami beach movie music Napoli NBA netflix Networking neural network Neural networks New Courses NHL nlp NYC NYC Data Science nyc data science academy NYC Open Data nyc property NYCDSA NYCDSA Alumni Online Online Bootcamp Online Training Open Data painter pandas Part-time performance phoenix pollutants Portfolio Development precision measurement prediction Prework Programming public safety PwC python Python Data Analysis python machine learning python scrapy python web scraping python webscraping Python Workshop R R Data Analysis R language R Programming R Shiny r studio R Visualization R Workshop R-bloggers random forest Ranking recommendation recommendation system regression Remote remote data science bootcamp Scrapy scrapy visualization seaborn seafood type Selenium sentiment analysis sentiment classification Shiny Shiny Dashboard Spark Special Special Summer Sports statistics streaming Student Interview Student Showcase SVM Switchup Tableau teachers team team performance TensorFlow Testimonial tf-idf Top Data Science Bootcamp Top manufacturing companies Transfers tweets twitter videos visualization wallstreet wallstreetbets web scraping Weekend Course What to expect whiskey whiskeyadvocate wildfire word cloud word2vec XGBoost yelp youtube trending ZORI