Check Raise Flop MRP

[DANNI BASTOS]

I made a statistic based on 'Check Raise Flop'
What is the percentage of times that the BB player makes XR flop in a bet in HU months, with 10 to 100b of effective stack and in a preflop minraise

player:
preflop C
flop XR

(cnt_f_check_raise_10more / cnt_f_check_raise_opp_10more) * 100

cnt_f_check_raise_10more
sum(if[(tourney_hand_player_statistics.val_p_raise_aggressor_pos=9 AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) BETWEEN 1.99 and 2.10) and tourney_hand_summary.cnt_players = 2 AND
tourney_hand_player_statistics.position=8 AND
(tourney_hand_player_statistics.val_f_bet_facing_pct <=40) AND
((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 AND 100) AND
tourney_hand_player_statistics.flg_f_check_raise, 1, 0])

cnt_f_check_raise_opp_10more
sum(if[tourney_hand_summary.cnt_players = 2 AND
tourney_hand_player_statistics.position=8 AND
(tourney_hand_player_statistics.val_f_bet_facing_pct <=40) AND
((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 AND 100) AND
(tourney_hand_player_statistics.val_p_raise_aggressor_pos=9 AND
((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) BETWEEN 1.99 and 2.10) and tourney_hand_player_statistics.flg_f_check AND (tourney_hand_player_statistics.cnt_f_raise > 0 OR tourney_hand_player_statistics.cnt_f_call > 0 OR tourney_hand_player_statistics.flg_f_fold), 1, 0])

Please let me know if everything is correct.

[Flag_Hippo]

preflop C

This isn't specified so if the BB 3Bets vs the min raise and SB 4Bets then those hands would get counted too (provided the SB bets the flop).

(tourney_hand_player_statistics.val_f_bet_facing_pct <=40)

Flop bet sizing is not mentioned in your description so I am not sure if it should be there or not.

[DANNI BASTOS]

This isn't specified so if the BB 3Bets vs the min raise and SB 4Bets then those hands would get counted too (provided the SB bets the flop).

How do I specify that the player only called on the flop, can you show me the line to add to this statistic?

Flop bet sizing is not mentioned in your description so I am not sure if it should be there or not.

When I place (tourney_hand_player_statistics.val_f_bet_facing_pct <=40), am I not specifying the size of the bet?

[Flag_Hippo]

This isn't specified so if the BB 3Bets vs the min raise and SB 4Bets then those hands would get counted too (provided the SB bets the flop).

How do I specify that the player only called on the flop, can you show me the line to add to this statistic?

This was for preflop and not the flop. You can specify that the player only made a single call preflop with:

Code: Select all

lookup_actions_p.action = 'C'

Flop bet sizing is not mentioned in your description so I am not sure if it should be there or not.

When I place (tourney_hand_player_statistics.val_f_bet_facing_pct <=40), am I not specifying the size of the bet?

I was just mentioning this because this wasn't included anywhere in the written description of the statistic from your original post. If it's meant to be there you can leave it.

[fadrianocm]

Could you please confirm for me if everything is ok now?

cnt_f_check_raise_10more
sum(if[(tourney_hand_player_statistics.val_p_raise_aggressor_pos=9 AND lookup_actions_p.action = 'C' and((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) BETWEEN 1.99 and 2.10) and tourney_hand_summary.cnt_players = 2 AND
tourney_hand_player_statistics.position=8 AND
(tourney_hand_player_statistics.val_f_bet_facing_pct <=40) AND
((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 AND 100) AND
tourney_hand_player_statistics.flg_f_check_raise, 1, 0])

cnt_f_check_raise_opp_10more
sum(if[tourney_hand_summary.cnt_players = 2 AND
tourney_hand_player_statistics.position=8 AND lookup_actions_p.action = 'C' AND
(tourney_hand_player_statistics.val_f_bet_facing_pct <=40) AND
((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 AND 100) AND
(tourney_hand_player_statistics.val_p_raise_aggressor_pos=9 AND
((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) BETWEEN 1.99 and 2.10) and tourney_hand_player_statistics.flg_f_check AND (tourney_hand_player_statistics.cnt_f_raise > 0 OR tourney_hand_player_statistics.cnt_f_call > 0 OR tourney_hand_player_statistics.flg_f_fold), 1, 0])


As for (tourney_hand_player_statistics.val_f_bet_facing_pct <=40), yes! It was supposed to be there, sorry I didn't mention it.

[Flag_Hippo]

Yes that's fine.

[DANNI BASTOS]

Excellent!

I'm also looking to do the same stats for the limp pot.
There are just a few changes that follow below.
Please confirm for me that this is correct.

stats: cnt_lp_f_check_raise_10more/cnt_lp_f_check_raise_opp_10more

cnt_lp_f_check_raise_10more
sum(if[(lookup_actions_p.action = 'X' AND
tourney_hand_summary.cnt_players = 2 AND
tourney_hand_player_statistics.position=8 AND
(tourney_hand_player_statistics.val_f_bet_facing_pct <=40) AND
((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 AND 100) AND
tourney_hand_player_statistics.flg_f_check_raise, 1, 0])

cnt_lp_f_check_raise_opp_10more
sum(if[tourney_hand_summary.cnt_players = 2 AND
tourney_hand_player_statistics.position=8 AND
lookup_actions_p.action = 'X' AND
(tourney_hand_player_statistics.val_f_bet_facing_pct <=40) AND
((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 AND 100) AND
tourney_hand_player_statistics.flg_f_check AND
(tourney_hand_player_statistics.cnt_f_raise > 0 OR tourney_hand_player_statistics.cnt_f_call > 0 OR tourney_hand_player_statistics.flg_f_fold), 1, 0])

[Flag_Hippo]

Yes that's fine although this will not validate with the extra bracket you've inserted:

sum(if[(lookup_actions_p.action = 'X' AND tourney_hand_summary.cnt_players = 2 AND tourney_hand_player_statistics.position=8 AND (tourney_hand_player_statistics.val_f_bet_facing_pct <=40) AND ((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 AND 100) AND tourney_hand_player_statistics.flg_f_check_raise, 1, 0])

Also you can test your column expressions yourself by using he method described in this post.