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

[OneKef]

Good morning Hippo, I had already filled them all in and had in nightmare, I then discovered that I can change the column without having to do it all over again :D :D
Thanks!

[OneKef]

Okay, I'm doing something wrong here too, in spite of everything...
Please, give me a confirmation.

3Bet-Jam from SB vs CO 17-25bb

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_3bet_opp and tourney_hand_summary.str_aggressors_p LIKE '819%' and tourney_hand_summary.str_actors_p LIKE '1%' 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 25, 1, 0])

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_3bet_opp and tourney_hand_summary.str_aggressors_p LIKE '81%' and tourney_hand_summary.str_actors_p LIKE '1%' AND NOT tourney_hand_player_statistics.flg_p_squeeze_opp AND tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack 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 25, 1, 0])

3Bet NAI from SB vs CO 20-25x

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_3bet_opp and tourney_hand_summary.str_aggressors_p LIKE '819%' and tourney_hand_summary.str_actors_p LIKE '1%' 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 (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 25 and 25, 1, 0])

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_3bet_opp and tourney_hand_summary.str_aggressors_p LIKE '81%' and tourney_hand_summary.str_actors_p LIKE '1%' 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 20 and 25, 1, 0])

As usual, I messed up a little bit by creating them and I have to fix it :(

[OneKef]

In the NAI 3bet I missed the same thing as in the cbet post...meanwhile

[Flag_Hippo]

Using a comparison like tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack is not sufficient to say that the player raised - it will just plugin a value of 0 if the player made no raise and had a 3bet opportunity and you also haven't specified the position of the player with the 3bet opportunity you want to count (SB) and it's not only the SB who can have a 3Bet opportunity - the BTN has one too. The BB will also have a 3Bet opportunity if the SB does not 3Bet so you will get hands counted from positions you do not want with actions you do not want. Also in the first NAI column you are filtering for a stack size of between 25 and 25. You can do it like this:

Code: Select all

sum(if[tourney_hand_player_statistics.position = 9 AND tourney_hand_player_statistics.flg_p_3bet AND tourney_hand_summary.str_aggressors_p LIKE '819%' AND tourney_hand_summary.str_actors_p LIKE '19%' 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 (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 20 AND 25, 1, 0])

Code: Select all

sum(if[tourney_hand_player_statistics.position = 9 AND tourney_hand_player_statistics.flg_p_3bet_opp AND tourney_hand_summary.str_aggressors_p LIKE '81%' 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 20 AND 25, 1, 0])

In the NAI 3bet I missed the same thing as in the cbet post...meanwhile

That's not relevant for this stat. In the other stat for Cbets the preflop raise is always made in both columns since the hand was going to the flop but in this hand the small blind isn't always going to be making a preflop raise so that comparison should only be included in the columns where the 3Bet was made. If you include the comparison in the opportunities column then the hands that were 3Bet all-in will not be counted as opportunities to not 3Bet all-in.

[OneKef]

Let's see, in the 3bet-jam I should remove from the opportunities

Code: Select all

tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack

So they should be right, right? will be calculated the Stack eff?

Now I'm going to recheck the 3bet nai because at the moment it doesn't give me correct results.
Also, these stats will not count previously played hands right, or by rebuilding cashe finds them?

[Flag_Hippo]

Let's see, in the 3bet-jam I should remove from the opportunities

Code: Select all

tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack

So they should be right, right? will be calculated the Stack eff?

The players effective stack size is being tested for separately with this:

Code: Select all

tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 20 AND 25

If you don't remove:

Code: Select all

tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack

then the hands that were 3Bet all-in will not be counted as opportunities to not 3Bet all-in.

Now I'm going to recheck the 3bet nai because at the moment it doesn't give me correct results.
Also, these stats will not count previously played hands right, or by rebuilding cashe finds them?

After creating new custom columns or editing existing custom columns it's recommended to rebuild the custom database cache otherwise you may see incorrect values until the cache is updated.

[OneKef]

Thank you for your patience ajime no hippo

3Bet AI BB vs BTN 17-25x

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 3) 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 25, 1, 0])

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 3) AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 17 and 25, 1, 0])

is it okay like this?

[Flag_Hippo]

You need to specify the position of the player the statistic is written for (tourney_hand_player_statistics.position) otherwise the columns may count other positions too. In this example you want this for the BB but your column can also count 3bet opportunities for the SB:

Code: Select all

sum(if[tourney_hand_player_statistics.position = 8 AND tourney_hand_player_statistics.flg_p_3bet AND tourney_hand_summary.str_aggressors_p LIKE '808%' AND tourney_hand_summary.str_actors_p LIKE '08%' AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind / tourney_blinds.amt_bb) BETWEEN 2 AND 3) 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 17 AND 25, 1, 0])

Code: Select all

sum(if[tourney_hand_player_statistics.position = 8 AND 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 3) AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 17 AND 25, 1, 0])

[OneKef]

Okay, on the first page I thought I understood that they were okay, a crazy

[Flag_Hippo]

Okay, on the first page I thought I understood that they were okay, a crazy

If a statistic is for a specific position it is good practice to always specify that within your columns using tourney_hand_player_statistics.position rather than relying on other things in the column to infer the players position.