Hello guys. I need help to build custom stats Preflop F to 3bet "allin" and "non allin" for effective stack sizes 35+bb , 20-35bb, 16-20bb, ...
I wrrote this code but is not working, something is wrong, stats are not displaying on my hud. Is needed for HUsng play SB vs. BB only
( A/B)*100
A
sum(if[
tourney_hand_player_statistics.position = 0
AND tourney_hand_player_statistics.flg_p_first_raise
AND tourney_hand_player_statistics.flg_p_3bet_def_opp
AND tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb between 20 and 35
AND tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb < 6
AND EXISTS (select 1 from tourney_hand_player_statistics hero where hero.id_hand = tourney_hand_player_statistics.id_hand and hero.flg_hero and hero.position = 0)
AND tourney_hand_player_statistics.enum_p_3bet_action='F'
, 1, 0])
B
sum(if[
tourney_hand_player_statistics.position = 0
AND tourney_hand_player_statistics.flg_p_first_raise
AND tourney_hand_player_statistics.flg_p_3bet_def_opp
AND tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb between 20 and 35
AND tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb < 6
AND EXISTS (select 1 from tourney_hand_player_statistics hero where hero.id_hand = tourney_hand_player_statistics.id_hand and hero.flg_hero and hero.position = 0)
, 1, 0])
Can someone help me to solve this?
