Issue with a Stat

[potamito]

Im trying to build Blinds Fold vs Steal meaning % of the time active player folded while being on either blind vs a LP steal, this is what i have for the action column...

Code: Select all

sum(if[lookup_actions_p.action = 'F' AND (tourney_hand_player_statistics.position = 8 OR tourney_hand_player_statistics.position = 9) and(tourney_hand_player_statistics.amt_p_2bet_facing < tourney_hand_player_statistics.amt_p_effective_stack ) and ( tourney_hand_summary.str_aggressors_p = '80' OR tourney_hand_summary.str_aggressors_p = '81') and char_length(tourney_hand_summary.str_aggressors_p) = 2 , 1, 0])

And when testing the expression im getting some calls and even 3bets even when using...

Code: Select all

tourney_hand_player_statistics.flg_blind_def_opp

Instead of defining each active player position...why is this?

[Flag_Hippo]

Im trying to build Blinds Fold vs Steal meaning % of the time active player folded while being on either blind vs a LP steal, this is what i have for the action column...

Code: Select all

sum(if[lookup_actions_p.action = 'F' AND (tourney_hand_player_statistics.position = 8 OR tourney_hand_player_statistics.position = 9) and(tourney_hand_player_statistics.amt_p_2bet_facing < tourney_hand_player_statistics.amt_p_effective_stack ) and ( tourney_hand_summary.str_aggressors_p = '80' OR tourney_hand_summary.str_aggressors_p = '81') and char_length(tourney_hand_summary.str_aggressors_p) = 2 , 1, 0])

If you are using char_length(tourney_hand_summary.str_aggressors_p) = 2 then you won't be counting all folds e.g. if LP steals, SB folds and BB 3bets then the SB fold wouldn't be accounted for.

And when testing the expression im getting some calls and even 3bets even when using...

Code: Select all

tourney_hand_player_statistics.flg_blind_def_opp

Instead of defining each active player position...why is this?

Are you still using char_length(tourney_hand_summary.str_aggressors_p) = 2? You shouldn't be getting any 3bet hands if you're testing with that. tourney_hand_player_statistics.flg_blind_def_opp is true if a player is in the blinds and is facing a steal attempt but it has nothing to do with the action they take versus that steal.

[WhiteRider]

There's a built-in stat 'Fold to LP Steal' - is that different to what you want?