3bet NAI between 15 and 25bb and or shortstack mtt

[aquiles9099]

Hi i'm trying to create these stats but I'm big noob in programming, I already have the 3bet No all in and it's working: (threebet_nai / cnt_p_3bet_opp) * 100

The thing is if someone let's behind 0,01 bb it tracks it as NAI, how can i fix this?

And I'm trying to do another one for OR NAI as shortstack(between 8 and 15bb) in MTT, this is the best code i could get looking in the forum and trying to implement it, the code is not working:
sum(if[(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 8 and 15 AND tourney_hand_player_statistics.flg_p_open_opp, 1, 0] AND BetSize BETWEEN 2 and 3)

Help me plzzzzzzzzzzz

[Flag_Hippo]

Hi i'm trying to create these stats but I'm big noob in programming, I already have the 3bet No all in and it's working: (threebet_nai / cnt_p_3bet_opp) * 100

The thing is if someone let's behind 0,01 bb it tracks it as NAI, how can i fix this?

If you can provide the expression used for your custom column (threebet_nai) and the hand example we can take a look at that.

And I'm trying to do another one for OR NAI as shortstack(between 8 and 15bb) in MTT, this is the best code i could get looking in the forum and trying to implement it, the code is not working:
sum(if[(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 8 and 15 AND tourney_hand_player_statistics.flg_p_open_opp, 1, 0] AND BetSize BETWEEN 2 and 3)

1. The entire expression needs to be inside the sum(if[, 1, 0]) statement:

sum(if[expression, 1, 0])

2. 'BetSize' is not a part of the database schema. If you want the size of the players first preflop raise then that is:

Code: Select all

tourney_hand_player_statistics.amt_p_raise_made

and to convert that to big blinds you need to divide by:

Code: Select all

tourney_blinds.amt_bb

See this guide for the basics on custom statistics creation and this guide for a deeper walkthrough. While the latter was written for PokerTracker 3 and the user interface is different the techniques still apply to PokerTracker 4.