Page 1 of 3
stat: BB folds when SB opens

Posted:
Fri Aug 01, 2008 5:42 am
by 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.
Re: stat: BB folds when SB opens

Posted:
Fri Aug 01, 2008 5:49 am
by 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).
Re: stat: BB folds when SB opens

Posted:
Fri Aug 01, 2008 6:26 pm
by 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.
Re: stat: BB folds when SB opens

Posted:
Fri Aug 01, 2008 7:17 pm
by SaiYeN
just made a support ticket about this.
Re: stat: BB folds when SB opens

Posted:
Sat Aug 02, 2008 4:04 am
by 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.
Re: stat: BB folds when SB opens

Posted:
Sun Aug 03, 2008 11:19 am
by 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?
Re: stat: BB folds when SB opens

Posted:
Sun Aug 03, 2008 11:28 am
by 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')
Re: stat: BB folds when SB opens

Posted:
Wed Aug 06, 2008 2:21 pm
by 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?
Re: stat: BB folds when SB opens

Posted:
Wed Aug 06, 2008 3:36 pm
by WhiteRider
I'll have a look at it shortly..
Re: stat: BB folds when SB opens

Posted:
Wed Aug 06, 2008 4:40 pm
by 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.