4bet | Position vs Position

[Ajeetav Nayak]

Hi

I am trying to create a 4 bet position vs position statistic. For example, How many times CO 4 bets after, a CO open and BU 3 bet.

Here are my columns

cnt_CO4bet_vs_BU3bet

sum(if[cash_hand_player_statistics.position = 1 AND
cash_hand_player_statistics.enum_p_3bet_action = '4bet' AND
cash_hand_summary.str_aggressors_p = '8101' AND
cash_hand_summary.str_actors_p = '101', 1, 0])


cnt_CO4bet_opp_vsBU3bet

sum(if[cash_hand_player_statistics.position = 1 AND
cash_hand_summary.str_aggressors_p ='810' AND
cash_hand_summary.str_actors_p = '10', 1, 0])

While my Opp column seems to be ok, the other one is drawing a reading of 0.

Help !

[Flag_Hippo]

cash_hand_player_statistics.enum_p_3bet_action = '4bet'

The action a player takes when facing a 3bet is either fold (F), call (C) or raise (R) so if they 4bet that would be:

Code: Select all

cash_hand_player_statistics.enum_p_3bet_action = 'R'

however you do not need to use this at all because you have already specified in the aggressors string that the player in seat one 4bet with:

Code: Select all

cash_hand_summary.str_aggressors_p = '8101'

although this needs changing as if the hand gets 5bet the hand will not be counted because you are limiting the aggressors string to 4bet hands only. If you want to inlcude possible future actions you can use:

Code: Select all

cash_hand_summary.str_aggressors_p LIKE '8101%'

A similar change will also be needed for the other strings to account for future actions. For example your opportunities column isn't going to count any hands that do get 4bet as you've specified the aggressors string is only '810' and the actors string is '10'. For more information on pattern matching in PostgreSQL see this guide. You can also use pattern matching to include/exclude other scenarios. For example the current actions column excludes the blinds from calling in-between so assuming you don't want to count those hands you would need to account for that in the opportunities column as well.

[Ajeetav Nayak]

Thanks so much !

This is very helpful. I have made the following changes

cnt_CO4bet_vs_BU3bet

sum(if[cash_hand_player_statistics.position = 1 AND
cash_hand_summary.str_aggressors_p LIKE '8101%' and cash_hand_summary.str_actors_p LIKE '101%', 1, 0])


cnt_CO4bet_opp_vsBU3bet

sum(if[cash_hand_player_statistics.position = 1 AND
cash_hand_player_statistics.flg_p_4bet_opp AND
cash_hand_summary.str_aggressors_p LIKE'810%' AND cash_hand_summary.str_actors_p LIKE '10%', 1, 0])

Do you think this should work fine ?

[Flag_Hippo]

As I mentioned in my previous reply you need to account for what the blinds do so it isn't entirely accurate. For example if a player in the blinds calls the 3bet and the CO 4bets your current column it will count that as an opportunity but not an action. Decide whether you want to include/exclude the blinds from calling and then account for that in both columns.