PokerTracker

Hi,

I would like to make a 3bet stat but ran into problems doing this:

For example 3 stats like:
3Bet x2 = 2.00-2.25
3Bet x2,5 = 2.25-2.75
3Bet x3 = 2.75-3.25

I code them in psydocode like (amt_3betsize / amt_bb) / (2bet_p_facing / amt_bb) ...

CO open 2bb, Here in BTN is "2bet_p_facing" 2bb. correct/useable
The problem now:
BTN opens 2bb, Hero in BB is only "2bet_p_facing" 1bb!
BTN opens 2bb, Hero in SB is only "2bet_p_facing" 1.5bb!
How do I make a positional unware stat that corrects the BB and SB positions "2bet_p_facing" values?

Greetings

js2002

amt_p_2bet_facing is the amount the player needs to call so that's correct. If you want the absolute size of the 2bet then you can add the amount of any blind posted by the player to the size of 2bet faced:

Code: Select all

(cash_hand_player_statistics.amt_p_2bet_facing + cash_hand_player_statistics.amt_blind)

Hi Hippo,

ich know that but I dont know when do add it because the stat should be for every position in total.
So I am searching for the calculation like "if in SB add amt_sb". "if in BB, add amt_bb" and else do not add any.

It will work like that for every position. cash_hand_player_statistics.amt_blind is the amount of any blind posted by the player so if the player hasn't posted a blind it will be zero.

Great! this was my misunderstanding thx a lot

Hi Flag_Hippo and everybody feel free to comment this:

I think I got it, but could you please verify/validate my solution:

I want to build these stats:
3Bet IP x2 = 2.00-2.25
3Bet IP x2,5= 2.25-2.75
3Bet IP x3 = 2.75-3.25
3Bet IP x3,5= 3.25-3.75
...

Stat
"3Bet IP x2"
((3bet_ip_2 - 3bet_ip_225) / 3bet_ip_denum) * 100

The three columns:

3bet_ip_2
sum(if[cash_hand_player_statistics.flg_p_3bet AND
cash_hand_player_statistics.position < cash_hand_player_statistics.val_p_raise_aggressor_pos AND
cash_hand_player_statistics.amt_p_raise_made >= 2*(cash_hand_player_statistics.amt_p_2bet_facing + cash_hand_player_statistics.amt_blind), 1, 0])

3bet_ip_225
sum(if[cash_hand_player_statistics.flg_p_3bet AND
cash_hand_player_statistics.position < cash_hand_player_statistics.val_p_raise_aggressor_pos AND
cash_hand_player_statistics.amt_p_raise_made >= 2.25*(cash_hand_player_statistics.amt_p_2bet_facing + cash_hand_player_statistics.amt_blind), 1, 0])

3bet_ip_denum
sum(if[cash_hand_player_statistics.flg_p_3bet_opp AND
cash_hand_player_statistics.position < cash_hand_player_statistics.val_p_raise_aggressor_pos, 1, 0])

1. What do you think? Will this be useful/accurate/correct?! I know I don't define "correct", but maybe you see some error?

This exlained point no. 2: https://www.pokertracker.com/forums/vie ... 18&t=23047
2. Where can I see the definition of "cash_hand_player_statistics.val_p_raise_aggressor_pos"? If I 3bet in BU position will this be TRUE => cash_hand_player_statistics.position = cash_hand_player_statistics.val_p_raise_aggressor_pos, so 0 = 0 ? If yes, how do I get the position of the 2bet guy?

val_p_raise_aggressor_pos is the position of the last player other than the active player to raise so if you want to compare the position of the 3bettor to the position of the 2bettor that isn't always going to be suitable since it's possible for another player other than the 2bettor to 4bet+ (e.g. cold 4bets). You can compare the position of the 2bettor to the player like this:

Code: Select all

char_length(cash_hand_summary.str_aggressors_p) >= 2 and substring(cash_hand_summary.str_aggressors_p from 2 for 1) ::int > cash_hand_player_statistics.position

See this thread and this thread for more information.

Could you explain the expression/statement please, thx in advance.

understand now thx

OK great. If you need anything clarified just let us know.