Call PFR - Blinds

[preparac]

I'm setting up my custom stats again and I'm looking for a statt that tells me how maniy times (%) a player called a preflop raise in the blinds, when the raise didn't come from the other blind.

(cnt_p_pfr_call_opp_bl / cnt_p_pfr_call_opp_bl) * 100

when
cnt_p_pfr_call_opp_bl
=
sum(if[tourney_holdem_hand_player_statistics.flg_p_face_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp = false AND tourney_holdem_hand_player_statistics.flg_f_first_raise = false AND (tourney_holdem_hand_player_statistics.flg_blind_b OR tourney_holdem_hand_player_statistics.flg_blind_s) , 1, 0])

and
cnt_p_pfr_call_opp_bl
=
sum(if[tourney_holdem_hand_player_statistics.flg_p_face_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp = false AND tourney_holdem_hand_player_statistics.flg_f_first_raise = false AND (tourney_holdem_hand_player_statistics.flg_blind_b OR tourney_holdem_hand_player_statistics.flg_blind_s) , 1, 0])

But at least some cases I don't rule out whith this formula (for example I'm in the SB, sombedoy limps in front of me, I limp also and BB raises; or I'm in the BB and SB raises ...)

Does a clean stat Call PFR - Blinds already exist, that rules out all first raises from the blinds?

I'm setting up my custom stats again and I'm looking for a statt that tells me how maniy times (%) a player called a preflop raise in the blinds, when the raise didn't come from the other blind.

(cnt_p_pfr_call_opp_bl / cnt_p_pfr_call_opp_bl) * 100

when
cnt_p_pfr_call_opp_bl
=
sum(if[tourney_holdem_hand_player_statistics.flg_p_face_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp = false AND tourney_holdem_hand_player_statistics.flg_f_first_raise = false AND (tourney_holdem_hand_player_statistics.flg_blind_b OR tourney_holdem_hand_player_statistics.flg_blind_s) , 1, 0])

and
cnt_p_pfr_call_opp_bl
=
sum(if[tourney_holdem_hand_player_statistics.flg_p_face_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp = false AND tourney_holdem_hand_player_statistics.flg_f_first_raise = false AND (tourney_holdem_hand_player_statistics.flg_blind_b OR tourney_holdem_hand_player_statistics.flg_blind_s) , 1, 0])

But at least some cases I don't rule out whith this formula (for example I'm in the SB, sombedoy limps in front of me, I limp also and BB raises; or I'm in the BB and SB raises ...)

Does a clean stat Call PFR - Blinds already exist, that rules out all first raises from the blinds?


I'm setting up my custom stats again and I'm looking for a statt that tells me how maniy times (%) a player called a preflop raise in the blinds, when the raise didn't come from the other blind.

(cnt_p_pfr_call_opp_bl / cnt_p_pfr_call_opp_bl) * 100

when
cnt_p_pfr_call_opp_bl
=
sum(if[tourney_holdem_hand_player_statistics.flg_p_face_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp = false AND tourney_holdem_hand_player_statistics.flg_f_first_raise = false AND (tourney_holdem_hand_player_statistics.flg_blind_b OR tourney_holdem_hand_player_statistics.flg_blind_s) , 1, 0])

and
cnt_p_pfr_call_opp_bl
=
sum(if[tourney_holdem_hand_player_statistics.flg_p_face_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp = false AND tourney_holdem_hand_player_statistics.flg_f_first_raise = false AND (tourney_holdem_hand_player_statistics.flg_blind_b OR tourney_holdem_hand_player_statistics.flg_blind_s) , 1, 0])

But at least some cases I don't rule out whith this formula (for example I'm in the SB, sombedoy limps in front of me, I limp also and BB raises; or I'm in the BB and SB raises ...)

Does a clean stat Call PFR - Blinds already exist, that rules out all first raises from the blinds?

thanks for any hints

[WhiteRider]

You might be able to do this using: holdem_hand_player_detail.val_p_raise_aggressor_pos.
This records the position of the preflop aggressor (i.e. last player apart from 'hero' to raise preflop) and will work fine when there is a single raiser.
However, in a few cases this could get messed up too. For instance if someone limps, then there is a raise, you call in the BB and the limper reraises and you both call then val_p_raise_aggressor_pos will be the position of the limp/reraiser not the original raiser.

I think that pinning this down exactly will be pretty tough, if not impossible. I have made a suggestion to the development team that would make this kind of thing much easier, but I don't know if or when it will be implemented.

I don't have time to investigate this any further now, but I'm sure Kraada will have a look at it tomorrow, and if anything occurs to me I'll post back too.

[preparac]

Any news about this issue?

I propose for the nominator

sum(if[tourney_holdem_hand_player_statistics.flg_p_open_opp = false AND lookup_actions_p.action LIKE 'C%' AND

(tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 OR tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 1 OR tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 2 OR tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 3 OR tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 4 OR tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 5 OR tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 6 OR tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 7) AND

(tourney_holdem_hand_player_statistics.flg_blind_b OR tourney_holdem_hand_player_statistics.flg_blind_s), 1, 0])

and for the denominator

sum(if[tourney_holdem_hand_player_statistics.flg_p_face_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp = false AND

(tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 OR tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 1 OR tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 2 OR tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 3 OR tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 4 OR tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 5 OR tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 6 OR tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 7) AND

(tourney_holdem_hand_player_statistics.flg_blind_b OR tourney_holdem_hand_player_statistics.flg_blind_s) , 1, 0])

...

I think I cannot figure out a way to exclude case where vilain1 limps, hero limps in SB, vilain2 in the BB raises, and vilain1 reraises

... Any coments?

[WhiteRider]

I still don't think there is a way to do this accurately.
If your columns you could just check "tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos < 8" rather than checking each position individually.