From what I have seen, it seems you just want to generate about 1000 dice bet results with "RANDBETWEEN" and see how good or bad martingale would work, am I right?
Yes.
Gambling strategies are very interesting but this topic has been discussed intensively here and the conclusion is simple, there is no strategy, however there are a few strategies that can actually increase your odds like this one. (Example by Dooglus)
bet 0.5 at 33%
if you win, you get 99/33 = 3x, so you get 1.5 back, a profit of 1 - you've doubled your money
if you lose, bet the other 0.5 at 24.75%
if you win, you get 99/24.75 = 4x, so you get 2 back - you've doubled your money
the only way it goes wrong is if you lose both the 33% and the 24.75% - the chance of that is (1-0.33) * (1-0.2475) = 0.504175
so the chance of success is 1 - 0.504175 = 0.495825 = 49.5825% - a fraction higher than 49.5
So yeah, you are basically increasing your total odds by 0.0825% which is not huge but long term is obviously just better than 49.5
Thank you, i will be adding this then i get home, and if you wouldn't mind i would also be adding a link to this post, so i can refer to it.
Edit:
Each time you lose, you gain the upperhand. If you lose 1 bitcoins, you bet with 2. If you win you will have 1 bitcoin in profit. This would work even with high house edge
Could you try explaining the circumstances if he lose while betting with 2 bitcoins? Does't it depend on your probability(odds) selection weather you're more likely to win or lose? I know in this case is x2 which is 50% ,correct? I doubt you can be sure if the next roll with 2 bitcoins will work in your favor (could or could not).
Even at 1% you would be winning.
If you lose you double your earnings. This way you if you ever win you will earn 1 bitcoin anyway.
All this is a analyse of the generated stats. I need this for presentation, so don't bet on it