3bet problem

[supaflyer]

Hi Guys,

I would like to create a stat, where the stat shows those 3bet situations, when the original raiser was raising max 30 % of his stack. So in case I commite myself, and make an "almost shove" lets say 9K from the 10K stack, and he put me allin, then it should ignore this situation as a 3bet opportunity.

I've tried to do this with the following:

(cnt_p_3bet_max30 / cnt_p_3bet_opp_max30) * 100 where

cnt_p_3bet_max30:
sum(if[tourney_hand_player_statistics.flg_p_3bet AND tourney_hand_player_statistics.amt_p_raise_made <= amt_p_effective_stack * 0.3, 1, 0])

cnt_p_3bet_opp_max30:
sum(if[tourney_hand_player_statistics.flg_p_3bet_opp AND tourney_hand_player_statistics.amt_p_raise_made <= amt_p_effective_stack * 0.3, 1, 0])

What did I mess up? How could I get the correct numbers?

Thanks,
supaflyer

[kraada]

Nothing seems obviously wrong, what kinds of problems are you seeing with the stat?

[supaflyer]

I think this stat shows those situations, when I made a 3bet which was between 0 and 30 % of my stack. I would like to see those situations, when I made an open raise between 0 an 30 % of my stack, and my enemy 3bet me. Its impossible, that I only made 3bet 20 times but its possible, that these are the numbers of my non allin 3bets.

[supaflyer]

The numbers are the following:

The built in stat (3bet pre flop) shows: 987/7641
The stat above says: (20/6674)

[kraada]

Looking at it again you don't actually need a special opportunity column - the regular 3bet opportunity will do. Anytime you have a chance to 3bet you can shove in or put in a smaller amount (and as it is you're not testing to see how much of the initial raise is left).

What kinds of tournaments are you playing? 3betting for less than 30% of the effective stack might be pretty uncommon in your games.

[supaflyer]

I've tried it:
(cnt_p_3bet_max30 / cnt_p_3bet_opp) * 100

Still not working, it looks actually worse.

My regular 3bet stat is still 987/7641
My custom stat is now: 20/7641

I play 6max hyper sngs. Starting with 500 chips. In this game its very common, that many regs even myself are raising 99% of their stack. If you raise to 480 from your 500 stack on 30/60 blinds of course you won't fold for any 3bets.

So I would like to create a 3bet stat for these situations. When I move in with 480 from my 500 chips, and my enemy 3bets for the 20 chips left, than in this case he makes a 3bet technically, but in theory its not a 3bet, he just calls my shove. I would like to hide these situations and only see those where my enemy had fold equity before 3betting (where the preflop raise is not bigger than 30 % of the preflop raiser stack).

I would like to create something like: 3bet% against preflop raiser where preflop raiser made a raise, which was maximum 30% of his stack.

I hope its clear now.

Thanks in Advance!

[kraada]

In tournaments like that I'd expect to see numbers like you're seeing. It's going to be very hard to 3bet small -- if you have a 10BB stack you'd need to be making a 3bet to < 3.5BB total and that's just not going to happen often (and it's only really possible facing a minraise).

You can use amt_p_2bet_facing to get the size of the 2bet (in chips) you're facing. I think that should be what you need to build what you want.

[supaflyer]

No. I think you still don't understand what I want. I don't want to see the small 3bets.

Let me explain with an example.

500-1000 blinds, I have 17K chips, Villain has 25K.

Hand 1: Im the SB in a 6 handed game. Im minraising to 2K, Villain (BB) shoves 25K, I fold. Its a 3bet, no question. After his 3bet % will be 100 % (1/1) after this hand. After this hand I have 15K chips left.

Hand 2: Im the button, and raising to 14K leaving 1K behind, villain (SB) shoves back for the 1K, I call. After this hand his 3bet % will be still 100 (2/2). However in the second theoretically I was allin, because 85% of my stack was in, and he had no fold equity so in this case I would like to ignore this situation and I doesn't want to get count this situation as a 3bet opportunity for him.

[kraada]

Ok, you do want a separate opportunities column for this. Change your original definitions to use tourney_hand_player_statistics.amt_p_2bet_facing rather than tourney_hand_player_statistics.amt_p_raise_made -- you don't care how much the player 3bets to, you care about the size of the 2bet he faced.

[supaflyer]

Now Im using the following:

(cnt_p_3bet_30_max / cnt_p_3bet_opp_30max) * 100

cnt_p_3bet_30_max:
sum(if[tourney_hand_player_statistics.flg_p_3bet AND tourney_hand_player_statistics.amt_p_2bet_facing <= amt_p_effective_stack * 0.3, 1, 0])

cnt_p_3bet_opp_30max:
sum(if[tourney_hand_player_statistics.flg_p_3bet_opp AND tourney_hand_player_statistics.amt_p_2bet_facing <= amt_p_effective_stack * 0.3, 1, 0])

I just tried out the new stat, still doesn't work. I played a play money HU SNG, made a raise from the sb to 40 from 1000 chips, the guy 3bet me. After this hand the stat show 1/1.

Next time on the button I raised to 800 from leaving 200 behind, he shoved back, I folded and the stat show 2/2 instead of 1/1, (the second situation shouldn't count as an opportunity for 3bet, because I raised 80% of my stack).

Please help me, I'm trying to get this ready since 4 hours, and still don't get it...


UPDATE: I just tried it again, and realised that it works, but it seems there is a bug:

Play money SNG, I'm the button, no hands about Villain. I raise to 960, he shoves, I fold.

Value: 100.0 (1/1)
This session: (0/0)

Why is this?