Thank you for guides! Now I almost made preflop, 1.1 - 1.8 are done.
[ img ]New stats here:Fold Steal to Blind Reraise (CO)
Fold Steal to Blind Reraise (BU)
Att to Steal & Call 3-Bet
Att to Steal & Call 3-Bet (BU)
Att to Steal & Call 3-Bet (CO)
Att to Steal & Call 3-Bet (SB)
Att to Steal & 4-Bet
Att to Steal & 4-Bet (BU)
Att to Steal & 4-Bet (CO)
Att to Steal & 4-Bet (SB)
And now need some help with 2.
2) Fold to Preflop 4Bet after Restealing New stat: Fold Resteal to 4-Bet
New stat: Fold Resteal to 4-Bet (SB)
New stat: Fold Resteal to 4-Bet (BB)
New stat: Fold Resteal to 4-Bet (BB vs SB)
I took the old stat for example:
3Bet Preflop And Fold to 4BetIt's exp:
(cnt_p_3bet_fold / cnt_p_3b_face_4b) * 100So I made these columns for new stats:
new column: cnt_steal_3bet_face_4b
new column: cnt_steal_3bet_face_4b_SB
new column: cnt_steal_3bet_face_4b_BB
new column: cnt_steal_3bet_fold
new column: cnt_steal_3bet_fold_SB
new column: cnt_steal_3bet_fold_BB
Expressions for them:
column: cnt_steal_3bet_face_4bexp: sum(if[holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_p_4bet_def_opp, 1, 0])
column: cnt_steal_3bet_face_4b_SBexp: sum(if[holdem_hand_player_statistics.position = 9 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_p_4bet_def_opp, 1, 0])
column: cnt_steal_3bet_face_4b_BBexp: sum(if[holdem_hand_player_statistics.position = 8 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_p_4bet_def_opp, 1, 0])
column: cnt_steal_3bet_foldexp: sum(if[holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_p_3bet and holdem_hand_player_statistics.enum_p_4bet_action = 'F', 1, 0])
column: cnt_steal_3bet_fold_SBexp: sum(if[holdem_hand_player_statistics.position = 9 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_p_3bet and holdem_hand_player_statistics.enum_p_4bet_action = 'F', 1, 0])
column: cnt_steal_3bet_fold_BBexp: sum(if[holdem_hand_player_statistics.position = 8 AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_p_3bet and holdem_hand_player_statistics.enum_p_4bet_action = 'F', 1, 0])
Can you check it above, am I correct?
And now I'm still cant understand how to make the last stat:
Fold Resteal to 4-Bet (BB vs SB) How to use this expressions like lookup and action correctly?
(sum(if[lookup_actions_p.action LIKE 'R%' AND
holdem_hand_player_statistics.position = 8 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 9 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0]))