Spreadsheet is automatically calculating it. I double checked nothing wrong about it, finely working.I think you should prove your claims about the faking ROI
did you open the link I sent ? it clearly explains ROI and you or your sheet are doing it wrong
how can people trust a tipster who doesn't know what ROI is ??
I don't need to prove anything the link clearly explains what ROI is and if you read that link you would know that your ROI is wrong , just open any month and divide the total profit on your total stake and you will see that your ROI is nowhere close to 117%
also your whole staking is wrong , every month you have different stakes and you aren't calculating your stakes in unit
professional tipsters will tell their followers to stake something between 1-10 points , but your sheets clearly showing that you aren't doing that and you are just putting random stakes
in February alone you made 10 bets where you staked 0.1 BTC or more , and magically 9 picks of these 10 won
everyone can profit after faking the numbers , there is no proof that you are recommending your followers how much to stake especially when comparing it with your sheets
everyone can be a winner on papers if he can fake how much he staked , I can tell people that I made a lot of 1000$ bets and magically they all won while I lost some of 500$ bets
so you can easily be faking the numbers , the picks may be right but the stakes are probably fake
it's like you say bet certain match , if it lost you record the stake 0.05 BTC but if it won you record the stake as 0.1 btc or more ( that's what I'm seeing in the sheets honestly )
and please note that I tried your service , I do track a lot of tipsters and people here in the forums know that I'm honest about my reviews
you don't mention the source of odds as well which may be faking odds as well , I wasn't able to get the odds for the majority of your picks
also in February you staked a lot of BTC and I'm 100% sure you can't stake that much on BTC sites
you had a lot of games where odds were quoted from buffbet and when I tried to bet I found that limits are less than 3$ for these events , so no idea how you are betting that much
don't understand that I'm judging you , you might actually be good but I'm telling you the following facts so you may improve in the future :
1- this isn't how ROI is calculated
2- you should change the staking plan to units so it makes it more accurate to follow the stats
3- you should mention the source of odds and not count on hltv since they have wrong odds most of the times
4- limits on a lot of the games you quote are really tiny especially the ones from buffbet