new* stat: fold to push after 4bet ...

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

new* stat: fold to push after 4bet ...

Postby js2002 » Wed Apr 08, 2009 6:03 am

Hi,
could you please check this:

fold to push after 4bet
defined by rfi and 4bet and face3bet and fold

The stat shall say "How often did he do a 2bet and a 4bet and faced an allin and folded?"
Its for >= NL50SH and the huge aggression on higher limits. So, I shall tell, if he bluff 4bets.


cnt_p_allin_def_action_fold
sum(if[holdem_hand_player_statistics.flg_p_first_raise AND
holdem_hand_player_statistics.flg_p_4bet AND
holdem_hand_player_statistics.enum_face_allin_action='F', 1, 0])

cnt_p_allin_def_opp
sum(if[holdem_hand_player_statistics.flg_p_first_raise AND
holdem_hand_player_statistics.flg_p_4bet AND
holdem_hand_player_statistics.enum_face_allin<>'N', 1, 0])

Is enum_face_allin_action and enum_face_allin<>'N' correctly used? Is this enough or would you recommend changes?
How do I get the size of the 4Bet? It would be very interesting, when he readable, so that small 4bets mean KK+ or 4Bet/fold.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: new* stat: fold to push after 4bet ...

Postby kraada » Wed Apr 08, 2009 8:53 am

We're just looking at preflop pushes, right?

holdem_hand_player_statistics.enum_face_allin<>'N'

means that he went all-in somewhere, which could be the flop, turn or river as well as preflop.

I think you can be more specific here and use:

holdem_hand_player_statistics.enum_face_allin = 'P'

which says that he went all-in preflop. To answer your other question, the size of the second raise that hero made, as a percentage of the pot is in holdem_hand_player_detail as the value: val_p_raise_made_2_pct
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: new* stat: fold to push after 4bet ...

Postby js2002 » Wed Apr 08, 2009 9:22 am

kraada wrote:We're just looking at preflop pushes, right?

holdem_hand_player_statistics.enum_face_allin<>'N'

means that he went all-in somewhere, which could be the flop, turn or river as well as preflop.

I think you can be more specific here and use:

holdem_hand_player_statistics.enum_face_allin = 'P'

which says that he went all-in preflop. To answer your other question, the size of the second raise that hero made, as a percentage of the pot is in holdem_hand_player_detail as the value: val_p_raise_made_2_pct


So this is better?!

cnt_p_allin_def_action_fold
sum(if[holdem_hand_player_statistics.flg_p_first_raise AND
holdem_hand_player_statistics.flg_p_4bet AND
holdem_hand_player_statistics.enum_face_allin='P' AND
holdem_hand_player_statistics.enum_face_allin_action='F', 1, 0])

cnt_p_allin_def_opp
sum(if[holdem_hand_player_statistics.flg_p_first_raise AND
holdem_hand_player_statistics.flg_p_4bet AND
holdem_hand_player_statistics.enum_face_allin='P', 1, 0])

@ val_p_raise_made_2_pct : hmmm SB+BB+rfi+3bet 0,5+1+3,5+12 = 17BB Pot and villian raises(4bet) to 30BB, so val_p_raise_made_2_pct = 30/17 = 176% or 30/17+30=63%, which is correct? why is it the second raise?! because of the "2" in "val_p_raise_made_2_pct" right?!
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: new* stat: fold to push after 4bet ...

Postby kraada » Wed Apr 08, 2009 10:14 am

Yes, that looks better.

With the numbers you put together the 4-bet to 30 would be: .5+1+3.5+12+12 (you call his raise before you put in extra money) = 29BB pot, and he raised 18 more (30 - 12), so it's 18/29 or 62%.

The person who is 4betting has raised first in (by definition), so that was his first raise. The 4bet is then his second raise. In the database the first raise as a percentage of the pot is stored as val_p_raise_made_pct, and the second is stored as val_p_raise_made_2_pct, it's just how things are set up.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: new* stat: fold to push after 4bet ...

Postby js2002 » Wed Apr 08, 2009 12:58 pm

thx super infos, I ll make a cool stat with this soon ;)
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests