Now, What was your betting stack before the bet = 1mBTC.
How much have you bet = 1mBTC
How much will be considered as bet for the competition(5% of current balance) = [(5x1)/100] = 0.05mBTC
Odds that you've bet at =1.05x
Bet status = won
Tournament's bet calculation = 0.05(tournament considered bet) x 1.05x (odds) = 0.0525mBTC
Amount won = Tournament's bet calculation - Considered bet = 0.0525 - 0.05 = 0.0025mBTC
New Balance = Bankroll before the bet + Amount won = 1mBTC+ 0.0025mbtc = 1.0025mBTC
ROI[(balance before bet x new balance)/100] = 0.010025%
Your ROI and Balance will be updated after every bet you make (its a lot of work for me, but I'm happy to do it).
Which means, after every bet you make, I'll calculate all the above and then calculate the ROI for the competition accordingly. The first screenshot will obviously be calculated first.
Hope this answers your question. Let me know if you have any doubts regarding the same.
Thank you for these explanations but what is the rule in case of a losing bet, the participant will lose all his stake, not only 5% of his balance right?
Do you plan to update frequently the participant balances in your spreadsheet?
Because participants will have to take those calculation rules into account when they'll place their bets and eventually make the calculations themselves if their balance hasn't been already updated.
Wouldn't it be easier to just not allow for the tournament bets above 5% of the balance? If someone would submit such a bet, the bet would be just not counted for the competition?