VPIP in function of bbs in 3H

[alemlg93]

hi, i am trying to make my own HUD, and i have some doubts about the stats and the columns that i am making.

for example, i am testing the VPIP when the villane have >=16bbs and my columns are this:

number of hands with 16bbs or more:

cnt_hands_16bb: sum(if[tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb >= 16 AND tourney_hand_player_statistics.cnt_players = 3 AND tourney_hand_player_statistics.id_hand > 0, 1, 0])

number of walks with 16bbs or more:

cnt_walks_16bb: sum(if[tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb >= 16 AND tourney_hand_player_statistics.cnt_players = 3 AND lookup_actions_p.action = '', 1, 0])

VPIP_3H_16plus

sum(if[tourney_hand_player_statistics.cnt_players = 3
AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb >= 16 )
AND tourney_hand_player_statistics.flg_vpip, 1, 0])


and the stat of VPIP is:

(VPIP_B_3H_16 / (cnt_hands_16bb - cnt_walks_16bb)) * 100


My problem is, when the tournament starts, this stat is working, but when the villane have less than 16bbs, if he has more of 16bbs again, this stat doesnt work... can somebody help me what is my error?

Thanks and sorry for my english.

[Flag_Hippo]

Effective stack is the amount a player can potentially lose in a pot as of their first action in the hand and it is calculated per player therefore in multiway hands even if the player has an actual stack of more than 16BBs their effective stack might be lower depending on the actions in a hand and the stack sizes of the other players. Also when a player receives a walk their effective stack is zero since they cannot lose any chips so it's not possible to count the number of walks received with that column.