How to make a Fold vs Turn Limp Cbet custom stat?

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

How to make a Fold vs Turn Limp Cbet custom stat?

Postby weydahl » Mon Jun 18, 2018 1:58 pm

I've made two custom stats: Face_limpcbet and Fold_VsLimpCbet: and they're made as follows:

Face_limpcbet:
sum(if[lookup_positions.flg_bb AND NOT (tourney_hand_player_statistics.flg_p_face_raise) AND tourney_hand_player_statistics.amt_f_bet_facing > 0, 1, 0])

and

Fold_VsLimpCbet:
sum(if[lookup_positions.flg_bb AND NOT (tourney_hand_player_statistics.flg_p_face_raise) AND tourney_hand_player_statistics.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO 'XF'), 1, 0])

Now I want to make the same stats, but for the turn and I'm wondering if it will work if I switch out
tourney_hand_player_statistics.amt_f_bet_facing AND lookup_actions_f.action with
tourney_hand_player_statistics.amt_t_bet_facing AND lookup_actions_t.action?
Or do I have to do something else?

I'm not certain this will work bc maybe it in addition to registering the times villain folds vs a turn cbet,
it will ALSO register the times villain folds to a turn bet after flop action went check-check
AND/OR the action on flop went DonkBet-Call and then Check-Bet-Fold on turn.

I'd be super grateful if somebody could help me out here!
weydahl
 
Posts: 21
Joined: Mon Mar 29, 2010 8:15 am

Re: How to make a Fold vs Turn Limp Cbet custom stat?

Postby Flag_Hippo » Tue Jun 19, 2018 5:44 am

weydahl wrote:lookup_positions.flg_bb

You've not mentioned this in your stat name/post but as per your expression you want this for the BB only?
weydahl wrote:lookup_actions_f.action SIMILAR TO 'XF'

Also is the original statistic for heads up hands only? If it isn't then if the action is folded to the small blind who limps the big blind cannot check fold.
weydahl wrote:Now I want to make the same stats, but for the turn and I'm wondering if it will work if I switch out
tourney_hand_player_statistics.amt_f_bet_facing AND lookup_actions_f.action with
tourney_hand_player_statistics.amt_t_bet_facing AND lookup_actions_t.action?
Or do I have to do something else?

You shouldn't replace the code if you still want to record the flop action so just add the turn code to the existing flop code to create the turn statistic. Also if this isn't for heads up hands (or just 2 players postflop) and want to include multiway pots then you'd need to also test for the player making the turn bet being the same player who made the flop bet.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: How to make a Fold vs Turn Limp Cbet custom stat?

Postby weydahl » Tue Jun 19, 2018 6:37 am

Hi!
Thanks for replying!

I only want a stat for the BB as I'm playing HUSNGs.

I tried to just add lines, as you suggest, but it didn't register when my opponent folded to a turn cbet in a limped pot,
here's the code:

Columns:

cnt_t_face_limpcbet:
sum(if[lookup_positions.flg_bb
AND NOT (tourney_hand_player_statistics.flg_p_face_raise)
AND NOT (tourney_hand_player_statistics.flg_f_face_raise)
AND tourney_hand_player_statistics.amt_f_bet_facing > 0
AND (lookup_actions_f.action SIMILAR TO 'C')

AND NOT (tourney_hand_player_statistics.flg_t_face_raise)
AND tourney_hand_player_statistics.amt_t_bet_facing > 0, 1, 0])
--------------------------------------------------------------------------------


cnt_t_face_limpcbet_fold:
sum(if[lookup_positions.flg_bb
AND NOT (tourney_hand_player_statistics.flg_p_face_raise)
AND NOT (tourney_hand_player_statistics.flg_f_face_raise)
AND tourney_hand_player_statistics.amt_f_bet_facing > 0
AND (lookup_actions_f.action SIMILAR TO 'C')

AND NOT (tourney_hand_player_statistics.flg_t_face_raise)
AND tourney_hand_player_statistics.amt_t_bet_facing > 0
AND (lookup_actions_t.action SIMILAR TO 'XF') , 1, 0])
--------------------------------------------------------------------

Stats:
(cnt_t_face_limpcbet_fold / cnt_t_face_limpcbet ) * 100

Yeah, so I don't see what's wrong in my code, but it didn't register my opponents fold to turn limp cbet (after I had cbet flop as well).
weydahl
 
Posts: 21
Joined: Mon Mar 29, 2010 8:15 am

Re: How to make a Fold vs Turn Limp Cbet custom stat?

Postby Flag_Hippo » Tue Jun 19, 2018 10:59 am

weydahl wrote:lookup_actions_f.action SIMILAR TO 'C'

You will not get any results with this since the BB is check calling the flop so you need to use 'XC' instead.
weydahl wrote:AND NOT (tourney_hand_player_statistics.flg_t_face_raise)

I would also suggest removing this since it's not needed and if you include it your stat will not be counting opportunities to fold versus the turn bet whenever the subsequent action means the BB ends up facing a raise on the turn e.g. BB check raises the turn bet and then the SB 3bets.
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: How to make a Fold vs Turn Limp Cbet custom stat?

Postby weydahl » Tue Jun 19, 2018 11:22 am

Thank you so much! <3 <3
weydahl
 
Posts: 21
Joined: Mon Mar 29, 2010 8:15 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 29 guests

cron