fold+call+raise donk bets != 100% @kraada

[js2002]

Hi,

[ img ]

as you can see it not 100% (the firste 3 rows have samplesize), my defs are:

cnt_f_donk_def_opp
sum(if[holdem_hand_player_detail.val_p_raise_aggressor_pos = -1 and holdem_hand_player_detail.amt_f_bet_facing > 0 AND NOT(holdem_hand_player_detail.flg_f_open_opp), 1, 0])

cnt_f_donk_def_opp_action_fold
sum(if[lookup_actions_p.action LIKE '%R' and holdem_hand_player_detail.amt_f_bet_facing > 0 and NOT(holdem_hand_player_detail.flg_f_open_opp) AND substring(lookup_actions_f.action from 1 for 1) = 'F', 1, 0])

cnt_f_donk_def_opp_action_call
sum(if[lookup_actions_p.action LIKE '%R' and holdem_hand_player_detail.amt_f_bet_facing > 0 and NOT(holdem_hand_player_detail.flg_f_open_opp) AND substring(lookup_actions_f.action from 1 for 1) = 'C', 1, 0])


cnt_f_donk_def_opp_action_raise
sum(if[lookup_actions_p.action LIKE '%R' and holdem_hand_player_detail.amt_f_bet_facing > 0 and NOT(holdem_hand_player_detail.flg_f_open_opp) AND substring(lookup_actions_f.action from 1 for 1) = 'R', 1, 0])

__________________________________________________
the opposite stats

cnt_f_donk
sum(if[ holdem_hand_player_statistics.flg_p_face_raise AND NOT(holdem_hand_player_statistics.flg_p_3bet OR holdem_hand_player_statistics.flg_p_4bet) AND holdem_hand_player_statistics.flg_f_bet AND NOT(holdem_hand_player_statistics.flg_f_cbet_opp) AND ((holdem_hand_summary.cnt_players > 2 AND holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position) OR (holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.flg_blind_b)), 1 , 0 ])

cnt_f_donk_opp
sum(if[ holdem_hand_player_statistics.flg_p_face_raise AND NOT(holdem_hand_player_statistics.flg_p_3bet OR holdem_hand_player_statistics.flg_p_4bet) AND (holdem_hand_player_detail.flg_f_open_opp) AND NOT(holdem_hand_player_statistics.flg_f_cbet_opp) AND ((holdem_hand_summary.cnt_players > 2 and holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position) or (holdem_hand_summary.cnt_players = 2 and holdem_hand_player_statistics.flg_blind_b)) , 1 , 0 ])

Could you please check why and check the opposite stats, too? thx

[kraada]

You've got an old version of cnt_f_donk_def_opp.

It should read:

sum(if[ lookup_actions_p.action LIKE '%R' and holdem_hand_player_detail.amt_f_bet_facing > 0 AND NOT(holdem_hand_player_detail.flg_f_open_opp), 1, 0])

The old version worked for a while until the database was changed (I think sometime last winter?) and now you need the newer version. Once you fix that and update the cache, everything should add up.

[js2002]

thx kraada! now it works.

Any other known stat errors?! Why do I have to find out on my own. No validation no information , why?!

[kraada]

Nothing immediately comes to mind. I'm in the process of writing another post to my HUD FAQ, so I'll make sure to mention this though (I thought I did quite a while back but obviously some people missed it).