3BP Cbet F/T/R Positional stats

[babylon4ever]

Hello,

I'm looking to make custom stats for short handed (6max cash) that would have:

CBet flop 3BetPot IP/OOP separate stats
CBet Turn 3betPot IP/OOP separate stats
Cbet River 3betPot IP/OOP (triple barrel) separate stats

I found one old thread with some help for IP/OOP cbets like:

(cnt_t_cbet_ip / cnt_t_cbet_opp_ip) * 100 however I could not

AND turn cbet SRP:

((cnt_t_cbet - cnt_t_cbet_3bet_pot) / (cnt_t_cbet_opp - cnt_t_cbet_opp_3bet_pot)) * 100

Could you please advice how can I filter the 3bet pots in the first place and then whether the 3bettor is IP/OOP.

Thank you in advance.

[Flag_Hippo]

Each custom statistic needs two columns built using expressions. See this guide for the basics on custom statistics creation and this guide for a deeper walkthrough. For example:

Flop c-bet, 3bet pot, in position:

Code: Select all

sum(if[cash_hand_player_statistics.flg_f_cbet AND cash_hand_player_statistics.flg_p_3bet AND char_length(cash_hand_summary.str_aggressors_p) = 3 AND cash_hand_player_statistics.flg_f_has_position, 1, 0])

Code: Select all

sum(if[cash_hand_player_statistics.flg_f_cbet_opp AND cash_hand_player_statistics.flg_p_3bet AND char_length(cash_hand_summary.str_aggressors_p) = 3 AND cash_hand_player_statistics.flg_f_has_position, 1, 0])

Turn and river: replace flg_f_cbet, flg_f_cbet_opp and flg_f_has_position with the t or r versions.

For OOP columns use:

Code: Select all

NOT cash_hand_player_statistics.flg_f_has_position