How to detect a cold-called 3bet?

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

How to detect a cold-called 3bet?

Postby PeteX » Mon Sep 22, 2008 4:02 pm

I'm trying to find all hands where I have cold-called a 3bet preflop.

I have used these query conditions: enum_p_3bet_action='C' AND flg_p_ccall

But this doesn't give me the results that I want, for example with this kind of PF action:
1. UTG Raise
2. UTG+1 Folds
3. UTG+2 Calls
4. I Call (yes, so I do cold-call one raise)
5. (several folds)
6. SB 3-bets (this would be a squeeze, I guess)
7. UTG calls
8. I call (yes, I call a 3-bet but this is not my FIRST action)

So, this is not a hand that I would like to match my query; I would like to find only such hands where there has been a raise and a 3-bet before me and then I cold-call the 3-bet.

So this is what I would like to find:
1. UTG Raises
2. UTG+1 3-bets
3. I call
.... nevermind what happens afterwards

What more do I need to add to my query?
PeteX
 
Posts: 194
Joined: Sat Apr 05, 2008 9:12 am

Re: How to detect a cold-called 3bet?

Postby PeteX » Mon Sep 22, 2008 4:22 pm

Answering myself:

Would this work:
flg_p_ccall AND ((enum_p_3bet_action='C' AND cnt_p_call=1) OR (enum_p_4bet_action='C' AND enum_p_3bet_action='C' AND cnt_p_call=2))

So,
a) I always cold-call (so there was a raise before me)
then I either
b) called a 3-bet and that was my ONLY call preflop so it had to be my first action
OR
c) called a 3-bet and called a 4-bet and those were my 2 calls preflop -> 3-bet had to happen before 4-bet so it was my first action.

Can anyone think of an action sequence where this wouldn't work?
PeteX
 
Posts: 194
Joined: Sat Apr 05, 2008 9:12 am

Re: How to detect a cold-called 3bet?

Postby WhiteRider » Mon Sep 22, 2008 4:38 pm

You could check for (cold called) AND NOT (holdem_hand_player_statistics.flg_p_3bet_opp) which would mean that you didn't face a 2-bet, so you must have cold called a 3-bet or higher.
That might do it..
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 0 guests