stat: BB folds when SB opens

[banshee]

hi,

does someone have an idea how to realize that? As far as I know 'folded BB to steal' only includes a BTN or CO raise.

[WhiteRider]

Steal stats include steals by the SB.
To work out who the steal raiser is, you would need to create a Custom Statistic.
Custom Statistics and Reports FAQ.

You can get the position of the aggressor using the DB field
holdem_hand_player_detail.val_p_raise_aggressor_pos
SB position is always 9 (off the button).

[SaiYeN]

There's a lot of problems with the holdem_hand_player_detail.val_p_raise_aggressor_pos field.

1) SB position is NOT always 9 (off the button). Same for BB not always 8. In a 6max game, the SB is being counted as position 5 and BB position 4. In a 5 handed game, the SB is 4 and BB is 3. etc

2) a lot of hands have the that field as -1, i can't figure out why.

3) in 3bet pots, the value of it isn't consistent. Sometimes its the position of the 3better and others the opener.

[SaiYeN]

just made a support ticket about this.

[WhiteRider]

Thanks for submitting your ticket.
I haven't experimented much with this field, so I'm not really sure.

1. Really? It should always be 8 and 9 for the blinds. I'll experiment.
2. I suspect this is when there is no aggressor, although if there are errors with the stat then it could be a mistake, of course.
3. Thanks - we'll investigate.

[banshee]

what about this one:

sum(if[holdem_hand_player_statistics.flg_p_fold AND holdem_hand_player_statistics.position = 9 AND
holdem_hand_player_detail.val_p_raise_aggressor_pos = 8,1,0])

Does that exclude cases where the BB 3bets anf folds to a 4bet?

[WhiteRider]

I think you have your 8 and 9 the wrong way round. 8 is BB, 9 is SB (SB is further from the button, in terms of postition off the button, if you see what I mean..).

This looks ok but doesn't isolate blind steals, it would include hands with previous action, limps or raises.

You may want to do something like:
flg_p_fold AND position=8 AND val_p_raise_aggressor_pos = 9 AND holdem_hand_player_statistics.flg_blind_def_opp
(in fact, if the aggressor is pos 9 then you HAVE to be pos 8 to be facing a blind steal, so you could probably do without 'position=8')

[banshee]

okay I've done it as follows:

numerator: sum(if[holdem_hand_player_statistics.flg_p_fold AND
holdem_hand_player_statistics.position = 8 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 9 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0])

denominator: sum(if[holdem_hand_player_statistics.position = 8 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 9 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0])

shown at the tables as numerator / denominator * 100

Somehow it's always 0. Does someone see the mistake?

[WhiteRider]

I'll have a look at it shortly..

[SaiYeN]

the stat is always 0 cause the holdem_hand_player_detail.val_p_raise_aggressor_pos has a bunch of errors. I listed whats wrong earlier. There's nothing wrong with your stat. I made the stat and it's always 0 for me too. Basically the SB isnt being recorded as position 9 so when you do holdem_hand_player_detail.val_p_raise_aggressor_pos = 9 it's false unless you have a bunch of full ring hands. Until they fix this, there's no way to make this stat.