Fold, call, raise Cbet IP & OOP

[omgtupux]

Hello,

I'm a total noob with custom stats but i made some research to find those stats:

Fold Cbet IP:
cnt_f_cbet_def_action_fold_in_pos
sum(if[substring(lookup_actions_f.action from 1 for 1)<>'X' AND holdem_hand_player_statistics.enum_f_cbet_action='F', 1, 0])

Fold Cbet OOP:
cnt_f_cbet_def_action_fold_out_of_pos
sum(if[substring(lookup_actions_f.action from 1 for 1)='X' AND holdem_hand_player_statistics.enum_f_cbet_action='F', 1, 0])

Cbet raised flop IP:
cnt_f_cbet_ip: sum(if[holdem_hand_player_detail.flg_f_has_position
AND holdem_hand_player_statistics.flg_f_cbet AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp)), 1, 0])

cbet raised flop oop:
cnt_f_cbet_opp_ip: sum(if[holdem_hand_player_detail.flg_f_has_position AND holdem_hand_player_statistics.flg_f_cbet_opp AND NOT((holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_3bet)OR(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp)), 1, 0])

I'd like to know if it's actually working?

[kraada]

You need to change the raise OOP version to not(holdem_hand_player_detail.flg_f_has_position).

Those columns otherwise look good. You'll want to also add opportunity columns (which if you can construct those should not be difficult) and then put the ones you've just built over the opportunities and multiply by 100 to make the statistic on the Statistics tab. The Statistics are what displays, but they need to be constructed out of the columns.

[degoor]

The opportunities columns for Fold Cbet IP and Fold Cbet OOP should respectively be:

Fold Cbet IP opportunities:

cnt_f_cbet_def_action_fold_ip_opp
sum(if[substring(lookup_actions_f.action from 1 for 1)<>'X' AND holdem_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])

Fold Cbet OOP opportunities:

cnt_f_cbet_def_action_fold_out_opp
sum(if[substring(lookup_actions_f.action from 1 for 1)='X' AND holdem_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])

Is that correct?

[kraada]

That will work.