Flag_Hippo wrote:
I cannot reproduce this. Have you rebuilt your custom cache?
The custom cache rebuild seems to have fixed the issue, thank you!
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
Flag_Hippo wrote:
I cannot reproduce this. Have you rebuilt your custom cache?
sum(if[char_length(cash_hand_summary.str_aggressors_p) = 3 and char_length(cash_hand_summary.str_actors_p) = 4 and not(substring(cash_hand_summary.str_actors_p from 1 for 1) != substring(cash_hand_summary.str_aggressors_p from 2 for 1)) and cash_hand_player_statistics.flg_p_3bet and substring(cash_hand_summary.str_aggressors_p from 3 for 1) = substring(cash_hand_summary.str_aggressors_p from 1 for 1) and substring(cash_hand_summary.str_actors_p from 3 for 1) = substring(cash_hand_summary.str_aggressors_p from 1 for 1) and not (cash_hand_player_statistics.enum_face_allin = 'P') and substring(cash_hand_summary.str_actors_p from 2 for 1) = substring(cash_hand_summary.str_aggressors_p from 2 for 1) and cash_hand_player_statistics.flg_f_saw, 1 ,0])
sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 3 and char_length(cash_hand_summary.str_actors_p) >= 4 and not(substring(cash_hand_summary.str_actors_p from 1 for 1) != substring(cash_hand_summary.str_aggressors_p from 2 for 1)) and cash_hand_player_statistics.flg_p_3bet and substring(cash_hand_summary.str_aggressors_p from 3 for 1) = substring(cash_hand_summary.str_aggressors_p from 1 for 1) and substring(cash_hand_summary.str_actors_p from 3 for 1) = substring(cash_hand_summary.str_aggressors_p from 1 for 1) and not (cash_hand_player_statistics.enum_face_allin = 'P') and substring(cash_hand_summary.str_actors_p from 2 for 1) = substring(cash_hand_summary.str_aggressors_p from 2 for 1), 1 ,0])
SirDehi wrote:char_length(cash_hand_summary.str_aggressors_p) = 3
SirDehi wrote:and not(substring(cash_hand_summary.str_actors_p from 1 for 1) != substring(cash_hand_summary.str_aggressors_p from 2 for 1)) and cash_hand_player_statistics.flg_p_3bet and substring(cash_hand_summary.str_aggressors_p from 3 for 1) = substring(cash_hand_summary.str_aggressors_p from 1 for 1) and substring(cash_hand_summary.str_actors_p from 3 for 1) = substring(cash_hand_summary.str_aggressors_p from 1 for 1) and not (cash_hand_player_statistics.enum_face_allin = 'P') and substring(cash_hand_summary.str_actors_p from 2 for 1) = substring(cash_hand_summary.str_aggressors_p from 2 for 1)
SirDehi wrote:No preflop Squeeze opportunities for the 3bettor
not cash_hand_player_statistics.flg_p_squeeze_opp
SirDehi wrote:The 4Bet raise is not an all-in
lookup_actions_f.action NOT LIKE ''
SirDehi wrote:The 4bet size is between 18 and 33 BB (don't know how to do this)
cash_hand_player_statistics.amt_p_4bet_facing + cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb between 18 and 33
sum(if[char_length(cash_hand_summary.str_aggressors_p) = 4 and char_length(cash_hand_summary.str_actors_p) = 4 and cash_hand_player_statistics.flg_p_3bet and not cash_hand_player_statistics.flg_p_squeeze_opp and substring(cash_hand_summary.str_aggressors_p from 2 for 1) = substring(cash_hand_summary.str_aggressors_p from 4 for 1) and cash_hand_player_statistics.flg_f_saw and lookup_actions_f.action NOT LIKE '' and cash_hand_player_statistics.amt_p_4bet_facing + cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb BETWEEN 18 and 33, 1, 0])
You only need to test for the 2bettor being the 4bettor which you are doing incorrectly as the first character of the aggressors string always starts with an 8 (the first bet preflop is the forced bet from the big blind).
cash_hand_player_statistics.amt_p_4bet_facing + cash_hand_player_statistics.amt_p_raise_made / cash_limit.amt_bb between 18 and 33
sum(if[char_length(cash_hand_summary.str_aggressors_p) = 4 and char_length(cash_hand_summary.str_actors_p) = 4 and cash_hand_player_statistics.flg_p_3bet and not cash_hand_player_statistics.flg_p_squeeze_opp and substring(cash_hand_summary.str_aggressors_p from 2 for 1) = substring(cash_hand_summary.str_aggressors_p from 4 for 1) and lookup_actions_f.action NOT LIKE '' and (cash_hand_player_statistics.amt_p_4bet_facing + cash_hand_player_statistics.amt_p_raise_made) / cash_limit.amt_bb BETWEEN 18 and 33 and cash_hand_player_statistics.flg_f_saw, 1, 0])
sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 4 and char_length(cash_hand_summary.str_actors_p) >= 4 and cash_hand_player_statistics.flg_p_3bet and not cash_hand_player_statistics.flg_p_squeeze_opp and substring(cash_hand_summary.str_aggressors_p from 2 for 1) = substring(cash_hand_summary.str_aggressors_p from 4 for 1) and lookup_actions_f.action NOT LIKE '' and (cash_hand_player_statistics.amt_p_4bet_facing + cash_hand_player_statistics.amt_p_raise_made) / cash_limit.amt_bb BETWEEN 18 and 33 and substring(cash_hand_summary.str_actors_p from 3 for 1) = substring(cash_hand_summary.str_aggressors_p from 2 for 1), 1, 0])
SirDehi wrote:Is this also true with the str_actors string?
SirDehi wrote:Doesn't this create a potential error where A + B / C where the stat firsts calculates B/C and then adds A ?
SirDehi wrote:but I can't figure out the opportunities column...
SirDehi wrote:So far I'm getting actions/opportunities = 1 with the tests I've done so far with this
sum(if[(cash_hand_player_statistics.flg_p_3bet_def_opp or cash_hand_player_statistics.flg_p_squeeze_def_opp) and cash_hand_player_statistics.amt_p_effective_stack / cash_limit.amt_bb <= 90 and cash_hand_player_statistics.flg_p_4bet and cash_hand_player_statistics.amt_p_raise_made >= 0.67 * cash_hand_player_statistics.amt_p_effective_stack, 1, 0])
sum(if[(cash_hand_player_statistics.flg_p_3bet_def_opp or cash_hand_player_statistics.flg_p_squeeze_def_opp) and cash_hand_player_statistics.amt_p_effective_stack / cash_limit.amt_bb <= 90, 1, 0])
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 24 guests