Preflop open limp fold Sb NOAI

[G1PoQ]

Hello guys i'm trying to build Preflop open limp fold Sb NOAI

so here is my stat:

(LDB_cnt_p_limp_fold_3w_SB_NAI / LDB_cnt_p_limp_faceraise_3w_SB_NAI ) * 100

LDB_cnt_p_limp_fold_3w_SB_NAI:

sum(if[tourney_hand_player_statistics.flg_p_limp
AND tourney_hand_player_statistics.flg_p_open_opp
AND lookup_actions_p.action = 'CF'
AND tourney_hand_player_statistics.amt_p_raise_facing < tourney_hand_player_statistics.amt_p_effective_stack
AND tourney_hand_player_statistics.position = 9 , 1, 0])

LDB_cnt_p_limp_faceraise_3w_SB_NAI:

sum(if[tourney_hand_player_statistics.flg_p_limp
AND tourney_hand_player_statistics.flg_p_open_opp
AND tourney_hand_player_statistics.flg_p_face_raise
AND tourney_hand_player_statistics.amt_p_raise_facing < tourney_hand_player_statistics.amt_p_effective_stack
AND tourney_hand_player_statistics.position = 9 , 1, 0])

This stat show AI and NOAI situation i dont understand why this line is not working: tourney_hand_player_statistics.amt_p_raise_facing < tourney_hand_player_statistics.amt_p_effective_stack.

Can you help me?

Thank you

[Flag_Hippo]

That's the same issue as your other thread so use tourney_hand_player_statistics.amt_p_2bet_facing instead of tourney_hand_player_statistics.amt_p_raise_facing and add tourney_hand_player_statistics.amt_blind to that.

[G1PoQ]

Hello again, i forgot to mentionned it but i tried this and not working too, so to be more specific:

i have this stat with AI and NOAI:

Preflop limp fold SB:

(LDB_cnt_p_limp_fold_3w_SB / LDB_cnt_p_limp_faceraise_3w_SB ) * 100

LDB_cnt_p_limp_fold_3w_SB:
sum(if[tourney_hand_player_statistics.flg_p_open_opp
AND tourney_hand_player_statistics.flg_p_limp
AND tourney_hand_player_statistics.position = 9
AND lookup_actions_p.action = 'CF', 1, 0])

LDB_cnt_p_limp_faceraise_3w_SB:
sum(if[tourney_hand_player_statistics.flg_p_open_opp
AND tourney_hand_player_statistics.flg_p_limp
AND tourney_hand_player_statistics.position = 9
AND tourney_hand_player_statistics.flg_p_face_raise, 1, 0])

With this stat i have 911/1236=73.71%

So i try this to say its a NOAI situation:
(LDB_cnt_p_limp_fold_3w_SB_NAI / LDB_cnt_p_limp_faceraise_3w_SB_NAI ) * 100

LDB_cnt_p_limp_fold_3w_SB_NAI:
sum(if[tourney_hand_player_statistics.flg_p_limp
AND tourney_hand_player_statistics.flg_p_open_opp
AND lookup_actions_p.action = 'CF'
AND (tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) < tourney_hand_player_statistics.amt_p_effective_stack
AND tourney_hand_player_statistics.position = 9 , 1, 0])

LDB_cnt_p_limp_faceraise_3w_SB_NAI:
sum(if[tourney_hand_player_statistics.flg_p_limp
AND tourney_hand_player_statistics.flg_p_open_opp
AND tourney_hand_player_statistics.flg_p_face_raise
AND (tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) < tourney_hand_player_statistics.amt_p_effective_stack
AND tourney_hand_player_statistics.position = 9 , 1, 0])

and i have exactly the same number of occurence: 911/1236=73.71%

to finish for the AI situation i replace this:
AND (tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) < tourney_hand_player_statistics.amt_p_effective_stack
by:
AND (tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) >= tourney_hand_player_statistics.amt_p_effective_stack

and i have 0/0

and im sure thats this result is not good.

Can you see where the problem is?

I tried to rebuild cache but its not working

Thanks

[Flag_Hippo]

As the player is limping use tourney_blinds.amt_bb (the value of the BB) instead of tourney_hand_player_statistics.amt_blind (the amount posted by the player) and that should correct it.

[G1PoQ]

omg thank you its working now i knew it was something specific like that.

[Flag_Hippo]

Yes I didn't realise that change was also necessary originally but thanks for confirming that fixed it.