Open fold statistic

[Joop59]

Hi! I have made a few custom statistics but I'm still a bit of a noob when it comes to that.

Recently I have been trying to make a statistic that would count how often a player would have the opportunity to open the pot, but folded. It doesn't seem to be working and I was wondering if you guys could help me with that. This is mostly because i couldn't find a way to measure how often SB would play a hand against the BB in MTTs if action was folded to them. Is there a statistic included in PT4 that would do that?

Statistic:
(fold / cnt_p_open_opp ) * 100

Collumns:
Fold
sum(if[lookup_actions_p.action = 'F', 1, 0])

the other is standard to PT4.


Also, I wonder if there would be a way to create a statistic using already existing statiscs, i.e. having "preflop limp" and "RFI", and adding them together in a single statistic? (Maybe that would give me an approximation to the statistic I want, except for the rare times when a player limps in an MTT. it doesn't matter if the statistic says how often the player folded, or limped+raised since I'd interpret these three to be the only mutually exclusive options).

Any help would be much appreciated! Thanks :)

[Flag_Hippo]

You are not testing for the preflop open opportunity in the fold column so that's just going to count any hand where the player folds with their first action regardless of what happens in front of them. If you add lookup_actions_p.action = 'F' to what is in the column expression for cnt_p_open_opp that will give you what you need. I'd also recommend keeping a similar naming convention for the custom column:

cnt_p_open_opp_fold

Code: Select all

sum(if[cash_hand_player_statistics.flg_p_open_opp and lookup_actions_p.action = 'F', 1, 0])

[Joop59]

Thanks a lot! That makes sense, it's working now.