fixed limit call flop raise turn stat

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

fixed limit call flop raise turn stat

Postby js2002 » Tue Apr 28, 2009 3:52 am

Hi,

is there sth like this stat? ---> call flop raise turn
call Bet flop raise turn is better or ?!

Does someone have it?
Why isnt it PT3 standard? Ist such a regular FL move.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: fixed limit call flop raise turn stat

Postby kraada » Tue Apr 28, 2009 9:06 am

It would be easy to count up how often someone calls the flop and raises the turn:

cnt_f_call_t_raise:
sum(if[holdem_hand_player_statistics.cnt_f_call > 0 and holdem_hand_player_statistics.cnt_t_raise > 0, 1, 0])

That will be equal to the number of times you both called the flop and raised the turn.

I'd be happy to show you how to make a percentage stat out of it, but I'm not sure what I'd use as the denominator though. I don't play fixed limit, what do you think would be most useful?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: fixed limit call flop raise turn stat

Postby js2002 » Tue Apr 28, 2009 9:26 am

No time 4 this, ask the PT3 lead. they should know that.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: fixed limit call flop raise turn stat

Postby js2002 » Tue Apr 28, 2009 12:20 pm

It should be more special like call Cbet Flop and Raise Cbet turn
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: fixed limit call flop raise turn stat

Postby kraada » Tue Apr 28, 2009 1:16 pm

In that case:

cnt_call_f_cbet_raise_t_cbet:

sum(if[holdem_hand_player_statistics.enum_f_cbet_action = 'C' and holdem_hand_player_statistics.enum_t_cbet_action = 'R', 1, 0])

Will count how often you call a flop cbet and raise a turn cbet.

cnt_call_f_cbet_face_t_cbet:

sum(if[holdem_hand_player_statistics.enum_f_cbet_action = 'C' and holdem_hand_player_statistics.flg_t_cbet_def_opp, 1, 0])

Put the former over the latter (the latter is how often you call a flop cbet and raise a turn cbet) and multiply by 100 to get a percentage.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: fixed limit call flop raise turn stat

Postby js2002 » Tue Apr 28, 2009 1:39 pm

kraada wrote:In that case:

cnt_call_f_cbet_raise_t_cbet:

sum(if[holdem_hand_player_statistics.enum_f_cbet_action = 'C' and holdem_hand_player_statistics.enum_t_cbet_action = 'R', 1, 0])

Will count how often you call a flop cbet and raise a turn cbet.

cnt_call_f_cbet_face_t_cbet:

sum(if[holdem_hand_player_statistics.enum_f_cbet_action = 'C' and holdem_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])
Dont u mean the TURN def opp?



Put the former over the latter (the latter is how often you call a flop cbet and raise a turn cbet) and multiply by 100 to get a percentage.


Numinator:
sum(if[holdem_hand_player_statistics.enum_f_cbet_action = 'C' and holdem_hand_player_statistics.enum_t_cbet_action = 'R', 1, 0])
______________________________________
Denominator:
sum(if[holdem_hand_player_statistics.enum_f_cbet_action = 'C' and holdem_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])

correct? little confused now because "the latter is how often you call a flop cbet and raise a turn cbet" the "former" is that!
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: fixed limit call flop raise turn stat

Postby kraada » Tue Apr 28, 2009 1:52 pm

Sorry, that should have read "the latter is how often you call a flop cbet and face a turn cbet. I also edited my typo (you are correct that should've been for the turn, not for the flop; you can see that my column has been edited now :)

I figured this stat makes the most sense as a percentage of the time that they raise a turn cbet given that they call a flop cbet and face a turn cbet.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: fixed limit call flop raise turn stat

Postby js2002 » Wed Apr 29, 2009 4:48 am

While showering I have the best ideas:

Couldn't we just take the 2 column of "raise turn cbet" and add sth like "AND call flop cbet"?

A definition question:
If somebody faces a turn cbet, he must have faces a flop cbet, correct? But it´s not clear how he answered the flop cbet, correct?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: fixed limit call flop raise turn stat

Postby WhiteRider » Wed Apr 29, 2009 4:56 am

js2002 wrote:Couldn't we just take the 2 column of "raise turn cbet" and add sth like "AND call flop cbet"?

Sounds reasonable..

A definition question:
If somebody faces a turn cbet, he must have faces a flop cbet, correct? But it´s not clear how he answered the flop cbet, correct?

Correct, correct.
You can see how they responded to the flop cbet using:
holdem_hand_player_statistics.enum_f_cbet_action
This is a single character string showing either F, C, R for fold, call, raise.
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