thanks for the detailed explanation, i believe i understand the _facing part, but its also nice to have this back to refer to for me and others who are confused about it. Thank you.
I'm trying to make BU raise, and folds to a PF 3bet (initial raiser is IP - BU)
so 3H, BU raise, and there is a 3bet (or more) that happens,and when action is back to BU, the BU folds.
I started with the "Fold to PF 3Bet After Raise IP" stat, (please correct me if anywhere along the way)
(cnt_p_3bet_def_action_fold_when_open_raised_ip / cnt_p_3bet_def_opp_when_open_raised_ip) * 100
cnt_p_3bet_def_action_fold_when_open_raised_ip:
char_length(tourney_hand_summary.str_aggressors_p) >= 3 and tourney_hand_player_statistics.enum_p_3bet_action='F' AND tourney_hand_player_statistics.flg_p_first_raise AND substring(tourney_hand_summary.str_aggressors_p from 3 for 1)::int > tourney_hand_player_statistics.position
cnt_p_3bet_def_opp_when_open_raised_ip:
char_length(tourney_hand_summary.str_aggressors_p) >= 3 and tourney_hand_player_statistics.flg_p_3bet_def_opp AND tourney_hand_player_statistics.flg_p_first_raise AND substring(tourney_hand_summary.str_aggressors_p from 3 for 1)::int > tourney_hand_player_statistics.position
After testing in the expression filter, i get a bunch of different scenarios i don't want, so to break it down, the exact scenarios would be:
BU raise (this is what i was asking initially - specify BU raise size)
1. BU raise, SB fold, BB 3Bets, BU fold
2. BU raise, SB 3Bet, BB fold, BU fold
3. BU raise SB call, BB 3B, BU fold
4. BU raise, SB 3bet, BB calls, BU fold
(if SB has bigger stack than BB, then BB calls and is AI), BU folds
(if SB has smaller stack than BB, then its just a cold call of 3B), BU folds
5. BU raise, SB 3bet, BB 4bet, BU fold
(only if SB has smaller stack than BB, a 4bet is possible)
So i guess i have to use agg and actors?, which would be:
1
agg 808
act 08
2
agg 809
act 09
3
agg 808
act 09
4
agg 809
act 098
5. --> this is covered in scenario 2 since 809% will include 8098 and 09% will include 098, so i believe 5. is not required
agg 8098
act 098
Scenerio 1-4 would be:
tourney_hand_summary.str_aggressors_p LIKE '808%' and tourney_hand_summary.str_actors_p LIKE '08%'
tourney_hand_summary.str_aggressors_p LIKE '809%' and tourney_hand_summary.str_actors_p LIKE '09%'
tourney_hand_summary.str_aggressors_p LIKE '808%' and tourney_hand_summary.str_actors_p LIKE '09%'
tourney_hand_summary.str_aggressors_p LIKE '809%' and tourney_hand_summary.str_actors_p LIKE '098%'
Q1 is this even correct? or am i way off the rails here
Q2 im assuming this would work if i add all 4 of this to the original stat and connect using "OR"? so:
Raise BU (IP) and F to 3Bet+
(cnt_p_3bet_def_action_fold_BU / cnt_p_3bet_def_opp_BU)
- Code: Select all
sum(if[char_length(tourney_hand_summary.str_aggressors_p) >= 3 and tourney_hand_player_statistics.enum_p_3bet_action='F' AND tourney_hand_player_statistics.flg_p_first_raise AND substring(tourney_hand_summary.str_aggressors_p from 3 for 1)::int > tourney_hand_player_statistics.position and tourney_hand_summary.str_aggressors_p LIKE '808%' and tourney_hand_summary.str_actors_p LIKE '08%' or tourney_hand_summary.str_aggressors_p LIKE '809%' and tourney_hand_summary.str_actors_p LIKE '09%' or tourney_hand_summary.str_aggressors_p LIKE '808%' and tourney_hand_summary.str_actors_p LIKE '09%' or tourney_hand_summary.str_aggressors_p LIKE '809%' and tourney_hand_summary.str_actors_p LIKE '098%, 1, 0])
- Code: Select all
sum(if[char_length(tourney_hand_summary.str_aggressors_p) >= 3 and tourney_hand_player_statistics.flg_p_3bet_def_opp AND tourney_hand_player_statistics.flg_p_first_raise AND substring(tourney_hand_summary.str_aggressors_p from 3 for 1)::int > tourney_hand_player_statistics.position and tourney_hand_summary.str_aggressors_p LIKE '808%' and tourney_hand_summary.str_actors_p LIKE '08%' or tourney_hand_summary.str_aggressors_p LIKE '809%' and tourney_hand_summary.str_actors_p LIKE '09%' or tourney_hand_summary.str_aggressors_p LIKE '808%' and tourney_hand_summary.str_actors_p LIKE '09%' or tourney_hand_summary.str_aggressors_p LIKE '809%' and tourney_hand_summary.str_actors_p LIKE '098%', 1, 0])
Q3 and then back to my initial inquiry of, how to specify BU MR or BU 3x etc.? i tried adding "and tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb = 2" for MR, but when checking the hands in filter expression, i found a hand where BU 5x, or BU OS w 8bb etc... so i was confused. Is there a way to specify the first raise size since we are using " tourney_hand_player_statistics.flg_p_first_raise" in our columns?
Sorry for the long post and being annoying, just trying to be as detailed as possible and trying to understand this.