Hello,

Been building a practice program for myself so I can get better at estimating SPR and pot odds. I will probably extend to some chunking math problems too. I want to know a good formula for generating a random bet size that centers around 1/2 to Pot but also will throw in overbets.

The problem with just a basic random generator is that it gives many more overbets than I really want when I try giving it a top range of 2*Pot. And I see less small sizings.

Below are just snips of what I'm trying but just playing around with things isn't getting me close to what I want.

Coding in Excel with VBA


Pot = Int(((BB + Straddle) + Rnd * (Stack / 4))) + Int(Rnd * (Stack / 3))


Bet = Application.WorksheetFunction.RandBetween(BB + Straddle, Pot)

You need to decide what distribution you want first. E.g.

1/2 pot = 20%
2/3 pot = 30%
3/4 pot = 20%
1x pot = 15%
1.5x pot = 10%
2x pot = 5%

Then generate a random number N between 0 and 1.
N < 0.2 = 1/2 pot
N < 0.5 = 2/3 pot
N < 0.7 = 3/4 pot
N < 0.8 = pot
N < 0.9 = 1.5x pot
N < 1 = 2x pot

Should be easy to do using nested IF statement in excel.

Good idea! Thanks!