3bet vs specefic opener position

[mkjmkjmkj]

i would like to make a stat which tells the 3bet percentages vs the preflop raisers postion
how often will a villain 3bet a sb opener a button opener and a CO opener ect.

is that possible

[kraada]

That is not possible to build accurately in PT3 due to the constraints of the database. These stats are built in by default in PT4.

[kroma]

this is bad?

Code: Select all

name: cnt_p_3bet_vs_MP3_opp
sum(if[ holdem_hand_player_statistics.flg_p_3bet_opp AND
(holdem_hand_player_detail.val_p_raise_aggressor_pos = 2) AND
(holdem_hand_player_statistics.flg_p_3bet = 'TRUE') AND NOT
holdem_hand_player_statistics.flg_p_4bet, 1, 0])

name: cnt_p_3bet_vs_MP3_opp
sum(if[ holdem_hand_player_statistics.flg_p_3bet_opp AND
(holdem_hand_player_detail.val_p_raise_aggressor_pos = 2) AND NOT
holdem_hand_player_statistics.flg_p_4bet, 1, 0])

-------------------

name: cnt_p_3bet_vs_CO
sum(if[ holdem_hand_player_statistics.flg_p_3bet_opp AND
(holdem_hand_player_detail.val_p_raise_aggressor_pos = 1) AND
(holdem_hand_player_statistics.flg_p_3bet = 'TRUE') AND NOT
holdem_hand_player_statistics.flg_p_4bet, 1, 0])

name: cnt_p_3bet_vs_CO_opp
sum(if[ holdem_hand_player_statistics.flg_p_3bet_opp AND
(holdem_hand_player_detail.val_p_raise_aggressor_pos = 1) AND NOT
holdem_hand_player_statistics.flg_p_4bet, 1, 0])

-----------

name: cnt_p_3bet_vs_BTN
sum(if[ holdem_hand_player_statistics.flg_p_3bet_opp AND
(holdem_hand_player_detail.val_p_raise_aggressor_pos = 0) AND
(holdem_hand_player_statistics.flg_p_3bet = 'TRUE') AND NOT
holdem_hand_player_statistics.flg_p_4bet, 1, 0])

name: cnt_p_3bet_vs_BTN_opp
sum(if[ holdem_hand_player_statistics.flg_p_3bet_opp AND
(holdem_hand_player_detail.val_p_raise_aggressor_pos = 0) AND NOT
holdem_hand_player_statistics.flg_p_4bet, 1, 0])

----------

name: cnt_p_3bet_vs_SB_opp
sum(if[ holdem_hand_player_statistics.flg_p_3bet_opp AND
(holdem_hand_player_detail.val_p_raise_aggressor_pos = 9) AND
(holdem_hand_player_statistics.flg_p_3bet = 'TRUE') AND NOT
holdem_hand_player_statistics.flg_p_4bet, 1, 0])

name: cnt_p_3bet_vs_SB_opp
sum(if[ holdem_hand_player_statistics.flg_p_3bet_opp AND
(holdem_hand_player_detail.val_p_raise_aggressor_pos = 9) AND NOT
holdem_hand_player_statistics.flg_p_4bet, 1, 0])

[kraada]

Those will not work accurately because of how the val_p_raise_aggressor_pos value works in the PT3 database - it stores the value of the last aggressor who wasn't you. Thus if you face an EP raise and fold ant the BB 3-bets it stores the BB's position. As such the opportunity column will not be accurate.

We have added data to the database so that these stats are available for PT4 by default.