by Masakik86 » Thu Jan 24, 2013 1:37 pm
sum(if[(cash_hand_player_statistics.flg_f_cbet_opp and not(cash_hand_player_statistics.flg_f_cbet)) AND ((cash_hand_player_statistics.cnt_f_call > 0 or cash_hand_player_statistics.cnt_f_raise > 0 or cash_hand_player_statistics.flg_f_fold)) AND not(cash_hand_player_statistics.flg_f_has_position) AND cash_hand_summary.cnt_players_f=2 , 1, 0]
Just let me try and understand what this means
cash_hand_player_statistics.flg_f_cbet_opp and not(cash_hand_player_statistics.flg_f_cbet)
sum of (Player had opportunity to f cbet and did not fcbet) and (folded on the flop and nothing else) and (did not have position) and (pot with only two players)
2nd column
sum(if[cash_hand_player_statistics.flg_f_cbet_opp AND not(cash_hand_player_statistics.flg_f_has_position) AND cash_hand_summary.cnt_players_f=2, 1, 0])
Sum of all the opportunities player had to cbet flop, and did not have position and was two players
stat = 1st column / 2nd column
Because I need to know exactly how many times he check/folds instead of cbets flop
DO NOT need to know how often he folds when he checks. (Fold to float bet)
For example if Player A:
Sum of first column is 5
He had 40 opp to Cbet
(5 / 40) x 100 = 12.5
So player A ends up check/folding the flop (OOP) 12.5% of the time.
What am I do wrong here? Hmm, also doesn't take into account that player has to face a bet when checked though hmmm. The problem with poker, the unknowns.
Last edited by
Masakik86 on Thu Jan 24, 2013 1:45 pm, edited 1 time in total.