Cbet F/T/R
Raise Cbet F/T/R
Float F/T/R
XR Float F/T/R
Probe T/R
Bet F/T/R
Donk F/T/R
So for instance if i make a cbet i should either be making a XR on the turn vs a float or another cbet on the turn and so on, went over and took all the default expression from those built-in stats in PT4 and use the AND and OR conditions but the stat is not validating for me, the expression gets really large and i dotn know if there´s an easy way to do it or even if it is possible to build...thoughts?
This is what i have thus far...
- Code: Select all
sum(if[tourney_hand_player_statistics.flg_won_hand and tourney_hand_player_statistics.flg_showdown AND (tourney_hand_player_statistics.flg_f_cbet OR tourney_hand_player_statistics.flg_t_cbet) AND (tourney_hand_player_statistics.flg_t_cbet OR tourney_hand_player_statistics.flg_r_cbet AND (tourney_hand_player_statistics.enum_f_cbet_action='R' OR tourney_hand_player_statistics.enum_t_cbet_action='R') AND (tourney_hand_player_statistics.enum_t_cbet_action='R' OR tourney_hand_player_statistics.enum_r_cbet_action='R') AND ((lookup_actions_p.action = 'C' OR lookup_actions_p.action = 'CC') AND tourney_hand_player_statistics.flg_p_face_raise AND tourney_hand_player_statistics.flg_f_bet AND char_length(tourney_hand_summary.str_aggressors_p) = 2 AND ((tourney_hand_summary.cnt_players > 2 AND substring(tourney_hand_summary.str_aggressors_p from 2 for 1)::int > tourney_hand_player_statistics.position) OR (tourney_hand_summary.cnt_players = 2 AND tourney_hand_player_statistics.flg_f_has_position)) OR tourney_hand_player_statistics.flg_t_float) AND (tourney_hand_player_statistics.flg_t_float OR tourney_hand_player_statistics.flg_r_float) AND (tourney_hand_player_statistics.flg_t_bet AND lookup_actions_f.action LIKE 'X' AND lookup_actions_p.action NOT LIKE '%R' AND tourney_hand_player_statistics.flg_p_face_raise AND ((tourney_hand_summary.cnt_players >= 3 and tourney_hand_player_statistics.val_p_raise_aggressor_pos < tourney_hand_player_statistics.position) OR (tourney_hand_summary.cnt_players = 2 and tourney_hand_player_statistics.flg_blind_b)) OR tourney_hand_player_statistics.flg_r_bet AND lookup_actions_t.action LIKE 'X' AND lookup_actions_p.action NOT LIKE '%R' AND tourney_hand_player_statistics.flg_p_face_raise AND tourney_hand_player_statistics.enum_f_cbet_action = 'C' AND ((tourney_hand_summary.cnt_players >= 3 and tourney_hand_player_statistics.val_p_raise_aggressor_pos < tourney_hand_player_statistics.position) OR (tourney_hand_summary.cnt_players = 2 and tourney_hand_player_statistics.flg_blind_b))) AND (tourney_hand_player_statistics.flg_f_bet OR tourney_hand_player_statistics.flg_t_bet) AND (tourney_hand_player_statistics.flg_t_bet OR tourney_hand_player_statistics.flg_r_bet) AND (tourney_hand_player_statistics.flg_p_face_raise AND NOT (tourney_hand_player_statistics.flg_p_3bet OR tourney_hand_player_statistics.flg_p_4bet) AND tourney_hand_player_statistics.flg_f_bet AND NOT (tourney_hand_player_statistics.flg_f_cbet_opp) AND ((tourney_hand_summary.cnt_players > 2 AND tourney_hand_player_statistics.val_p_raise_aggressor_pos < tourney_hand_player_statistics.position) or (tourney_hand_summary.cnt_players = 2 and tourney_hand_player_statistics.flg_blind_b)) OR tourney_hand_player_statistics.flg_t_donk) AND (tourney_hand_player_statistics.flg_t_donk OR tourney_hand_player_statistics.flg_r_donk), 1, 0])