BB Fold to SB

[pr1mo]

this stat in the repository uses holdem_hand_player_detal.val_p_raise_aggressor_pos = 1 which is the cutoff - the sb is 9. so this is wrong? can i get this double checked? also would this mean that this stat is actually BB Fold to CO steal? and then if i change the number to 0 then that would be BB Fold to BU steal?

[WhiteRider]

This is the column:
cnt_p_BB_fold_to_SB = sum(if[holdem_hand_player_statistics.flg_p_fold AND
holdem_hand_player_statistics.position = 8 AND (holdem_hand_summary.cnt_players - holdem_hand_player_detail.val_p_raise_aggressor_pos) = 1 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0])

It's not actually checking "holdem_hand_player_detal.val_p_raise_aggressor_pos = 1" as you say, it's checking:
(holdem_hand_summary.cnt_players - holdem_hand_player_detail.val_p_raise_aggressor_pos) = 1

This is because (IIRC) the val_p_raise_aggressor_pos doesn't use 8 and 9 for BB and SB yet, it uses the absolute position off the button.
e.g. at a 6 player table, the SB's absolute position is 5 off the button, which is cnt_players - val_p_raise_aggressor_pos = 6 - 5 = 1.

When I first discovered this I was told that it would be changed to bring val_p_raise_aggressor_pos into line with the other position fields and use 8 and 9 correctly, but I don't think it's been done yet.

[Oakrdrzfan]

This is the column:
cnt_p_BB_fold_to_SB = sum(if[holdem_hand_player_statistics.flg_p_fold AND
holdem_hand_player_statistics.position = 8 AND (holdem_hand_summary.cnt_players - holdem_hand_player_detail.val_p_raise_aggressor_pos) = 1 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0])

It's not actually checking "holdem_hand_player_detal.val_p_raise_aggressor_pos = 1" as you say, it's checking:
(holdem_hand_summary.cnt_players - holdem_hand_player_detail.val_p_raise_aggressor_pos) = 1

This is because (IIRC) the val_p_raise_aggressor_pos doesn't use 8 and 9 for BB and SB yet, it uses the absolute position off the button.
e.g. at a 6 player table, the SB's absolute position is 5 off the button, which is cnt_players - val_p_raise_aggressor_pos = 6 - 5 = 1.

When I first discovered this I was told that it would be changed to bring val_p_raise_aggressor_pos into line with the other position fields and use 8 and 9 correctly, but I don't think it's been done yet.

So..... is the stat correct or not?

[WhiteRider]

The stat is correct - I tested it pretty thoroughly when I first built it, but it needs that little workaround until the database field "holdem_hand_player_detail.val_p_raise_aggressor_pos" is changed to use 8 and 9 for the blinds.

[pr1mo]

This is because (IIRC) the val_p_raise_aggressor_pos doesn't use 8 and 9 for BB and SB yet, it uses the absolute position off the button.
e.g. at a 6 player table, the SB's absolute position is 5 off the button, which is cnt_players - val_p_raise_aggressor_pos = 6 - 5 = 1.

so how would i go about building this stat to be BB Fold to BU and BB Fold to CO when they are stealing first raise in, because the problem i'm finding is that i will have to make a dif stat for every type of game based on how many players are at the table because if SB is 1 and BB is 2 and UTG is 3 then by the time u get to the button for a 10 handed game it's 0 and CO is 9; and then for a 9 handed game then button is 9 and cutoff is 8? is there another way to make this stat? or would it have to be a different BB Fold to BU or CO stat for every amount of players at the table?

[WhiteRider]

The position counts the other way.
Button=0, cutoff=1, etc.

This is exactly why for all the other position stats the BB is always 8 and SB always 9, and the aggressor position will be changed to match this.

[pr1mo]

The position counts the other way.
Button=0, cutoff=1, etc.

This is exactly why for all the other position stats the BB is always 8 and SB always 9, and the aggressor position will be changed to match this.

interesting, ya definitely having it read position stats like everything else would help a lot. how do i build this stat for BB Fold to BU and BB Fold to CO? do i just change the aggressor_pos #? what would it be for BU & CO for a full ring game?

[WhiteRider]

Yes, you just need to change the aggressor position.
Change:
(holdem_hand_summary.cnt_players - holdem_hand_player_detail.val_p_raise_aggressor_pos) = 1

to

holdem_hand_player_detail.val_p_raise_aggressor_pos = 0

for BB fold to button, or = 1 for the cutoff.