VPIP with 70+ BB Stack

[boogeewoogee]

Hello!
I've been trying to create a VPIP stat for when the effective stack is greater than 70 big blinds, but after two days I still can't figure it out. Even ChatGPT couldn't help me.
Actually, it doesn't matter which stat or which stack depth – I just want to understand the logic of how to create any stat based on a specific effective stack size.
Could someone please help me with this?

Thanks in advance!

[Flag_Hippo]

This post shows how to create a custom statistic by stack size.

[boogeewoogee]

This post shows how to create a custom statistic by stack size.

Hi!
Thank you for your help so far.

I tried to build a stat for PFR at 50–100bb. I modified the column expressions as follows:

Changed from:
sum(if[tourney_hand_player_statistics.cnt_p_raise > 0, 1, 0])
To:
sum(if[tourney_hand_player_statistics.cnt_p_raise > 0
AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 50 AND 100, 1, 0])
And also changed the second column from:
sum(if[ lookup_actions_p.action LIKE '__%' OR
(lookup_actions_p.action LIKE '_' AND
(tourney_hand_player_statistics.amt_before > (tourney_blinds.amt_bb + tourney_hand_player_statistics.amt_ante)) AND
(tourney_hand_player_statistics.amt_p_raise_facing <
(tourney_hand_player_statistics.amt_before - (tourney_hand_player_statistics.amt_blind + tourney_hand_player_statistics.amt_ante))) AND
(tourney_hand_player_statistics.flg_p_open_opp OR
tourney_hand_player_statistics.cnt_p_face_limpers > 0 OR
tourney_hand_player_statistics.flg_p_3bet_opp OR
tourney_hand_player_statistics.flg_p_4bet_opp) ), 1, 0])
To:
sum(if[ lookup_actions_p.action LIKE '__%' OR
(lookup_actions_p.action LIKE '_' AND
(tourney_hand_player_statistics.amt_before > (tourney_blinds.amt_bb + tourney_hand_player_statistics.amt_ante)) AND
(tourney_hand_player_statistics.amt_p_raise_facing <
(tourney_hand_player_statistics.amt_before - (tourney_hand_player_statistics.amt_blind + tourney_hand_player_statistics.amt_ante))) AND
(tourney_hand_player_statistics.flg_p_open_opp OR
tourney_hand_player_statistics.cnt_p_face_limpers > 0 OR
tourney_hand_player_statistics.flg_p_3bet_opp OR
tourney_hand_player_statistics.flg_p_4bet_opp) )
AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 50 AND 100, 1, 0])

Everything validates correctly, and I saved the stat.
However, in the HUD or in Reports, the stat just shows a dash (—) and no value is displayed.

What could be the issue?
Thanks in advance for any guidance!

[boogeewoogee]

This post shows how to create a custom statistic by stack size.

I'm trying to build a custom stat that shows open raises where the raise size is between 2 and 2.5 big blinds.

I'm using this expression to filter for stack depth between 50 and 100 BB, and exclude all-ins:

tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb BETWEEN 50 AND 100
AND tourney_hand_player_statistics.amt_p_raise_made < (tourney_hand_player_statistics.amt_before * 0.8)

But now I’d like to add a condition that includes only open raises from 2 to 2.5 BB.

How can I do that correctly?

Thank you in advance!

[Flag_Hippo]

Everything validates correctly, and I saved the stat.
However, in the HUD or in Reports, the stat just shows a dash (—) and no value is displayed.

Rebuild your custom database cache via 'Database -> Database Management -> Rebuild Cache -> Custom Cache Rebuild'.

But now I’d like to add a condition that includes only open raises from 2 to 2.5 BB.

That would be:

Code: Select all

tourney_hand_player_statistics.flg_p_open_opp AND (tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) BETWEEN 2 AND 2.5