# How can I determine if a cryptocurrency is well-suited for day trading?

Here, I will describe a “coin risk index” that I have developed to monitor performance of my crypto investments. It’s important to note that this value will be meaningless if you have a simplistic trading cycle that does not include averaging down (Reference 3). Averaging down can be accomplished manually (I will detail how to do this in a future post) or through functions such as “DOUBLE_UP” in the automated crypto trading program, Gunbot.

So, how can this value be useful to determine risk? For example, a coin risk index of 25% would indicate that for every one sell trade, three buy trades are executed. This would indicate that the crypto regularly reaches unpredictable lows, which is unfavorable when using averaging down functions in programs like Gunbot. Conversely, a coin risk index of 50% would indicate that for every one sell trade, one buy trade is executed. This wouldn’t happen in the real world when averaging down, but a value close to 50% would imply strong predictability regarding price fluctuations, which is favorable.

Developing a “coin risk index”:

Equation: Coin risk index = (# of sell trades) / (# of total trades)

1. Download a .csv file with a full trading history from your crypto exchange. In my example, I will be using a “fullorder” file downloaded from Bittrex.
2. Open the file in Microsoft Excel.
3. Use the “COUNTIF” function to count the total number of trades per pair (Reference 4). In my example, I wanted to count the number of BTC-ETH trades, so I used the equation =COUNTIF(B:B,”BTC-ETH”)
4. Use the “COUNTIFS” function to count the number of sells per pair (Reference 5). In my example, I wanted to first count the number of BTC-ETH trades, then count the number of sell trades on this particular pair using the equation =COUNTIFS(B:B,”BTC-ETH”,C:C,”LIMIT_SELL”)
5. Divide the value attained in step 4 by the value attained in step 3. In my example, I used the equation =L3/L2
6. The resulting value will be a number between 0 and 1, represented as a percent (where 1 is equal to 100%). The lower the value, the more risky the investment is. In my example, BTC-ETH had a risk index of ~41.7%. In my experience, this is a “good” value and indicates relatively low risk.

This is my first post as an author, so any constructive feedback is welcome!

References