new: Resteal from BB vs BU validate plz!

[js2002]

so, things like 3bet vs early position at FR tables is not possible atm accurately....

[WhiteRider]

so, things like 3bet vs early position at FR tables is not possible atm accurately....

Correct.

[preparac]

Does this mean that the custom stat BB Fold to SB

sum(if[tourney_holdem_hand_player_statistics.flg_p_fold AND
tourney_holdem_hand_player_statistics.position = 8 AND (tourney_holdem_hand_summary.cnt_players - tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos) = 1 AND tourney_holdem_hand_player_statistics.flg_blind_def_opp,1,0])

______________________

sum(if[tourney_holdem_hand_player_statistics.position = 8 AND (tourney_holdem_hand_summary.cnt_players - tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos) = 1 AND tourney_holdem_hand_player_statistics.flg_blind_def_opp,1,0])

is broken??? :o
Anyway it gives me alway the value 0 .... would be fine to remove this broken stat with the next beta, I was messing aound with stats basing on this one quit a lot ....

By the way:
instead of

sum(if[tourney_holdem_hand_player_statistics.flg_p_3bet AND
tourney_holdem_hand_player_statistics.position = 8 AND tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 9 AND tourney_holdem_hand_player_statistics.flg_blind_def_opp,1,0])

you better use

sum(if[lookup_actions_p.action LIKE 'R%' AND
tourney_holdem_hand_player_statistics.position = 8 AND tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 9 AND tourney_holdem_hand_player_statistics.flg_blind_def_opp,1,0])

because you will count with thisone also cases when somebody 3Bet from the BB but folded or called to a 4Bet

[kraada]

I think there's a working BB fold to SB stat in the cash section by default which you should be able to convert to tournaments without much trouble.

[Mr Tiger]

js2002_cnt_p_BB_3bet_to_BU_steal
sum(if[holdem_hand_player_statistics.flg_p_3bet AND
holdem_hand_player_statistics.position = 8 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0])


js2002_cnt_p_BB_fold_to_BU_opp (numb name I know)
sum(if[holdem_hand_player_statistics.position = 8 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0])

Does it count squeeze situations: BU open raise, SB calls, BB 3bets?

[kraada]

No - once the small blind calls the big blind no longer faces a steal.

[Mr Tiger]

I have 3 stats:

Resteal SBvsBU approx

cnt_p_SB_3bet_to_BU_steal_approx
sum(if[holdem_hand_player_statistics.flg_p_3bet AND
holdem_hand_player_statistics.position = 9 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0])

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



Resteal SBvsCO approx

cnt_p_SB_3bet_to_CO_steal_approx
sum(if[holdem_hand_player_statistics.flg_p_3bet AND
holdem_hand_player_statistics.position = 9 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 1 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0])

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



3bet vs steal in SB

cnt_sb_steal_raise
sum( if[ holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_s AND holdem_hand_player_statistics.cnt_p_raise > 0, 1, 0 ])

cnt_steal_def_opp_sb
sum( if[holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_s, 1, 0])



The results for one player are: (result(number of opportunities)) 13.2(3162) 7.8(1715) 11.8(4927)

3162+1715=4877 (not 4927). It's ok. But: 3162*0.132+1715*0.078~551; 551/4877~11.3<11.8. And that is odd. When we face a steal in SB from BU or CO two main situations, which are not covered by SBvsBU and SBvsCO stats, might occur:

1) Hero 3bets, BB 4bets and BU doesn't reraise. Here we lost some "numerator" cases.
2) Hero folds, BB 3bets and BU doesn't reraise. Here we lost some "denominator" cases.

It's evident, that the second situation occurs more often than the first. Therefore in SBvsBU and SBvsCO stats denominator decreases more than numerator due to mistakes. So SBvsBU and SBvsCO stats must have greater values due to mistakes, but I see an opposite situation.

Does anybody have an explanation? Maybe holdem_hand_player_detail.val_p_raise_aggressor_pos is not changed after Hero folds(?) But even this can't be the only one explanation...

[js2002]

No - once the small blind calls the big blind no longer faces a steal.

transfered to pt4: does this mean that BU steal SB call is now resteal opp but a SQZ opp?

[Mr Tiger]

Maybe holdem_hand_player_detail.val_p_raise_aggressor_pos is not changed after Hero folds(?) But even this can't be the only one explanation...

However, no, it can. I've forgotten about the third situation: Hero calls, BB 3bets and BU doesn't reraise.
We have:

11.8 (580/4927)
11.3 (551/4877) (551=418+133)

So, we are losing 29 3bet cases and 21 "not 3bet" cases. These "not 3bet" situations might be calls.

[kraada]

js2002: If the button steals, and SB calls, the BB does not face a steal and does have a squeeze opportunity. That's how it works in both PT3 and PT4.

Mr Tiger: I think you're right - val_p_raise_aggressor_pos does some funky things, that's why we added extra data to the database to be able to specify the specific person who made each aggressive action (and each non-folding action) in PT4. Have you taken a look at PT4 yet? It's now available in a free public beta with quite a few more default stats that you might like :)