New Stat: CB Flop ip - Call Checkraise - Fold Turnbet

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

New Stat: CB Flop ip - Call Checkraise - Fold Turnbet

Postby hotrocket » Mon Apr 22, 2013 11:12 am

I tried to change the stat "Check Fold to T Bet After CBet & Call Flop" to see the same but in position.

cnt_t_bf_after_cb_call_flop_ip =

sum(if[cash_hand_player_statistics.flg_f_cbet and lookup_actions_f.action = 'XBC' and lookup_actions_t.action ='BF', 1, 0])

cnt_t_face_bet_after_cb_call_flop_ip = sum(if[cash_hand_player_statistics.flg_f_cbet and lookup_actions_f.action = 'XBC' and lookup_actions_t.action LIKE 'B_%', 1, 0])

I am not sure at all if it is correct?

Thank You!
hotrocket
 
Posts: 78
Joined: Thu Oct 11, 2012 2:14 am

Re: New Stat: CB Flop ip - Call Checkraise - Fold Turnbet

Postby kraada » Mon Apr 22, 2013 12:21 pm

That will not work - a player cannot check and later bet so 'XBC' is not a valid string. You want lookup_actions_f.action = 'BC'. Each action string is from that player's perspective, it's not the actions of all players on the entire street. So since you want this player to cbet and then call a raise, you want 'BC'. On the turn you just want his action to be 'F' as he's folding to a bet coming from the player out of position on him.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: New Stat: CB Flop ip - Call Checkraise - Fold Turnbet

Postby lewgill » Tue Apr 23, 2013 8:03 am

Would you be so kind to post the final code for this stat please, it is an interesting stat. Thanks
lewgill
 
Posts: 33
Joined: Thu Mar 21, 2013 7:44 am

Re: New Stat: CB Flop ip - Call Checkraise - Fold Turnbet

Postby kraada » Tue Apr 23, 2013 10:24 am

cnt_t_bf_after_cb_call_flop_ip = sum(if[cash_hand_player_statistics.flg_f_cbet and lookup_actions_f.action LIKE 'BC%' and lookup_actions_t.action ='BF', 1, 0])

cnt_t_face_bet_after_cb_call_flop_ip = sum(if[cash_hand_player_statistics.flg_f_cbet and lookup_actions_f.action LIKE 'BC%' and lookup_actions_t.action LIKE 'B_%', 1, 0])
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: New Stat: CB Flop ip - Call Checkraise - Fold Turnbet

Postby dave2085 » Thu Jun 21, 2018 9:36 am

I dont know why, but this Stat doesnt work for me: i get 0 results.

Code: Select all
sum(if[cash_hand_summary.cnt_players_f = 2
AND cash_hand_player_statistics.flg_f_cbet
AND char_length(cash_hand_summary.str_aggressors_p) = 2
and lookup_actions_f.action LIKE 'BC%' and lookup_actions_t.action ='BF', 1, 0])

divided by
Code: Select all
sum(if[cash_hand_summary.cnt_players_f = 2
AND cash_hand_player_statistics.flg_f_cbet
AND char_length(cash_hand_summary.str_aggressors_p) = 2
and lookup_actions_f.action LIKE 'BC%' and lookup_actions_t.action LIKE 'B_%', 1, 0])


this stat should show up, when its a SRP, the pfa cbets flop and calls the CHECKRAISE and folds to the bet on the Turn (preflop aggressor is n Position).

why does this stat give me no results?
dave2085
 
Posts: 186
Joined: Mon Jun 02, 2008 10:41 am

Re: New Stat: CB Flop ip - Call Checkraise - Fold Turnbet

Postby Flag_Hippo » Fri Jun 22, 2018 7:08 am

If a player is folding to a bet on the turn then they cannot bet themselves. Also for the opportunities column a player can still bet/call the flop when out of position and not folding the turn so you'd need to test for the position as well:

Code: Select all
sum(if[cash_hand_summary.cnt_players_f = 2
AND cash_hand_player_statistics.flg_f_cbet
AND char_length(cash_hand_summary.str_aggressors_p) = 2
and lookup_actions_f.action LIKE 'BC' and lookup_actions_t.action = 'F', 1, 0])

Code: Select all
sum(if[cash_hand_summary.cnt_players_f = 2
AND cash_hand_player_statistics.flg_f_cbet
AND char_length(cash_hand_summary.str_aggressors_p) = 2
and lookup_actions_f.action LIKE 'BC'
and cash_hand_player_statistics.flg_f_has_position
and cash_hand_player_statistics.amt_t_bet_facing > 0, 1, 0])
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: New Stat: CB Flop ip - Call Checkraise - Fold Turnbet

Postby dave2085 » Tue Jun 26, 2018 6:48 am

thanks for solving this for me! :)

i build a stat based on this stat:

now villain calls the turn IP and folds to a river bet.

here is the stat, maybe someone can check this?

I call it "Fold to R Bet (IP) After CBet & Call F and Call T (HU)"
Attachments
Fold to R Bet (IP) After CBet & Call F and Call T (HU).7z
(966 Bytes) Downloaded 52 times
dave2085
 
Posts: 186
Joined: Mon Jun 02, 2008 10:41 am

Re: New Stat: CB Flop ip - Call Checkraise - Fold Turnbet

Postby Flag_Hippo » Tue Jun 26, 2018 9:44 am

That works :)
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 14 guests

cron
highfalutin