Trying to make a few custom stats. Made a few but got stuck on these.
Checkfold River after Probe turn in HU
cnt_t_probe_r_checkfold
sum(if[cash_hand_summary.cnt_players_f = 2 and
cash_hand_player_statistics.amt_r_bet_facing > 0 AND
(lookup_actions_r.action SIMILAR TO '(F|XF)%') AND
cash_hand_player_statistics.flg_r_check and
cash_hand_player_statistics.flg_t_bet AND
lookup_actions_f.action LIKE 'X' AND
lookup_actions_p.action NOT LIKE '%R' AND
cash_hand_player_statistics.flg_p_face_raise AND
(cash_hand_player_statistics.val_p_raise_aggressor_pos < cash_hand_player_statistics.position OR
(cash_hand_summary.cnt_players = 2 and cash_hand_player_statistics.flg_blind_b)), 1, 0])
cnt_t_probe_r_open_opp
sum(if[cash_hand_summary.cnt_players_f = 2 and
cash_hand_player_statistics.flg_r_open_opp and
cash_hand_player_statistics.flg_t_bet AND
lookup_actions_f.action LIKE 'X' AND
lookup_actions_p.action NOT LIKE '%R' AND
cash_hand_player_statistics.flg_p_face_raise AND
(cash_hand_player_statistics.val_p_raise_aggressor_pos < cash_hand_player_statistics.position OR
(cash_hand_summary.cnt_players = 2 and cash_hand_player_statistics.flg_blind_b)), 1, 0])
I have this and get "Expression is valid" on both.
But when I make a Stats about it with:
cnt_t_probe_r_checkfold / cnt_t_probe_r_open_opp) * 100
I get "Invalid Value Expression"
What am I doing wrong?
Checkfold to float Turn after checkcall to float flop as 3better in HU
I know this is wrong but how should I make it?
cnt_f_float_XC_t_probe_CF_3bet
sum(if[(cash_hand_player_statistics.flg_p_3bet OR
cash_hand_player_statistics.flg_p_4bet) AND
lookup_actions_p.action LIKE '%R' AND
cash_hand_player_statistics.flg_f_open_opp AND
cash_hand_player_statistics.amt_f_bet_facing > 0 AND
substring(lookup_actions_f.action from 1 for 2) = 'XC' AND
cash_hand_player_statistics.flg_t_open_opp AND
cash_hand_player_statistics.amt_t_bet_facing > 0 AND
substring(lookup_actions_t.action from 1 for 2) = 'XF', 1, 0])
cnt_f_float_XC_t_probe_opp
sum(if[(cash_hand_player_statistics.flg_p_3bet OR
cash_hand_player_statistics.flg_p_4bet) AND
lookup_actions_p.action LIKE '%R' AND
cash_hand_player_statistics.flg_f_open_opp AND
cash_hand_player_statistics.flg_f_check AND
cash_hand_player_statistics.amt_f_bet_facing AND
cash_hand_player_statistics.flg_t_open_opp AND
cash_hand_player_statistics.flg_t_check AND
cash_hand_player_statistics.amt_t_bet_facing > 0, 1, 0])
Stats:
(cnt_f_float_XC_t_probe_CF_3bet / cnt_f_float_XC_t_probe_opp) * 100
WSD when cbet flop, check turn, bet river HU both for non3bet and 3bet
This one I really dont know how to make.
Can I do something just like this?
cnt_f_cbet_t_check_r_bet_wtsd_won
sum(if[cash_hand_player_statistics.flg_f_cbet AND
cash_hand_player_statistics.flg_f_cbet AND
cash_hand_player_statistics.flg_t_check AND
cash_hand_player_statistics.flg_r_bet AND
cash_hand_player_statistics.flg_showdown AND
cash_hand_player_statistics.flg_won_hand, 1, 0])
cnt_f_cbet_t_check_r_bet_wtsd
sum(if[cash_hand_player_statistics.flg_f_cbet AND
cash_hand_player_statistics.flg_f_cbet AND
cash_hand_player_statistics.flg_t_check AND
cash_hand_player_statistics.flg_r_bet AND
cash_hand_player_statistics.flg_showdown, 1, 0])
And for 3bet pots
cnt_f_cbet_t_check_r_bet_wtsd_won_3bet
sum(if[(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND
cash_hand_player_statistics.flg_f_cbet AND
cash_hand_player_statistics.flg_f_cbet AND
cash_hand_player_statistics.flg_t_check AND
cash_hand_player_statistics.flg_r_bet AND
cash_hand_player_statistics.flg_showdown AND
cash_hand_player_statistics.flg_won_hand, 1, 0])
cnt_f_cbet_t_check_r_bet_wtsd_3bet
sum(if[(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND
cash_hand_player_statistics.flg_f_cbet AND
cash_hand_player_statistics.flg_f_cbet AND
cash_hand_player_statistics.flg_t_check AND
cash_hand_player_statistics.flg_r_bet AND
cash_hand_player_statistics.flg_showdown, 1, 0])
Stats:
((cnt_f_cbet_t_check_r_bet_wtsd_won - cnt_f_cbet_t_check_r_bet_wtsd_won_3bet) / (cnt_f_cbet_t_check_r_bet_wtsd - cnt_f_cbet_t_check_r_bet_wtsd_3bet)) * 100
and for 3bet pots:
(cnt_f_cbet_t_check_r_bet_wtsd_won_3bet / cnt_f_cbet_t_check_r_bet_wtsd_3bet) * 100