Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by dave2085 » Wed Jul 21, 2021 12:16 pm
This is my Code;
- Code: Select all
sum(if[tourney_hand_player_statistics.flg_blind_s and tourney_hand_player_statistics.cnt_p_face_limpers <= 2
and tourney_hand_summary.str_actors_p LIKE '0%'
AND tourney_hand_player_statistics.amt_f_bet_facing > 0
AND (lookup_actions_f.action SIMILAR TO '(F|XF)')
AND lookup_actions_p.action SIMILAR TO '(C|X)'
and not (tourney_hand_player_statistics.flg_p_first_raise), 1, 0])
problem i have is, that on the flop also BB could bet/lead and SB folds versus such a bet. How can I exclude this event?
So SB fold on the flop, only counts if the Button (firstin limper) bets the flop.Just to be clear the action is as follow;
Preflop: BU limp first-in. SB completes. BB checks.
Postflop: SB & BB checks, BU bets.
-
dave2085
-
- Posts: 186
- Joined: Mon Jun 02, 2008 10:41 am
by Flag_Hippo » Thu Jul 22, 2021 5:43 am
You've already used
tourney_hand_summary.str_actors_p LIKE '0%' to specify that the BTN was the first player to VPIP preflop so you can just use the flop actors string in exactly the same way to specify that the BTN was the first player to put chips in on the flop as well:
- Code: Select all
tourney_hand_summary.str_actors_f LIKE '0%'
-
Flag_Hippo
- Moderator
-
- Posts: 14505
- Joined: Tue Jan 31, 2012 7:50 am
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: alexwin, dNver and 18 guests