BBvsSB fold to cbet (custom stat)

[dave2085]

Trying to build this stat. but failing hard since 2hours.

stat: SB openraises - BB calls - SB cbets and how often BB folds.

this is my try....


sum(if[cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.position = 9, 1, 0 AND cash_hand_player_statistics.enum_f_cbet_action='F', 1, 0 AND cash_hand_player_statistics.position=8])

i think i have a big mistake in there because i have to switch preflop from SB perspective to postflp BB persperctive but i dont know how to... :/

[Flag_Hippo]

You need to define all of the actions, preflop and postflop, from the point of view of the player who the stat is for so you cannot use cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.position = 9 for this. If you want to specify the preflop action sequence by positions you can use the aggressors and actors strings like this:

Code: Select all

sum(if[cash_hand_player_statistics.position=8 and cash_hand_summary.str_aggressors_p LIKE '89' and cash_hand_summary.str_actors_p LIKE '98' and cash_hand_player_statistics.enum_f_cbet_action='F', 1, 0])

See this post for more information on how the actors and aggressors strings work.