Average bet SIZE % as calculated from pot/stack

[degoor]

Hello!

Here is a situation:

On the flop a player bets 100 chips in a pot of 100 chips and his stack is 1000 chips so his bet size percenatge based on pot is 100% and his bet size percenatge based on his stack size is 10%.

So I need a stat that gives the average bet size percentage based on:
1) pot size,
2) stack size.

These average percantages should be calculated separately for flop, turn and river bets.

Hope you can help me on the matter!

[kraada]

The average size for the pot is available in the repository for free download uploaded by myself as "Percent Bet on Flop", "Percent Bet on Turn" and "Percent Bet on River". Once you examine the way these are built you should be able to figure out exactly how to build percentages bet as of your stack - if you have trouble let me know where you're stuck and I'll help you out further from there.

[degoor]

Actually I am not quite sure what this stat of yours represents.

I need
AVERAGE of Persentage("Bet size"/"Pot size before the bet was made")
and
AVERAGE of Persentage("Bet size"/"Stack size before the bet was made")
for 3rd, 4th and 5th street.

But I do not know where to start from.

[kraada]

The first one, for each street, is in the repository.

[degoor]

So your stat "Percentage of the Pot bet on the Flop" uses the formula:

if( cnt_f_bet > 0 , amt_total_avg_f_bet / cnt_f_bet , 0 )

where

column "cnt_f_bet" means "Number of times player bet the flop" and is calculated from =sum(if[tourney_holdem_hand_player_statistics.flg_f_bet, 1, 0])

and

column "amt_total_avg_f_bet" is calculated from
=sum(tourney_holdem_hand_player_detail.val_f_bet_made_pct).

I can't see though if a similar stat as "amt_total_avg_f_bet" is available for the stack size percentage.

[WhiteRider]

You will need to add another column for that - you can calculate the player's stack when the flop is dealt like this:

tourney_holdem_hand_player_detail.amt_before - tourney_holdem_hand_player_detail.amt_bet_p

The absolute amount of the bet made is:

tourney_holdem_hand_player_detail.amt_f_bet_made

So the percentage of the stack bet is:

(tourney_holdem_hand_player_detail.amt_f_bet_made / (tourney_holdem_hand_player_detail.amt_before - tourney_holdem_hand_player_detail.amt_bet_p)) * 100

..and the total across all hands is:

sum( (tourney_holdem_hand_player_detail.amt_f_bet_made / (tourney_holdem_hand_player_detail.amt_before - tourney_holdem_hand_player_detail.amt_bet_p)) * 100 )

..and you can divide that by cnt_f_bet like in the other stat.

[degoor]

I suppose "tourney_holdem_hand_player_detail.amt_bet_p" includes all preflop deductions from player's stack such as blinds, antes, bets or calls - right?

When calculating player's stack on the turn, should I put it as

sum( ( tourney_holdem_hand_player_detail.amt_t_bet_made / (tourney_holdem_hand_player_detail.amt_before - tourney_holdem_hand_player_detail.amt_bet_p - tourney_holdem_hand_player_detail.amt_bet_f) ) *100)

or just

sum( ( tourney_holdem_hand_player_detail.amt_t_bet_made / (tourney_holdem_hand_player_detail.amt_before - tourney_holdem_hand_player_detail.amt_bet_f) ) *100)

i.e. does "tourney_holdem_hand_player_detail.amt_bet_f" include amounts bet preflop or just those bet on the flop?

[WhiteRider]

I suppose "tourney_holdem_hand_player_detail.amt_bet_p" includes all preflop deductions from player's stack such as blinds, antes, bets or calls - right?

Right.

When calculating player's stack on the turn, should I put it as

sum( ( tourney_holdem_hand_player_detail.amt_t_bet_made / (tourney_holdem_hand_player_detail.amt_before - tourney_holdem_hand_player_detail.amt_bet_p - tourney_holdem_hand_player_detail.amt_bet_f) ) *100)

or just

sum( ( tourney_holdem_hand_player_detail.amt_t_bet_made / (tourney_holdem_hand_player_detail.amt_before - tourney_holdem_hand_player_detail.amt_bet_f) ) *100)

i.e. does "tourney_holdem_hand_player_detail.amt_bet_f" include amounts bet preflop or just those bet on the flop?

amt_bet_f is only the amount bet on the flop so you need to use both (your first expression).