openbet flop in limped pot when HU - need validation

[Markovcev]

Hi,

I need to create a stat that will show "how often the player bets the flop when is HU in limped pot"

I suppose it should be like this:

Code: Select all

(cnt_f_bet_limp_pot_hu / cnt_f_open_opp_limp_pot_hu) * 100

where:
cnt_f_bet_limp_pot_hu =

Code: Select all

sum(if[cash_hand_player_statistics.flg_f_bet and cash_hand_summary.cnt_players_f = 2 and NOT(cash_hand_player_statistics.flg_p_face_raise) and cash_hand_player_statistics.cnt_p_raise = 0, 1, 0])

and
cnt_f_open_opp_limp_pot_hu =

Code: Select all

sum(if[cash_hand_player_statistics.flg_f_open_opp and cash_hand_summary.cnt_players_f = 2 and not(cash_hand_player_statistics.flg_p_face_raise) and cash_hand_player_statistics.cnt_p_raise = 0, 1, 0])

Could you kindly check whether everything is right?

[WhiteRider]

Yes, that looks good!

[Markovcev]

Great! Thanks a lot!

[Markovcev]

One more thing.

Now I need the stat that will calculate the percentage of folds to the action above, e.g. to the Flop open-bet in limped pot HU.

I've created that like this:

Code: Select all

(cnt_f_fold_limp_pot_hu / cnt_f_face_bet_limp_pot_hu) * 100

where:
cnt_f_fold_limp_pot_hu =

Code: Select all

sum(if[cash_hand_player_statistics.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(F|XF)') AND cash_hand_summary.cnt_players_f = 2 AND NOT(cash_hand_player_statistics.flg_p_face_raise) AND cash_hand_player_statistics.cnt_p_raise = 0, 1, 0])


and:
cnt_f_face_bet_limp_pot_hu =

Code: Select all

sum(if[cash_hand_player_statistics.amt_f_bet_facing > 0 AND cash_hand_summary.cnt_players_f = 2 AND NOT(cash_hand_player_statistics.flg_p_face_raise) AND cash_hand_player_statistics.cnt_p_raise = 0, 1, 0])

The main concern is the calculation not of all folds but only folds that will follow the flop open-bet.
example:
A bets, B folds
and/or
B checks, A bets, B folds
and not
A bets, B raises, A 3-bets, B folds

Am I right that this (lookup_actions_f.action SIMILAR TO '(F|XF)') will do exactly what I need?

Thanks in advance.

[WhiteRider]

Yes, that looks good again.

Am I right that this (lookup_actions_f.action SIMILAR TO '(F|XF)') will do exactly what I need?

Yes - you are checking that the player faced a bet so if their actions were fold or check/fold then they must have folded to the bet.

[Markovcev]

Thank you.