I am trying to build stats for different board textures. There are probably many mistakes in it. Please help me out.
This one is supposed to be CBet% in a HU srp on a T-high rainbow board:
(cnt_f_cbet_thigh_r / cnt_f_cbet_opp_thigh_r) * 100
cnt_f_cbet_thigh_r
sum(if[cash_hand_player_statistics.flg_f_cbet AND cash_hand_summary.cnt_players = 2 and not cash_hand_player_statistics.flg_p_3bet and cash_hand_player_statistics.cnt_p_face_limpers = 0
and ((cash_hand_summary.card_1 % 13 <= 9) and (cash_hand_summary.card_2 % 13 <= 9) and (cash_hand_summary.card_3 % 13 <= 9)) and
(((cash_hand_summary.card_1 - 1) - ((cash_hand_summary.card_1 - 1) % 13)) / 4) <> (((cash_hand_summary.card_2 - 1) - ((cash_hand_summary.card_2 - 1) % 13)) / 4) <> (((cash_hand_summary.card_3 - 1) - ((cash_hand_summary.card_3 - 1) % 13)) / 4), 1, 0])
cnt_f_cbet_opp_thigh_r
sum(if[cash_hand_player_statistics.flg_f_cbet_opp AND cash_hand_summary.cnt_players = 2 and not cash_hand_player_statistics.flg_p_3bet and cash_hand_player_statistics.cnt_p_face_limpers = 0
and ((cash_hand_summary.card_1 % 13 <= 9) and (cash_hand_summary.card_2 % 13 <= 9) and (cash_hand_summary.card_3 % 13 <= 9)) and
(((cash_hand_summary.card_1 - 1) - ((cash_hand_summary.card_1 - 1) % 13)) / 4) <> (((cash_hand_summary.card_2 - 1) - ((cash_hand_summary.card_2 - 1) % 13)) / 4) <> (((cash_hand_summary.card_3 - 1) - ((cash_hand_summary.card_3 - 1) % 13)) / 4), 1, 0])
How can I add a rule for paired-ness, saying the board is paired or is not paired?
Are there options to say it´s a 3 connected board, like J97 or can you just do specific boards?
How to specifiy 2-Flush or 3-Flush (Monotone) Boards.
Thanks for helping with board structures, it seems complicated to me.
Edit: If only comparing first and second board card for suits it validates, how do I add the third one?
This validates:
sum(if[cash_hand_player_statistics.flg_f_cbet AND cash_hand_summary.cnt_players = 2 and not cash_hand_player_statistics.flg_p_3bet and cash_hand_player_statistics.cnt_p_face_limpers = 0
and ((cash_hand_summary.card_1 % 13 <= 9) and (cash_hand_summary.card_2 % 13 <= 9) and (cash_hand_summary.card_3 % 13 <= 9)) and (((cash_hand_summary.card_1 - 1) - ((cash_hand_summary.card_1 - 1) % 13)) / 4) <> (((cash_hand_summary.card_2 - 1) - ((cash_hand_summary.card_2 - 1) % 13)) / 4), 1, 0])
My guess for checking if all 3 board cards are rainbow is this, but it doesnt validate:
(((cash_hand_summary.card_1 - 1) - ((cash_hand_summary.card_1 - 1) % 13)) / 4) <> (((cash_hand_summary.card_2 - 1) - ((cash_hand_summary.card_2 - 1) % 13)) / 4) <> (((cash_hand_summary.card_3 - 1) - ((cash_hand_summary.card_3 - 1) % 13)) / 4)