new: Resteal from BB vs BU validate plz!

[js2002]

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])

Hi folks,

I took the fold BB vs BU steal Stat and made this one. The denumerator is the same, at the numerator I replaced "substring(lookup_actions_p.action from 1 for 1)='F'" with "holdem_hand_player_statistics.flg_p_3bet".
Do you think this stat expresses what I want?

2. SB was = 9 right?!

[kraada]

Yes the SB is 9 and BB is 8, and that stat should work as you would expect so far as I can tell.

[js2002]

Ca u tell me whats the SB (and BB) in this column:

holdem_hand_player_detail.val_p_raise_aggressor_pos = ?

[WhiteRider]

That's the same.

[js2002]

Just to be sure and not build wrong stats:
holdem_hand_player_detail.val_p_raise_aggressor_pos = 9 == SB correct?!

so that Resteal BB vs SB 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 = 9 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0])
_________________________

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])

ok?

[kraada]

Yes, and yes.

[js2002]

[quote="js2002"]js2002_cnt_p_BB_3bet_to_HJ_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 = 2 AND
holdem_hand_player_statistics.flg_blind_def_opp
,1,0])


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

How do I do this for "Resteal in BB vs HJ" ? , because the column "flg_blind_def_opp" will always return false.

[kraada]

You're not going to be able to get it working right from the HJ because there's no way to be certain as the player on the button that the raise you're facing came from the HJ; we can be certain most of the time, but not all of the time, so this stat won't be able to be 100% accurate.

[js2002]

You're not going to be able to get it working right from the HJ because there's no way to be certain as the player on the button that the raise you're facing came from the HJ; we can be certain most of the time, but not all of the time, so this stat won't be able to be 100% accurate.

Why cant we be certain? holdem_hand_player_detail.val_p_raise_aggressor_pos = 2 tells us that the PFA sits in HJ.

[kraada]

Because if the BB reraises after, then val_p_raise_aggressor_pos is 8.

Also, if the HJ limps, you raise from the button and the HJ 3-bets val_p_raise_aggressor_pos is 2 but it's not the situation you're looking for.