3b vs RWPC custom stat help

[tlballer]

Hi, I was trying to make a custom stat with the help of AI. I want to make a stat that tells me how much someone 3bets after someone makes an iso raise. The AI gave me this. It gives me no errors but when I try to lookup someone in the HUD it gives me 0% on everybody even though I'm sure they have 3b an iso raise.

(cnt_3bet_vs_rwpc / cnt_opp_3bet_vs_rwpc) * 100

Columns below

Code: Select all

sum(if[ cash_hand_player_statistics.flg_p_3bet AND cash_hand_player_statistics.flg_p_face_raise AND NOT cash_hand_player_statistics.flg_p_open_opp AND cash_hand_player_statistics.cnt_p_face_limpers > 0, 1, 0 ])

Code: Select all

sum(if[ cash_hand_player_statistics.flg_p_face_raise AND NOT cash_hand_player_statistics.flg_p_open_opp AND cash_hand_player_statistics.cnt_p_face_limpers > 0 AND cash_hand_player_statistics.flg_p_3bet_def_opp, 1, 0 ])

https://i.imgur.com/2G6Iiu3.png - here is a screenshot it gave me and a breakdown of all stats. Please help with where it went wrong.

Thanks!

[Flag_Hippo]

cash_hand_player_statistics.flg_p_3bet_def_opp

This is for a 3bet defend opportunity which is not applicable when you are creating a stat for the player who is 3betting. This should be changed to:

Code: Select all

cash_hand_player_statistics.flg_p_3bet_opp

cash_hand_player_statistics.flg_p_face_raise

This test is not required since by definition it's already true if the player is 3betting or has the opportunity to 3bet.

cash_hand_player_statistics.cnt_p_face_limpers > 0

Anything using "cash_hand_player_statistics" is specific to that player (the player the stat is written for) and since the 3bettor is not facing any limpers directly this will not be true. You'll need to test that there were one or more limpers, the player did not limp-3bet themselves and it wasn't a squeeze opportunity:

Code: Select all

sum(if[cash_hand_player_statistics.flg_p_3bet AND NOT cash_hand_player_statistics.flg_p_limp AND NOT cash_hand_player_statistics.flg_p_squeeze_opp AND char_length(cash_hand_summary.str_aggressors_p) >= 2 AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int != substring(cash_hand_summary.str_actors_p from 1 for 1)::int, 1, 0])

This post has information on how the actors and aggressors strings work while this thread and this thread discuss how the strings can be compared/tested.

[tlballer]

Thank you!