3 Bet All in and 3 Bet Not all Stats

[Zito]

I would like two distinct stats to distinguish between an all in 3 bet (3bai) and a non all in 3b (3bnai).

The 3bai should be an effective all in, so if an opponent 6x's my pfr this would be considered a 3bai. Likewise the 3bnai would be capped at sub 6x 3 bets.

[kraada]

These could certainly be built, though you could be more accurate about it in PT4 than in PT3 as in PT4 we directly store the size of the 2bet faced and 3bet made.

[Zito]

Thanks, I'll be using PT4.

So I take I would need to add if statements to the: (cnt_p_3bet / cnt_p_3bet_opp) * 100

I'm new to custom stating so specific help would be much appreciated.

[kraada]

You'd need to be editing the columns themselves - cnt_p_3bet and cnt_p_3bet_opp are columns. Take a look on the Columns page to see the definitions.

Start with those though, that'll get you a place to begin. To make a version that's a 3bet of 6x the amount needed to call a 2bet (or more) inside the first part of the if[] statement add "AND cash_hand_player_statistics.amt_p_raise_made >= 6 * cash_hand_player_statistics.amt_p_2bet_facing" so you'd get:

cnt_p_3bet_ai: sum(if[cash_hand_player_statistics.flg_p_3bet AND cash_hand_player_statistics.amt_p_raise_made >= 6 * cash_hand_player_statistics.amt_p_2bet_facing, 1, 0])

For the non all-in version you can either make a < 6 version or in the stat just subtract. You'll want the same opportunity column so your all-in 3bet would be:
(cnt_p_3bet_ai / cnt_p_3bet_opp) * 100

and then you can either make the other as:
((cnt_p_3bet - cnt_p_3bet_ai) / cnt_p_3bet_opp) * 100

or make a non-all-in column and use that one instead.

[Zito]

To make a version that's a 3bet of 6x the amount needed to call a 2bet (or more)
cash_hand_player_statistics.amt_p_raise_made >= 6 * cash_hand_player_statistics.amt_p_2bet_facing, 1, 0])

I'm not sure if I'm reading you correctly, but the 3bai stat I'm interested in, is where we make a standard pre flop raise (2x,2.5x, never 6x) and the opponent 3 bets to 6 times+ this amount. Does this column refer to the pre flop raise or the amount of the 3 bet?

cash_hand_player_statistics.amt_p_raise_made >= 6

[kraada]

Ah if you want 6 big blinds then it's 6 * cash_limit.amt_bb.

[Zito]

Is this the correct way to say that the 3 bet is at least 50% of the effective stack?

Code: Select all

tourney_hand_player_statistics.amt_p_effective_stack >= 0.5 , 1, 0])

[kraada]

Did you miss part of your expression? You'd want:
tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack * .5 and you'd also need to specify that you 3bet.

[Zito]

Yep, I missed half of it, for any one who's interested:

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_3bet AND tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack * .5, 1, 0])

Need a little help coming up with the fold to 3 bet not all in stats, for the fold to 3 bet all in column, I've got:

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_3bet AND tourney_hand_player_statistics.enum_p_3bet_action='F' AND tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack * .5, 1, 0])

and so on for different stack sizes, I having trouble conceptualizing is it as simple as:

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_3bet AND tourney_hand_player_statistics.enum_p_3bet_action='F' AND tourney_hand_player_statistics.amt_p_raise_made < tourney_hand_player_statistics.amt_p_effective_stack * .5, 1, 0])

or would it best to subtract "3bet_ai" from the standard 3bet to get my non all in 3bet?

[kraada]

Either way should work though you may also want to think about the size of the 2bet - if the 2bet was really big and you minraised in response and it meant the 3bet was relatively small it wouldn't match your filter as put together.

Though that's not exactly going to be common it seems worth mentioning.