Dogecoin: DBeS2gHm79fHsxkYWTatbCYonxxc8fQn4M
Bitcoin: bc1qga4p8wxjvc8vx2l9p5y35ac7t0q0jqf8lmsf9y

CryptoSpreadsheet (CB)

Bitcoin is the front-runner in the fastest growing asset class in the world. To read an article about why I think that is, click here. The chart below confirms my analysis. It also shows a huge shift last year into alt-coins. In 2016, Bitcoin represented 88% of the total crypto market. In 2017, Bitcoin represented 39% of the market. Bitcoin is a conduit into the crypto world.


What other coins should you invest in? There are over 1300 coins and traditional valuation techniques don't apply here. What to do?

I've been researching this question. In particular, I wanted to know which alt-coins performed the best over the last 6 months. More importantly, what did they all have in common 6, 12, or 18 months ago that I can profile today. This spreadsheet is a product of that research.


Strategy #1 - The Bitcoin HODL Churn

Before getting into my alt-coin strategy, let's discuss my Bitcoin allocation. I allocate 50% of my portfolio to Bitcoin. 

My Bitcoin strategy is simple -- follow Bitcoin P/E. I use Willy Woo's network value to transactions (NVT), also referred to as "Bitcoin P/E", to tell me when to buy and sell.

First devised by Woo, the calculation uses the money flowing through the network as a proxy for earnings. A historic chart of Bitcoin’s NVT ratio is below.

A live and interactive chart is available on his website Woobull.com along with an in depth explanation of the ratio.

What about the rest of the crypto universe?

Strategy #2 The Mall

Alt-coins represent the other 50% of my portfolio. There are over 1,300 alt-coins available. Which ones do you invest in? I invest 35% in coins from The Mall (strategy #2), and 15% in coins from The Incubator (strategy #3).

There are many reasons why people buy crypto. Utility is by far the most important reason, but in my research I've found other reasons to be just as important. These are visibility and access. Access refers to the ease of obtaining the coin. Visibility refers to general attention. The most highly visible coins are the ones with the most access.

What data do I use for Strategy #2? I've created a spreadsheet highlighting the most visible and accessible coins in the crypto world. I refer to the spreadsheet as "The Mall". It includes the top 50 coins by market cap. Of the top 50 coins by market cap, only 8 can be considered Bitcoin or Ethereum clones (I provide a short description of each coin in the spreadsheet). 

Not all coins that make it to The Mall are good, but they all have considerable backing (users, miners, consortiums, stakers, marketing, developers, etc).

Which coins are on The Mall today? One coin grew over 57,000% in the past 6 months and is still trading at less than a penny. Another privacy focused coin grew over 4,000% (in part due to John McAfee's tweets). One of my favorite coins on the list gives everyone their own blockchain -- it grew over 29,000% in the last six months. Another coin specializing in digital IOUs is up 1,700% over the same time period. The worst performing coin is down less than 5%. Of the 50 coins on this spreadsheet six months ago, 30 are on the list today. What's more, those at the top of the list 6 months ago, have a greater probability of being on the list today.

Strategy #3 The Incubator

The final strategy looks for baby cryptos priced for less than $.01 that have the potential to grow exponentially. This includes ICOs (for a quick tutorial on how to research ICO's click here). I like to look for coins that have a high price to transactions ratio (T/P). The coins with the highest ratio are the ones I research further.

What data do I use for Strategy #3? I use a spreadsheet showing me the T/P for all 1,300+ cryptos sorted from highest to lowest. I refer to it as The Incubator. To be clear, T/P is not a magical indicator, but I use it as a way to focus my research.


Important: To mitigate risk, only transfer fiat or coin to the exchange when you are ready to trade it. The exchange house is not a place to store or park your coin. Buy your coin and then transfer it to an offline wallet (
Ledger Nano S, Trezor, Ledger Blue). Leaving it in the exchange is exposing yourself to unnecessary risk. I like the Ledger Nano S, but the Trezor is a close second. Ledger Blue is premium and convenient, but unnecessary.