Raise 4bet Issue

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

Raise 4bet Issue

Postby Mr Tiger » Sat Mar 17, 2012 10:54 pm

Two stats. Denominator is the same. Numerators are:

1) sum(if[holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.enum_p_4bet_action='R', 1, 0])

2) sum(if[holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_p_4bet, 1, 0])

In the second case the value is greater, but for me they must be the same...
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: Raise 4bet Issue

Postby WhiteRider » Sun Mar 18, 2012 8:01 am

holdem_hand_player_statistics.enum_p_4bet_action='R'
..is true when you face a 4Bet (or higher) and raise.

holdem_hand_player_statistics.flg_p_4bet
..is true if you make a 4Bet (or higher).

You can make a 4Bet without facing a 4Bet (specifically if you raise when facing a 3Bet) so I would expect the second value to be higher.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Raise 4bet Issue

Postby Mr Tiger » Sun Mar 18, 2012 10:19 am

How can I make 4bet and 3bet in one hand without facing a 4bet?
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: Raise 4bet Issue

Postby kraada » Sun Mar 18, 2012 10:21 am

Add AND NOT(holdem_hand_player_statistics.flg_p_4bet_def_opp)

That eliminates the opportunity to defend against a 4bet (or higher).
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Raise 4bet Issue

Postby Mr Tiger » Sun Mar 18, 2012 2:27 pm

Adding this makes it zero in both cases.
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: Raise 4bet Issue

Postby WhiteRider » Sun Mar 18, 2012 4:13 pm

Please explain exactly what situation you're trying to count. You asked what the difference between your expressions is, and I explained, but without knowing what you're trying to count we can't help you build the "correct" expression.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Raise 4bet Issue

Postby Mr Tiger » Sun Mar 18, 2012 4:25 pm

I want to count times when a player raises after making a 3bet and facing a 4bet.

In the second case I can't make a 4bet not facing a 4bet because I've already made a 3bet. That's why, I think, both expressions must return the same value.
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: Raise 4bet Issue

Postby WhiteRider » Mon Mar 19, 2012 5:35 am

Sorry, you're quite right - I had skimmed over the fact that you were making a 3Bet. In that case the expressions should be equivalent.
I don't see any differences in my database, but I don't have a lot of 4bet hands - if you can identify a hand, or a set of hands, where these are different please attach it/them to a Support Ticket so that we can check out what that is.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 4 guests