cold4bet%

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

cold4bet%

Postby js2002 » Tue Sep 14, 2010 4:29 am

Hi,

planning a cold4bet stat.

How do I filter: "not 2bet"?


NOT(flg_p_first_raise) AND 4bet+ ok?


EDIT: adding NOT(3bet) will correctly insert the cold5bet huh?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: cold4bet%

Postby kraada » Tue Sep 14, 2010 9:07 am

The problem is we lack a "facing 2-bet" database flag here. As such with the setup you have you could call the initial raise cold, and after there's a 3-bet later you come back and 4-bet. I'm not sure how we can get out of that (and just eliminating cold call is no good or we eliminate situations to 4-bet cold in the opportunities column, and we can always call "cold" from the SB and have the BB reraise so that doesn't help with the original problem anyway . . .)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: cold4bet%

Postby WhiteRider » Tue Sep 14, 2010 9:12 am

You can use "holdem_hand_player_statistics.flg_p_3bet_opp" to see if you face a 2-bet.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: cold4bet%

Postby js2002 » Tue Sep 14, 2010 9:47 am

I think u both misunderstand now:

my def:

UTG 2bets
x folds
MP 3bets
Hero BU has no money in and COLD4BETS now.

so face 3bet = true and NOT(flg_p_first_raise) = true

dont u think this 2 are enough for making the cold4bet stat`?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: cold4bet%

Postby kraada » Tue Sep 14, 2010 12:28 pm

Say we're UTG.

We limp. UTG+1 raises, BTN 3-bets.

face 3-bet = true and face_p_first_raise = false.

We need to ignore limping situations.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: cold4bet%

Postby js2002 » Tue Sep 14, 2010 1:13 pm

I do because, I use a limp/reraise stat too.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: cold4bet%

Postby matze_widi » Fri Jul 15, 2011 7:20 am

Is there a cold4bet stats already available??
doesnt seem to find any of that in the statistic section.
matze_widi
 
Posts: 50
Joined: Sun Aug 30, 2009 2:42 pm

Re: cold4bet%

Postby js2002 » Fri Jul 15, 2011 7:51 am

matze_widi wrote:Is there a cold4bet stats already available??
doesnt seem to find any of that in the statistic section.


sum(if[holdem_hand_player_statistics.enum_p_3bet_action='R' AND NOT(holdem_hand_player_statistics.flg_p_first_raise), 1, 0])

sum(if[holdem_hand_player_statistics.flg_p_3bet_def_opp AND NOT(holdem_hand_player_statistics.flg_p_first_raise), 1, 0])

I think the mentioned limping spot is not caught here.
But well its not perfect so I wait for pt4 to make it perfect :)

@kraada: wie call a raise, sb 3bets and we 4bet is also counted huh? thats a mess...
Last edited by js2002 on Fri Jul 15, 2011 7:54 am, edited 1 time in total.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: cold4bet%

Postby matze_widi » Fri Jul 15, 2011 7:54 am

js2002 wrote:
matze_widi wrote:Is there a cold4bet stats already available??
doesnt seem to find any of that in the statistic section.


sum(if[holdem_hand_player_statistics.enum_p_3bet_action='R' AND NOT(holdem_hand_player_statistics.flg_p_first_raise), 1, 0])

sum(if[holdem_hand_player_statistics.flg_p_3bet_def_opp AND NOT(holdem_hand_player_statistics.flg_p_first_raise), 1, 0])



havent done any of that i´m really clueless how to use them.
any help is apprecitated
matze_widi
 
Posts: 50
Joined: Sun Aug 30, 2009 2:42 pm

Re: cold4bet%

Postby js2002 » Fri Jul 15, 2011 7:55 am

forget this stat, it has errors i guess.
wait 4 pt4 or think and make ur own. I think kraada will help us :)
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Next

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

Who is online

Users browsing this forum: No registered users and 0 guests