3bet no AI

[peridz]

Hello, I'm trying to create a statistic that is fold against a non-all-in 3Bet. I'm using this code:
`SUM(IF(tourney_hand_player_statistics.enum_p_3bet_action = 'F'
AND tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb < 8, 1, 0)) ,
but it's not valid, it says.

[Flag_Hippo]

but it's not valid

That's not the correct format:

Code: Select all

sum(if[tourney_hand_player_statistics.enum_p_3bet_action = 'F' AND tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb < 8, 1, 0])

I'm trying to create a statistic that is fold against a non-all-in 3Bet.

There is also nothing in your expression to say that the 3Bet was not all-in - see this thread.

[peridz]

Thank you very much for your response. While it's true that there isn't an expression that explicitly states that a 3bet is not an all-in, I suppose it would be more appropriate to have a phrase that indicates that a 3bet is at a size smaller than 1/3 of the effective stack. I'm not sure if such a phrase or something similar exists. The idea is to have a stat for playing spin and go, which is why I included the condition of being smaller than 8. However, I see that it's not the most accurate approach. How could I improve it? Any advice? Thank you.

[Flag_Hippo]

While it's true that there isn't an expression that explicitly states that a 3bet is not an all-in, I suppose it would be more appropriate to have a phrase that indicates that a 3bet is at a size smaller than 1/3 of the effective stack. I'm not sure if such a phrase or something similar exists. The idea is to have a stat for playing spin and go, which is why I included the condition of being smaller than 8.

Your expression doesn't do this either. Anything using "tourney_hand_player_statistics" is specific to the player you are writing the statistic for and tourney_hand_player_statistics.amt_p_raise_made is the size of the first raise made by that player so:

Code: Select all

tourney_hand_player_statistics.enum_p_3bet_action = 'F' AND tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb < 8

means the player folded to a 3Bet after 2betting with a size less than 8bb. If you want to test the size of the 3Bet faced by the player the thread I linked you to has an expression that does this:

Code: Select all

((tourney_hand_player_statistics.amt_p_raise_made + tourney_hand_player_statistics.amt_p_3bet_facing) < tourney_hand_player_statistics.amt_p_effective_stack)

[peridz]

Is it possible for this statistic to be correct? I want to know how many times a player folds after opening preflop when facing a non-all-in 3bet. The formula is
(FOLD_P_3BET_NAI / cnt_p_3bet_def_opp_copy) * 100 where the column FOLD_P_3BET_NA is
sum(if[tourney_hand_player_statistics.enum_p_3bet_action='F' AND tourney_hand_player_statistics.flg_p_first_raise AND tourney_hand_player_statistics.flg_p_open_opp AND ((tourney_hand_player_statistics.amt_p_raise_made + tourney_hand_player_statistics.amt_p_3bet_facing) < tourney_hand_player_statistics.amt_p_effective_stack), 1, 0])
where the column cnt_p_3bet_def_opp_copy is
sum(if[tourney_hand_player_statistics.flg_p_3bet_def_opp AND tourney_hand_player_statistics.flg_p_first_raise AND ((tourney_hand_player_statistics.amt_p_raise_made + tourney_hand_player_statistics.amt_p_3bet_facing) < tourney_hand_player_statistics.amt_p_effective_stack), 1, 0])

Thank you for your patience.

[Flag_Hippo]

You are using tourney_hand_player_statistics.flg_p_open_opp in the first column but not the second. For the statistic to be accurate you need to use it in both columns or not use it at all. Whether you use it or not depends on if you want to count only 2Bets that were RFI's or all 2Bets (RFI's and vs limpers).

[peridz]

Thank you very much, I will remove it. The range of ROL will not be the same as RFI. I would also like to divide this statistic into blind ranges, the expression (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN XBB to XBB. Should it be included in both columns as well?

[Flag_Hippo]

Yes you would need use that in both columns.

[peridz]

Thank you very much for your help.