Cbet in position

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

Cbet in position

Postby TopChan » Fri Aug 26, 2011 1:15 pm

How can I make cbet in position and out of position stat for every street? And fold\raise in position and out of position to fold cbet?
TopChan
 
Posts: 36
Joined: Wed May 14, 2008 3:00 pm

Re: Cbet in position

Postby kraada » Fri Aug 26, 2011 2:21 pm

Duplicate the columns and create in position and out of position versions by adding AND (holdem_hand_player_detail.flg_x_has_position) (where X is either f, t or r) for in position and AND NOT(holdem_hand_player_detail.flg_x_has_position) for out of position.

See the Tutorial: Using Custom Statistics and Reports for more on creating custom statistics.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Cbet in position

Postby TopChan » Fri Aug 26, 2011 3:47 pm

Thank you for quick reply.
TopChan
 
Posts: 36
Joined: Wed May 14, 2008 3:00 pm

Re: Cbet in position

Postby viju » Mon Jan 14, 2013 7:12 am

For some reason this stat doesn't count the situations, where my opponent check\raise the flop, and then bet the turn. Does it have to be like this?
Here's the columns and stat itself:

cnt_t_cbet_out_of_pos
sum(if[holdem_hand_player_statistics.flg_t_cbet AND NOT holdem_hand_player_detail.flg_t_has_position, 1, 0])

cnt_t_cbet_opp_out_of_pos
sum(if[holdem_hand_player_statistics.flg_t_cbet_opp AND NOT holdem_hand_player_detail.flg_t_has_position ,1, 0])

CBet T OOP
(cnt_t_cbet_out_of_pos / cnt_t_cbet_opp_out_of_pos) * 100
viju
 
Posts: 36
Joined: Fri Dec 30, 2011 5:13 am

Re: Cbet in position

Postby kraada » Mon Jan 14, 2013 10:01 am

A turn cbet is only when you have cbet the flop. If you've made a check/raise on the flop you can't have made a flop cbet. So you'll need to specify a flop check raise (with flg_f_check_raise) and just use flg_t_bet rather than flg_t_cbet.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Cbet in position

Postby viju » Mon Jan 14, 2013 10:34 am

Ok, thank you.
viju
 
Posts: 36
Joined: Fri Dec 30, 2011 5:13 am

Re: Cbet in position

Postby PokerFedor82 » Wed Mar 27, 2013 12:04 am

kraada wrote:Duplicate the columns and create in position and out of position versions by adding AND (holdem_hand_player_detail.flg_x_has_position) (where X is either f, t or r) for in position and AND NOT(holdem_hand_player_detail.flg_x_has_position) for out of position.



what about preflop in position/out of position?

holdem_hand_player_detail.flg_p_has_position doesn't work
PokerFedor82
 
Posts: 20
Joined: Sun May 20, 2012 11:43 pm

Re: Cbet in position

Postby kraada » Wed Mar 27, 2013 8:10 am

It's not possible to check in PT3 your position relative to the player who made a specific bet preflop. That's only possible in PT4.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 13 guests

cron