CBet Turn Opp Question

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 Turn Opp Question

Postby js2002 » Thu Oct 08, 2009 5:47 am

Sry if I asked it before:

CBet Turn Opp: Is this always the PFA or is it possible that someone gained initiative at flop and then on turn has the opp to "Cbet this initiative" ?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: CBet Turn Opp Question

Postby WhiteRider » Thu Oct 08, 2009 7:19 am

You can only CBet the turn if you were the preflop aggressor and CBet the flop. You can't CBet if you gain the initiative on the flop.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: CBet Turn Opp Question

Postby marvin » Tue Oct 13, 2009 5:07 am

WHITERIDER, ARE YOU SURE? SO WE SAY:
PF: UTG is PFA, BUTTON call.
Flop: UTG check, BUTTON bet (he is doing float bet on flop).
Turn: CBET is not possible (why the last aggressor is not the PFA)...

and what about this:
PF: UTG is PFA, BUTTON call.
Flop: UTG check, BUTTON bet (he is doing float bet on flop), UTG makes a checkraise, button call.
Turn: CBET is possible (by the UTG, why also if he has not "cbetted" on flop, he has raised beiong last aggressor on the flop and PF. Im right?

if PT doesnt count CBET on first example, we can built our cnt_CBETnew_t in this way (where cbetting means bet after take the control at least on previous street in this way:
sum(if[ (lookup_actions_f.action = 'B' or lookup_actions_f.action = '%R') and lookup_actions_t.action = 'B%' , 1, 0])

the problem is that we cant use: holdem_hand_player_statistics.enum_t_cbet_action='F'. for compute how many times a player folds to a "CBETnew".
if players are only 2, WE CAN DO (FASTER AND SIMPLE):
CNT_FOLD_TO_CBET_NEW_TURN_hu:
sum(if[ (lookup_actions_f.action = '%C') and lookup_actions_t.action = 'F' or lookup_actions_t.action = 'XF' , 1, 0]) IN THIS WAY WE CAN BE SURE THAT ON FLOP HERO FACED AN AGGRESSOR (WHY HERO CLOSED HIS ACTION WITH CALL) AND ON TURN HE HAS FOLDED WITHOUT BETTING OR RAISE.
if players are 2 or more (YOU CAN ADD A CONDITION ABOUT NUMPLAYERS>2 FOR AVOIDING OVERLAPPING WITH HU CONDITION):
CNT_FOLD_TO_CBET_NEW_TURN_2_OR_MORE:

sum(if[ (lookup_actions_f.action = '%C') and ((holdem_hand_player_detail.val_f_raise_aggressor_pos = holdem_hand_player_detail.val_t_raise_aggressor_pos) or ( (holdem_hand_player_detail.val_f_BET_aggressor_pos = holdem_hand_player_detail.val_T_BET_aggressor_pos) AND NOT holdem_hand_player_statistics.flg_F_face_raise) and lookup_actions_t.action = 'F' or lookup_actions_t.action = 'XF' , 1, 0])


where ((holdem_hand_player_detail.val_f_raise_aggressor_pos = holdem_hand_player_detail.val_t_raise_aggressor_pos) is true when the aggressor is the last raiser on the flop,
and ( (holdem_hand_player_detail.val_f_BET_aggressor_pos = holdem_hand_player_detail.val_T_BET_aggressor_pos) AND NOT holdem_hand_player_statistics.flg_F_face_raise) is true if on the flop the action has seen only bettor without raiser, and we must be sure that the turn bettor is the same palyer
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: CBet Turn Opp Question

Postby kraada » Tue Oct 13, 2009 9:10 am

marvin wrote:WHITERIDER, ARE YOU SURE? SO WE SAY:
PF: UTG is PFA, BUTTON call.
Flop: UTG check, BUTTON bet (he is doing float bet on flop).
Turn: CBET is not possible (why the last aggressor is not the PFA)...


Yes, we're sure. In that case, no c-bet is possible.

marvin wrote:and what about this:
PF: UTG is PFA, BUTTON call.
Flop: UTG check, BUTTON bet (he is doing float bet on flop), UTG makes a checkraise, button call.
Turn: CBET is possible (by the UTG, why also if he has not "cbetted" on flop, he has raised beiong last aggressor on the flop and PF. Im right?


There is no cbet possible here. If the player who was the aggressor on the flop does not cbet, he cannot turn around and cbet again later.

marvin wrote:if PT doesnt count CBET on first example, we can built our cnt_CBETnew_t in this way (where cbetting means bet after take the control at least on previous street in this way:
sum(if[ (lookup_actions_f.action = 'B' or lookup_actions_f.action = '%R') and lookup_actions_t.action = 'B%' , 1, 0])


You can certainly build columns for each of these cases, and your started attempt looks good to me.

marvin wrote:the problem is that we cant use: holdem_hand_player_statistics.enum_t_cbet_action='F'. for compute how many times a player folds to a "CBETnew".
if players are only 2, WE CAN DO (FASTER AND SIMPLE):
CNT_FOLD_TO_CBET_NEW_TURN_hu:
sum(if[ (lookup_actions_f.action = '%C') and lookup_actions_t.action = 'F' or lookup_actions_t.action = 'XF' , 1, 0]) IN THIS WAY WE CAN BE SURE THAT ON FLOP HERO FACED AN AGGRESSOR (WHY HERO CLOSED HIS ACTION WITH CALL) AND ON TURN HE HAS FOLDED WITHOUT BETTING OR RAISE.
if players are 2 or more (YOU CAN ADD A CONDITION ABOUT NUMPLAYERS>2 FOR AVOIDING OVERLAPPING WITH HU CONDITION):
CNT_FOLD_TO_CBET_NEW_TURN_2_OR_MORE:

sum(if[ (lookup_actions_f.action = '%C') and ((holdem_hand_player_detail.val_f_raise_aggressor_pos = holdem_hand_player_detail.val_t_raise_aggressor_pos) or ( (holdem_hand_player_detail.val_f_BET_aggressor_pos = holdem_hand_player_detail.val_T_BET_aggressor_pos) AND NOT holdem_hand_player_statistics.flg_F_face_raise) and lookup_actions_t.action = 'F' or lookup_actions_t.action = 'XF' , 1, 0])


where ((holdem_hand_player_detail.val_f_raise_aggressor_pos = holdem_hand_player_detail.val_t_raise_aggressor_pos) is true when the aggressor is the last raiser on the flop,
and ( (holdem_hand_player_detail.val_f_BET_aggressor_pos = holdem_hand_player_detail.val_T_BET_aggressor_pos) AND NOT holdem_hand_player_statistics.flg_F_face_raise) is true if on the flop the action has seen only bettor without raiser, and we must be sure that the turn bettor is the same palyer


That all looks good at first glance.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: CBet Turn Opp Question

Postby marvin » Tue Oct 13, 2009 9:27 am

is possible cbet on turn in this case:

flop: utg is PFa and cbet on flop, button raise, utg call. NOW THE AGGRESSOR IS BUTTON, BUT UTG MADE CBET ON FLOP.
turn: UTG lead out betting to the raiser. button call.

the bet on the turn of utg what is? donkbet (why he bet out position to the raiser)? or cbet? or all two?
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: CBet Turn Opp Question

Postby kraada » Tue Oct 13, 2009 9:46 am

The UTG's bet on the turn is classed neither as a donkbet nor as a cbet. He can no longer cbet on the turn as he faced a flop raise, and it's not a donkbet as button wasn't the preflop aggressor. (It's a donkbet when your opponent would have had the chance to cbet, but you bet into him first.)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: CBet Turn Opp Question

Postby marvin » Tue Oct 13, 2009 10:03 am

ok.... TY :mrgreen:
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am


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

Who is online

Users browsing this forum: No registered users and 0 guests