problem with VPIP

[Nidel]

Im triying to create a stat to show rival VPIP filter by stack size, im doing the followin:

Column "cnt_hands_BB_12_18": to count all the hands in BB between 12-18 blinds
sum(if[tourney_hand_player_statistics.id_hand > 0 AND lookup_positions.flg_bb AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 12 and 18, 1, 0])

Column "cnt_vpip_bb_12_18": to count vpip between 12-18 blinds
sum(if[tourney_hand_player_statistics.flg_blind_s = false AND tourney_hand_player_statistics.flg_blind_b AND tourney_hand_player_statistics.flg_vpip AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 12 and 18, 1, 0])

Stat "VPIP_BB_12_18": To show in the hud % vpip betwen 12-18 blinds
(cnt_vpip_bb_12_18 / (cnt_hands_BB_12_18 - cnt_walks)) * 100

The problem is the Hud show values biggers than 100%

What im doing bad? should I use legacy VPIP instead VPIP? whats the diference?

Than you guys!

[kraada]

You actually don't need cnt_walks for this calculation. If you get a walk your effective stack size is 0 (as you could not lose any money) so if you remove that from your denominator everything will work as you want. That is added because in the unfiltered version you don't want walks to count as VPIP opportunities (since you can't do anything) - but with the filter you've added they won't be included already, so what you're doing is in effect double counting them.

[Nidel]

thank you very much

so, for general stat i have to take care of walks, right?

VPIP BB
(cnt_vpip_bb / (cnt_hands_BB - cnt_walks)) * 100

[kraada]

Yeah but you don't need a custom stat for that - just use the regular VPIP stat and set the Position property to BB in the Item Properties area of the HUD (at the top right).

[Nidel]

I havent known that, TY!