Custom Stats to review ....... various stats

[Onani]

Hello

I created these statistics yesterday, could someone tell me if they are well done?

What depends on whether the stat can be selected as IP or OOP in the HAS POSITION of Item Properties?


"Fold River after Call OVB TURN"
(cnt_t_overbet_def_action_call_River_Fold / cnt_t_overbet_def_action_call) * 100

cnt_t_overbet_def_action_call_River_Fold
sum(if[cash_hand_player_statistics.val_t_bet_facing_pct > 52.38 AND
(lookup_actions_t.action = 'C|XC')AND (lookup_actions_r.action = 'F|XF'), 1, 0])

cnt_t_overbet_def_action_call
sum(if[cash_hand_player_statistics.val_t_bet_facing_pct > 52.38 AND
(lookup_actions_t.action = 'C|XC'), 1, 0])


(This doesn't let me select IP/OOP )


W$SD Triple Barrel (B B B ) non 3bet POT

((cnt_r_cbet_and_wtsd_won - cnt_r_cbet_3bet_pot_and_wtsd_won) / (cnt_r_cbet_and_wtsd - cnt_r_cbet_3bet_pot_and_wtsd_won)) * 100

cnt_r_cbet_and_wtsd_won
sum(if[cash_hand_player_statistics.flg_r_cbet AND cash_hand_player_statistics.flg_showdown AND cash_hand_player_statistics.flg_won_hand AND NOT (lookup_actions_r.action='BC'), 1, 0])

cnt_r_cbet_3bet_pot_and_wtsd_won
sum(if[cash_hand_player_statistics.flg_r_cbet AND (cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND cash_hand_player_statistics.flg_showdown AND cash_hand_player_statistics.flg_won_hand AND NOT (lookup_actions_r.action='BC'), 1, 0])


cnt_r_cbet_and_wtsd

sum(if[cash_hand_player_statistics.flg_r_cbet AND cash_hand_player_statistics.flg_showdown AND NOT (lookup_actions_r.action='BC'), 1, 0])


cnt_r_cbet_3bet_pot_and_wtsd
sum(if[cash_hand_player_statistics.flg_r_cbet AND (cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND cash_hand_player_statistics.flg_showdown AND NOT (lookup_actions_r.action='BC'), 1, 0])


(This doesn't let me select IP/OOP )



W$SD Bet River after Delayed Turn
(cnt_t_delayed_cbet_r_bet_and_wtsd_won / cnt_t_delayed_cbet_r_bet_and_wtsd) * 100

cnt_t_delayed_cbet_r_bet_and_wtsd_won
sum(if[cash_hand_player_statistics.flg_t_bet AND lookup_actions_t.action = 'B' and cash_hand_player_statistics.flg_r_bet and cash_hand_player_statistics.flg_f_cbet_opp AND cash_hand_player_statistics.flg_showdown AND cash_hand_player_statistics.flg_won_hand AND NOT (lookup_actions_r.action='BC'), 1, 0])

cnt_t_delayed_cbet_r_bet_and_wtsd
sum(if[cash_hand_player_statistics.flg_t_bet AND lookup_actions_t.action = 'B' and cash_hand_player_statistics.flg_r_bet and cash_hand_player_statistics.flg_f_cbet_opp AND cash_hand_player_statistics.flg_showdown AND NOT (lookup_actions_r.action='BC'), 1, 0])

This lets me select IP/OOP

Fold River after Call Float turn
(cnt_t_float_def_action_call_and_Fold_River / cnt_t_float_def_action_call) * 100

cnt_t_float_def_action_call_and_Fold_River
sum(if[cash_hand_player_statistics.enum_t_float_action='C' and lookup_actions_r.action = 'F', 1, 0])

cnt_t_float_def_action_call
sum(if[cash_hand_player_statistics.enum_t_float_action='C', 1, 0])

I think this is incorrect because I get very strange values.

[Flag_Hippo]

What depends on whether the stat can be selected as IP or OOP in the HAS POSITION of Item Properties?

On the 'Details' tab of your custom statistic you need to set the relevant street as an assigned category.

"Fold River after Call OVB TURN"
(cnt_t_overbet_def_action_call_River_Fold / cnt_t_overbet_def_action_call) * 100

cnt_t_overbet_def_action_call_River_Fold
sum(if[cash_hand_player_statistics.val_t_bet_facing_pct > 52.38 AND
(lookup_actions_t.action = 'C|XC')AND (lookup_actions_r.action = 'F|XF'), 1, 0])

cnt_t_overbet_def_action_call
sum(if[cash_hand_player_statistics.val_t_bet_facing_pct > 52.38 AND
(lookup_actions_t.action = 'C|XC'), 1, 0])

You are testing for two different actions on the turn and river so you cannot use = since C|XC is not possible as a single action sequence. The correct test would be:

Code: Select all

lookup_actions_t.action SIMILAR TO '(C|XC)'

For more information on pattern matching in PostgreSQL see this guide.

W$SD Triple Barrel (B B B ) non 3bet POT

((cnt_r_cbet_and_wtsd_won - cnt_r_cbet_3bet_pot_and_wtsd_won) / (cnt_r_cbet_and_wtsd - cnt_r_cbet_3bet_pot_and_wtsd_won)) * 100

cnt_r_cbet_and_wtsd_won
sum(if[cash_hand_player_statistics.flg_r_cbet AND cash_hand_player_statistics.flg_showdown AND cash_hand_player_statistics.flg_won_hand AND NOT (lookup_actions_r.action='BC'), 1, 0])

cnt_r_cbet_3bet_pot_and_wtsd_won
sum(if[cash_hand_player_statistics.flg_r_cbet AND (cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND cash_hand_player_statistics.flg_showdown AND cash_hand_player_statistics.flg_won_hand AND NOT (lookup_actions_r.action='BC'), 1, 0])


cnt_r_cbet_and_wtsd

sum(if[cash_hand_player_statistics.flg_r_cbet AND cash_hand_player_statistics.flg_showdown AND NOT (lookup_actions_r.action='BC'), 1, 0])


cnt_r_cbet_3bet_pot_and_wtsd
sum(if[cash_hand_player_statistics.flg_r_cbet AND (cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND cash_hand_player_statistics.flg_showdown AND NOT (lookup_actions_r.action='BC'), 1, 0])

If you only want to count hands where the player just made a single bet on the river then it would be better to use lookup_actions_r.action = 'B' instead of NOT (lookup_actions_r.action='BC') since it is also possible for the player to win the hand at showdown by betting and raising when faced with a river 2bet.

W$SD Bet River after Delayed Turn
(cnt_t_delayed_cbet_r_bet_and_wtsd_won / cnt_t_delayed_cbet_r_bet_and_wtsd) * 100

cnt_t_delayed_cbet_r_bet_and_wtsd_won
sum(if[cash_hand_player_statistics.flg_t_bet AND lookup_actions_t.action = 'B' and cash_hand_player_statistics.flg_r_bet and cash_hand_player_statistics.flg_f_cbet_opp AND cash_hand_player_statistics.flg_showdown AND cash_hand_player_statistics.flg_won_hand AND NOT (lookup_actions_r.action='BC'), 1, 0])

cnt_t_delayed_cbet_r_bet_and_wtsd
sum(if[cash_hand_player_statistics.flg_t_bet AND lookup_actions_t.action = 'B' and cash_hand_player_statistics.flg_r_bet and cash_hand_player_statistics.flg_f_cbet_opp AND cash_hand_player_statistics.flg_showdown AND NOT (lookup_actions_r.action='BC'), 1, 0])

If you want delayed turn Cbets then there's nothing here that specifies the flop was checked through.

Fold River after Call Float turn
(cnt_t_float_def_action_call_and_Fold_River / cnt_t_float_def_action_call) * 100

cnt_t_float_def_action_call_and_Fold_River
sum(if[cash_hand_player_statistics.enum_t_float_action='C' and lookup_actions_r.action = 'F', 1, 0])

cnt_t_float_def_action_call
sum(if[cash_hand_player_statistics.enum_t_float_action='C', 1, 0])

I think this is incorrect because I get very strange values.

You haven't specified the player is facing a river bet in the opportunities column. Also if you get any strange values on new custom statistics then rebuild your custom database cache via 'Database -> Database Management -> Rebuild Cache -> Custom Cache Rebuild'.