Raise Flop and fold

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Raise Flop and fold

Postby philip77 » Wed May 30, 2012 8:06 am

Hi,

I wanted to know if it is possible to build a stat which will count the percentage of time a player will raise the flop and then fold to a Turn or River bet or raise. I will not include the times the player fold to a 3bet on the flop.

Thanks
philip77
 
Posts: 245
Joined: Fri Nov 13, 2009 6:33 am

Re: Raise Flop and fold

Postby kraada » Wed May 30, 2012 1:06 pm

Yes it is, the key database fields you need to check are cash_hand_player_statistics.flg_t_fold and cash_hand_player_statistics.flg_r_fold - these are true when a player has folded on the respective streets.

So to create this stat for the numerator you'd want:
sum(if[cash_hand_player_statistics.cnt_f_raise > 0 and (cash_hand_player_statistics.flg_t_fold or cash_hand_player_statistics.flg_r_fold), 1, 0])

For the denominator:

sum(if[cash_hand_player_statistics.cnt_f_raise > 0 and (cash_hand_player_statistics.cnt_t_call > 0 or cash_hand_player_statistics.cnt_t_raise > 0 or cash_hand_player_statistics.flg_t_fold or cash_hand_player_statistics.flg_r_fold or cash_hand_player_statistics.cnt_r_call > 0 or cash_hand_player_statistics.cnt_r_raise > 0), 1, 0])

Here we just make sure you raised the flop and either called, raised or folded on the turn or the river - this way we are certain you had a chance to fold.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Raise Flop and fold

Postby philip77 » Wed May 30, 2012 1:40 pm

Thanks
philip77
 
Posts: 245
Joined: Fri Nov 13, 2009 6:33 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 21 guests

cron