CO fold vs BU 3 bet

[Flag_Hippo]

I'm trying to do stats [Position] fold vs [Position] 3 bet.
I need a clarification: the values I need to change are "cash_hand_player_statistics.position = 1"

You change that based on the position of the player who is folding.

and "cash_hand_summary.str_aggressors_p LIKE '810%', 1, 0]", right? "809%" is for sb and "810%" is for the other positions?

'809%' is for the BTN 2betting and the SB 3betting. '810%' is for the CO 2betting and the BTN 3betting. See this post for more information on how the aggressors and actors strings are defined.

[ThrustWorld]

So the numbers inside "" represent the position + action of the respective player. Now it is clear, thanks!

[Toddhoy]

Hey I'm also keen to use this but don't actually know how to implement .

I have saved the SQL as a column but then don't know how to make into the proper stat. I assume it needs to be the column cnt_p_3bet_def_action_fold_when_rfi_co_vs_btn divided by another custom column which is RFI CO and face 3bet multiplied by 100?

So the denominator should be something like: sum(if[cash_hand_player_statistics.flg_p_first_raise and cash_hand_player_statistics.flg_p_open_opp and cash_hand_player_statistics.position = 1 and cash_hand_player_statistics.flg_p_3bet_def_opp and cash_hand_summary.str_aggressors_p LIKE '810%', 1, 0])

Basically just tried to remove the fold condition from the denominator to get the % of times the fold happens when the action took place. And then we can use this stat in all players report?
Pls help!

Cheers

[Flag_Hippo]

Yes that's correct.

[Toddhoy]

Thanks for confirming! Sorry to be a pest but is it possible to add a condition to filter to a range of 3bet sizes? I only want to look at hands where the 3bettor made it between 10 and 15 big blinds

[Flag_Hippo]

For that you can add:

Code: Select all

((cash_hand_player_statistics.amt_p_raise_made + cash_hand_player_statistics.amt_p_3bet_facing) / cash_limit.amt_bb) between 10 and 15