Raise Flop and fold

[philip77]

Hi,

I wanted to know if it is possible to build a stat which will count the percentage of time a player will raise the flop and then fold to a Turn or River bet or raise. I will not include the times the player fold to a 3bet on the flop.

Thanks

[kraada]

Yes it is, the key database fields you need to check are cash_hand_player_statistics.flg_t_fold and cash_hand_player_statistics.flg_r_fold - these are true when a player has folded on the respective streets.

So to create this stat for the numerator you'd want:
sum(if[cash_hand_player_statistics.cnt_f_raise > 0 and (cash_hand_player_statistics.flg_t_fold or cash_hand_player_statistics.flg_r_fold), 1, 0])

For the denominator:

sum(if[cash_hand_player_statistics.cnt_f_raise > 0 and (cash_hand_player_statistics.cnt_t_call > 0 or cash_hand_player_statistics.cnt_t_raise > 0 or cash_hand_player_statistics.flg_t_fold or cash_hand_player_statistics.flg_r_fold or cash_hand_player_statistics.cnt_r_call > 0 or cash_hand_player_statistics.cnt_r_raise > 0), 1, 0])

Here we just make sure you raised the flop and either called, raised or folded on the turn or the river - this way we are certain you had a chance to fold.

[philip77]

Thanks