Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
akotzen24 wrote:So i noticed a huge leak in my pool with a tendency to float the flop and then float the turn. And also float turn then proceed to float river.
akotzen24 wrote:I just started trying to create my own stat for this and spent a few hours trying to create this stat and i just cannot get it to work.
akotzen24 wrote:So by float flop float turn I mean when opponent floated the flop and then bet the turn again when checked to. Here is what i have so far:
This is for the column sum( if[ flg_f_float AND flg_t_float , 1 , 0 ] )
sum(if[ (lookup_actions_p.action = 'C' OR lookup_actions_p.action = 'CC') AND cash_hand_player_statistics.flg_p_face_raise AND cash_hand_player_statistics.flg_f_bet AND char_length(cash_hand_summary.str_aggressors_p) = 2 AND ((cash_hand_summary.cnt_players > 2 AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int > cash_hand_player_statistics.position) OR (cash_hand_summary.cnt_players = 2 AND cash_hand_player_statistics.flg_f_has_position)) AND cash_hand_player_statistics.flg_t_bet AND NOT cash_hand_player_statistics.flg_f_face_raise, 1, 0])
akotzen24 wrote:and this is for the definition
(flg_f_float + flg_t_float) * 100
(a / b) * 100
(cnt_t_bet_after_float_flop / cnt_t_bet_after_float_flop_opp) * 100
akotzen24 wrote:Thank you so much for all your help. So in regards to this column :
sum(if[ (lookup_actions_p.action = 'C' OR lookup_actions_p.action = 'CC') AND cash_hand_player_statistics.flg_p_face_raise AND cash_hand_player_statistics.flg_f_bet AND char_length(cash_hand_summary.str_aggressors_p) = 2 AND ((cash_hand_summary.cnt_players > 2 AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int > cash_hand_player_statistics.position) OR (cash_hand_summary.cnt_players = 2 AND cash_hand_player_statistics.flg_f_has_position)) AND cash_hand_player_statistics.flg_t_bet AND NOT cash_hand_player_statistics.flg_f_face_raise, 1, 0])
Can you please walk me through what everything means here so i can try to learn and do it myself next time.
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 36 guests