3bet preflop not all in 17-30bb

[DJSpinThat]

Hi support,

I'm having trouble creating this stat this is how far i got:

based on the built in 3Bet preflop stat,

Stat:

(cnt_p_3bet_17_30bb / cnt_p_3bet_opp_17_30bb) * 100

Column:

cnt_p_3bet_17_30bb:

sum(if[tourney_hand_player_statistics.flg_p_3bet, 1, 0])
AND
tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb<30 AND tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb>=17, 1, 0])

cnt_p_3bet_opp_17_30bb:

sum(if[tourney_hand_player_statistics.flg_p_3bet_opp, 1, 0])
AND
tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb<30 AND tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb>=17, 1, 0])


But i don't know how to incorporate "not all in" and another one for "all in"

Thank you in advance for your help.

[potamito]

Just do the opposite of the all in part of the expression you posted on the open shove custom stats on the other thread but change the ">" to "<" like this...

For all ins you use...
(tourney_hand_player_statistics.amt_p_raise_made > tourney_hand_player_statistics.amt_p_effective_stack)

Right? So for NAIs just use...
(tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack)

That will isolate 3bets where the bet size was less than the effective stacks.

[potamito]

(cnt_p_3bet_17_30bb / cnt_p_3bet_opp_17_30bb) * 100

Column:

cnt_p_3bet_17_30bb:

sum(if[tourney_hand_player_statistics.flg_p_3bet, 1, 0])
AND
tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb<30 AND tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb>=17, 1, 0])

cnt_p_3bet_opp_17_30bb:

sum(if[tourney_hand_player_statistics.flg_p_3bet_opp, 1, 0])
AND
tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb<30 AND tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb>=17, 1, 0])

Your columns are a bit messed up try it like this...

cnt_p_3bet_17_30bb

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_face_raise and tourney_hand_player_statistics.amt_p_2bet_facing < tourney_hand_player_statistics.amt_p_effective_stack andtourney_hand_player_statistics.flg_p_3bet and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 17 and 30, 1, 0])

cnt_p_3bet_opp_17_30b

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_3bet_opp and  tourney_hand_player_statistics.flg_p_face_raise and tourney_hand_player_statistics.amt_p_2bet_facing < tourney_hand_player_statistics.amt_p_effective_stack and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 17 and 30, 1, 0])

Remember if you want to create more variation of these for different effective stack szes just change this part of the expression...

Code: Select all

between 17 and 30

for whatever you need and let me know how it goes, cheers.

[DJSpinThat]

hey potamito, i appreciate your help,

1. I just searched the column for 3bet pre flop and duplicated it = cnt_p_3bet_copy and the expression was

sum(if[tourney_hand_player_statistics.flg_p_3bet, 1, 0])

so that is how i got started. (not sure how other people start making new custom stats, im a total noob so :/)

2. i literally copy pasted what you had:

cnt_p_3bet_17_30bb

sum(if[tourney_hand_player_statistics.flg_p_face_raise and tourney_hand_player_statistics.amt_p_2bet_facing < tourney_hand_player_statistics.amt_p_effective_stack andtourney_hand_player_statistics.flg_p_3bet and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 17 and 30, 1, 0])

and clicked save and got the error message "The statement is not valid SQL"

Same for the cnt_p_3bet_opp_17_30b



For whatever its worth im using pokertracker 4 v4.14.21

[Flag_Hippo]

There is a space missing in that expression:

Code: Select all

andtourney_hand_player_statistics.flg_p_3bet

[potamito]

my bad

[DJSpinThat]

hey guys, appreciate your help.

I got the columns to work.

Now i went to stat, clicked on 3bet Preflop, duplicated it, and then put

(cnt_p_3bet_17_30bb_nAI / cnt_p_3bet_opp_17_30bb_nAI) * 100

i get a invalid value expression msg....

[Flag_Hippo]

The column names you specified above don't have "_nAI" at the end.

[DJSpinThat]

columns i created were:

cnt_p_3bet_17_30bb_nAI

sum(if[tourney_hand_player_statistics.flg_p_face_raise and tourney_hand_player_statistics.amt_p_2bet_facing < tourney_hand_player_statistics.amt_p_effective_stack and tourney_hand_player_statistics.flg_p_3bet 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 30, 1, 0])

cnt_p_3bet_opp_17_30bb_nAI

sum(if[tourney_hand_player_statistics.flg_p_3bet_opp and tourney_hand_player_statistics.flg_p_face_raise and tourney_hand_player_statistics.amt_p_2bet_facing < tourney_hand_player_statistics.amt_p_effective_stack 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 30, 1, 0])

i go to stat, 3Bet Preflop, duplicate it, and put it

(cnt_p_3bet_17_30bb_nAI / cnt_p_3bet_opp_17_30bb_nAI) * 100

and click save and i get invalid value expression

[potamito]

These expressions also validates for me