Stats based only on hands played vs hero ?

[WhiteRider]

If the SB faces a min raise then they have to call 3 in a pot of 7 = 3/7 = 42.86%.

The BB is a bit more complicated:
If the min raise is from the cutoff or button then the pot is 7 and the call is 2 = 2/7 = 28.57%
If the min raise is from the SB then the pot is 6 and the call is 2 = 2/6 = 33.33%

If you're actually raising to 4.2 instead of 4 you'll have to tweak the numbers of course.

[joker]

But I actually did the math - 2.2/7.2 = 30.5555 % and "fold BB to steal" stat already contains "holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 30.5 and 30.6" ... I did the math for a SB as well - 3.2/7.2 = 44.4444 % and add this to columns : "holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 44.3 and 44.5" and it works perfectly in coleration with report. I don´t know why is it not working for BB.

[kraada]

So exactly what column are you using for the BB right now?

[joker]

cnt_bb_steal_fold_21:

sum( if[holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 30.5 and 30.6, 1, 0])

cnt_steal_def_opp_bb_21:

sum(if[holdem_hand_player_statistics.flg_bb_steal_fold AND holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 30.5 and 30.6, 1, 0])

[kraada]

Try this instead and see if it catches all of the situations you want:

cnt_bb_steal_fold_21:

sum( if[holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_b AND (holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 30.5 and 30.6 OR holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 35.4 and 35.5), 1, 0])

cnt_steal_def_opp_bb_21:

sum(if[holdem_hand_player_statistics.flg_bb_steal_fold AND (holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 30.5 and 30.6 OR holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 35.4 and 35.5), 1, 0])

This takes into account times it was folded to the SB and he opened to 4.2 - see the earlier posts WhiteRider made.

[WhiteRider]

cnt_bb_steal_fold_21:

sum( if[holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 30.5 and 30.6, 1, 0])

cnt_steal_def_opp_bb_21:

sum(if[holdem_hand_player_statistics.flg_bb_steal_fold AND holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 30.5 and 30.6, 1, 0])

Just to check - these columns are labelled the wrong way round. You have got them right in PT3, haven't you?
You'll still need Kraada's OR too, of course.

[joker]

So the original "fold BB to steal" stat includes both situations when player on BB is facing steal from co/btn and also only from sb ? If yes, than this stat :

(cnt_bb_steal_fold_21 / cnt_steal_def_opp_bb_21) * 100

cnt_bb_steal_fold_21:

sum( if[holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 30.5 and 30.6, 1, 0])

cnt_steal_def_opp_bb_21:

sum(if[holdem_hand_player_statistics.flg_bb_steal_fold AND holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 30.5 and 30.6, 1, 0])

should only shows situations when he is facing steal from co/btn, due to pot ratio "filter", am I right ? If yes, than it is exactly what I am looking for, because I want to see how they are reacting vs co/btn, because for sb vs bb steal situation I already have a special stat.

[joker]

I will answer it myself - yes, now it shows exactly what I want - fold BB to btn steal only, thank you for your help again.

[kraada]

You're welcome; I'm glad to hear everything is working well for you.

[Darvini]

To which raise holdem_hand_player_detail.val_p_raise_facing_pct refers to? The first one faced or the last one?