#The #Setup:
I've created 5 experiments to compare each of those experiments with another.
I took a snapshot on 15 December 2017 of the current marketcap rank of the top 100 coins
and created 5 portfolios on Gravychain. 

The 5 portfolios are:
-top 100 coins in marketcap
-top 50 coins in marketcap
-top 25 coins in marketcap
-top 10 coins in marketcap
-top 5 coins in marketcap

I've then calculated how many coins you should have for $1000 each on 15 December 2017. And added those numbers into the portfolio app. If a coin is reoccuring in the different portfolios I used those same numbers every time. 

#The #calculations: 
After the setup, the data collection can start. So I've created a excel document for gathering, processing and graphing those numbers. (https://steemitimages.com/DQmXxyRAj9f1TnpgsjAZD8fmWYYcByGrAVQxDWRZkmZecZ2/Schermafbeelding%202018-01-21%20om%2018.43.50.png)
[Raw data pages in excel] 
 
To crunch those numbers and place them into perspective I need to retrace al this data to a common number: 100
So I build a simple formula around that to retrace each portfolio to 100$ baseline.


The formula I've used:

**Total value top ... portfolio/initial value top ... portfolio x100**
*(... = top 100, 50, 25,10 or 5 coins in marketcap!)

##In excel it translates to this:##
![In excel it translates to this:](https://steemitimages.com/DQmVrSLiHxkzBUWAa9WkBF3ZGHYe3zwws6XznkoLsfLHSTk/Schermafbeelding%202018-01-21%20om%2018.45.52.png)

After that it's just a matter of placing the data into a automated graph and keep on crunching the data.
![calculated  crypto data](https://steemitimages.com/DQmaa5i9hkL6DuaGDugWun5sJ4KRbi8LxFH5Z9g3hMTup1d/Schermafbeelding%202018-01-21%20om%2018.54.26.png)
![visual representation of calculated crypto data cryptocurrency altcoins btc ltc neo xvg](https://steemitimages.com/DQmZtJSea4iA2c1y1XStYraEVvPkCDpc6TJshjSJQ4bwouP/Schermafbeelding%202018-01-21%20om%2018.54.44.png)

#The #motivation:
I'm setting up this crypto experiment to learn and discover the most efficient way to invest into cryptocurrency. While reducing the risk for loss by diversifying your crypto assets. And still earn the most revenue as possible.

What happens if i invest in each top 100 coin:
https://steemit.com/cryptocurrency/@armtrack/introduction-what-happens-if-i-invest-in-each-top-100-coin