How to create ''3bet ai'' and ''3bet nai''.

[OneKef]

Hi, I'm a bit rusty.
Help me create a stat for ''3bet ai'' and ''3bet nai'' please.
For mtt, so on open standard 2/3x count the 3bets from 2.5x+...at the moment I don't even know how to insert the stack values ​​:(
I also checked maybe old posts but anyway, I can't make columns/strings work anymore and I don't know where to start.
Thank you so much.

[Flag_Hippo]

There is an example of that type of statistic in this thread.

[OneKef]

Hello and thank you always.
I came back for this stat, I got here:

3Bet-All in BB vs BU
first column:

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_3bet_opp and tourney_hand_summary.str_aggressors_p LIKE '808%' and tourney_hand_summary.str_actors_p LIKE '0%' AND NOT tourney_hand_player_statistics.flg_p_squeeze_opp AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind / tourney_blinds.amt_bb) BETWEEN 2 and 2.5) AND tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack AND NOT tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(p|P)' AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 17 and 30, 1, 0])

second column

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_3bet_opp and tourney_hand_summary.str_aggressors_p LIKE '808%' and tourney_hand_summary.str_actors_p LIKE '0%' AND NOT tourney_hand_player_statistics.flg_p_squeeze_opp AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind / tourney_blinds.amt_bb) BETWEEN 2 and 2.5) AND tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack AND NOT tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(p|P)' AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 17 and 30, 1, 0])

I've wasted a lot of time regaining what I knew, now I have to detach and I'm afraid I won't find myself again lol
The columns are identical, what am I forgetting?
Testing it seems to work but I don't remember that the two columns had to be identical.
(RFI BTN>3Bet/jam BB)

[Flag_Hippo]

The columns should not be identical. If you want to know how often the player 3bets all-in when they have the opportunity to do so then you wouldn't test for the 3bet itself in the second column:

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_3bet_opp and tourney_hand_summary.str_aggressors_p LIKE '80%' and tourney_hand_summary.str_actors_p LIKE '0%' AND NOT tourney_hand_player_statistics.flg_p_squeeze_opp AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind / tourney_blinds.amt_bb) BETWEEN 2 and 2.5) AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 17 and 30, 1, 0])

[OneKef]

Well, fair enough lol
I said that I worked too hard on it!
Thanks always Hippo <3
Now I'm stuck vs ep (EP+EP1) I can't figure out how to insert them , I want to make them for 8max now, I can't insert 4 and 5 position...

[OneKef]

Good morning, maybe I need to integrate something like this, I'll try.
https://www.pokertracker.com/forums/vie ... ep#p372191

I have a new database so few cases, could this work in your opinion?

1

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_3bet_opp and tourney_hand_summary.str_aggressors_p SIMILAR TO '848|858%' and tourney_hand_summary.str_actors_p SIMILAR TO '4|5%' AND NOT tourney_hand_player_statistics.flg_p_squeeze_opp AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind / tourney_blinds.amt_bb) BETWEEN 2 and 2.5) AND tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack AND NOT tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(p|P)' AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 17 and 30, 1, 0])

2

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_3bet_opp and tourney_hand_summary.str_aggressors_p SIMILAR TO '84|85%' and tourney_hand_summary.str_actors_p SIMILAR TO '4|5%' AND NOT tourney_hand_player_statistics.flg_p_squeeze_opp AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind / tourney_blinds.amt_bb) BETWEEN 2 and 2.5) AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 17 and 30, 1, 0])

[OneKef]

OK, I think I forgot the percentage symbol, it seems to be working.

[OneKef]

I'm asking if this might be okay for non-AI jams:
BB 3bet vs BTN Open 19/25x

1

Code: Select all

sum(if[tourney_hand_player_statistics.position = 8 AND NOT tourney_hand_player_statistics.flg_p_squeeze_opp AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind / tourney_blinds.amt_bb) BETWEEN 2 and 2.5) AND NOT tourney_hand_player_statistics.flg_p_squeeze_opp AND tourney_hand_player_statistics.flg_p_3bet AND tourney_hand_summary.str_actors_p LIKE '0%' AND tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 19 and 25, 1, 0])

2

Code: Select all

sum(if[tourney_hand_player_statistics.position = 8 AND tourney_hand_player_statistics.flg_p_3bet_opp AND NOT tourney_hand_player_statistics.flg_p_squeeze_opp AND tourney_hand_summary.str_actors_p LIKE '9%' AND tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 19 and 25, 1, 0])

Am I forgetting something as usual?

[OneKef]

Ok, in the last post there is a bit of a mess, I think I solved it like this

BU open and BB 3bet NAI 36/100x
1

Code: Select all

 sum(if[tourney_hand_player_statistics.flg_p_3bet_opp and tourney_hand_summary.str_aggressors_p LIKE '808%' and tourney_hand_summary.str_actors_p LIKE '0%' AND NOT tourney_hand_player_statistics.flg_p_squeeze_opp AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind / tourney_blinds.amt_bb) BETWEEN 2 and 2.5) AND tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack AND NOT tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(p|P)' AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 36 and 100, 1, 0])

2

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_3bet_opp and tourney_hand_summary.str_aggressors_p LIKE '80%' and tourney_hand_summary.str_actors_p LIKE '0%' AND NOT tourney_hand_player_statistics.flg_p_squeeze_opp AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind / tourney_blinds.amt_bb) BETWEEN 2 and 2.5) AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 36 and 100, 1, 0])

[Flag_Hippo]

You should remove this:

Code: Select all

AND NOT tourney_hand_player_statistics.enum_face_allin SIMILAR TO '(p|P)'

If the player 3bets as described and then folds to a subsequent 4bet all-in then that 3bet is not going to get counted towards the stat while the 3bet opportunity is still being counted.