Bet sucess

[Flag_Hippo]

Do you know how I could create a 2bet flop success stat?

To establish that the player 2Bet the flop you can start with the existing column for that action which is called 'cnt_f_bet_def_action_raise' and used in the '2Bet Flop' statistic. A 2Bet on the flop will be considered a success if the turn wasn't seen:

Code: Select all

NOT (cash_hand_player_statistics.flg_t_saw)

and if the player did not take any subsequent actions on the flop (folding, calling or raising again). You can do that by removing the % sign in the original 'cnt_f_bet_def_action_raise' column expression.

[gkamvysis]

Not sure how I could do it this way. It could help if I knew the cash_hand_player_statistics for the flop 2bet and for facing flop 3bet so I could follow the same process as clanty did before by replacing cash_hand_player_statistics.flg_f_bet and cash_hand_player_statistics.flg_t_face_raise.

[Flag_Hippo]

Not sure how I could do it this way. It could help if I knew the cash_hand_player_statistics for the flop 2bet and for facing flop 3bet so I could follow the same process as clanty did before by replacing cash_hand_player_statistics.flg_f_bet and cash_hand_player_statistics.flg_t_face_raise.

As per my original reply what you need for a flop 2Bet is in the built-in column for called 'cnt_f_bet_def_action_raise' and to determine if the flop 2bet was successful all you need to do is specify that the turn wasn't seen and remove the '%' sign from the column expression:

Step 1 - duplicate the 'cnt_f_bet_def_action_raise' column.

Step 2 - call the new column 'cnt_f_bet_def_action_raise_success'.

Step 3 - add NOT (cash_hand_player_statistics.flg_t_saw) to the new column expression.

Step 4 - remove the '%' sign from the new column expression such that you end up with this:

cnt_f_bet_def_action_raise_success

Code: Select all

sum(if[cash_hand_player_statistics.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(R|XR)') AND NOT (cash_hand_player_statistics.flg_t_saw), 1, 0])

Step 5 - create a new custom 2Bet Flop success statistic with the following value expression:

Code: Select all

(cnt_f_bet_def_action_raise_success / cnt_f_bet_def_action_raise) * 100

[gkamvysis]

Thank you very much!