Stat HU SB limp and fold vs allin preflop

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Stat HU SB limp and fold vs allin preflop

Postby lnsertCoin » Thu Jul 18, 2019 7:40 am

Hi,
i want to count how often in HU SB limps and fold vs BB allin preflop

when the SB has less chips than BB it works, but when SB has more chips than BB it don't work. What's wrong with this?

Expression:
(limp_fold_vs_AI / limp_fold_vs_AI_opp) * 100

column: limp_fold_vs_AI
sum(if[tourney_hand_summary.cnt_players = 2
AND tourney_hand_player_statistics.position = 9
AND tourney_hand_player_statistics.flg_p_limp
AND tourney_hand_player_statistics.flg_p_face_raise
AND tourney_hand_player_statistics.enum_face_allin_action='F', 1, 0])

column: limp_fold_vs_AI_opp
sum(if[tourney_hand_summary.cnt_players = 2
AND tourney_hand_player_statistics.position = 9
AND tourney_hand_player_statistics.flg_p_limp
AND tourney_hand_player_statistics.flg_p_face_raise
AND tourney_hand_player_statistics.enum_face_allin='P', 1, 0])
lnsertCoin
 
Posts: 7
Joined: Fri Apr 25, 2014 3:12 pm

Re: Stat HU SB limp and fold vs allin preflop

Postby lnsertCoin » Thu Jul 18, 2019 9:48 am

hi again, i made some changes to the columns and it looks like it's working now

column: limp_fold_vs_AI
sum(if[tourney_hand_summary.cnt_players = 2
AND tourney_hand_player_statistics.position = 9
AND tourney_hand_player_statistics.flg_p_open_opp
AND tourney_hand_player_statistics.flg_p_limp
AND tourney_hand_player_statistics.flg_p_face_raise
AND tourney_hand_player_statistics.enum_face_allin_action='F'
AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb >= 7), 1, 0])


column: limp_fold_vs_AI_opp
sum(if[tourney_hand_summary.cnt_players = 2
AND tourney_hand_player_statistics.position = 9
AND tourney_hand_player_statistics.flg_p_open_opp
AND tourney_hand_player_statistics.flg_p_limp
AND tourney_hand_player_statistics.flg_p_face_raise
AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb >= 7), 1, 0])
lnsertCoin
 
Posts: 7
Joined: Fri Apr 25, 2014 3:12 pm

Re: Stat HU SB limp and fold vs allin preflop

Postby lnsertCoin » Thu Jul 18, 2019 1:38 pm

after some more testing, i noticed that 2 post also don't work as intendet, still need help with that
sorry for confusion
lnsertCoin
 
Posts: 7
Joined: Fri Apr 25, 2014 3:12 pm


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 12 guests

cron
highfalutin