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" ?
Moderator: Moderators
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)...
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?
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])
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
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 0 guests