Issue with Total Fold Calculation (Using Standard PT4 Column

[TIGANCIC]

Hi,
I'm having an issue with my Total Fold statistic—it doesn’t seem to be working correctly. Here is the formula I’m using (all values are standard columns in PokerTracker 4):

Code: Select all

((cnt_f_fold + cnt_t_fold + cnt_r_fold) / (cnt_f_call + cnt_f_raise + cnt_t_call + cnt_t_raise + cnt_r_call + cnt_r_raise)) * 100


It should calculate the percentage of folds across all postflop streets, but something seems off. Maybe some fold situations are not being accounted for, or the denominator does not fully reflect all possible actions.
Can someone help verify if this calculation is correct? Should I add other factors to make this statistic more accurate?
Thanks in advance!

[Flag_Hippo]

Your current formula is ((folds) / (calls + raises)) when it should be ((folds) / (folds + calls + raises)).

[TIGANCIC]

I decided to modify the standard PokerTracker 4 columns because I didn’t like the way they were calculated. Here’s what I changed:

For cnt_f_fold, I now use:

Code: Select all

sum(if[tourney_hand_player_statistics.position = 8 
     and tourney_hand_summary.cnt_players = 2 
     and tourney_hand_summary.str_actors_p LIKE '%8' 
     and lookup_actions_f.action = 'XF', 1, 0])


For cnt_t_fold and cnt_r_fold, I made the same change but replaced lookup_actions_f.action = 'XF' with the respective turn and river versions.

For cnt_f_call, I use:

Code: Select all

sum(if[tourney_hand_player_statistics.position = 8 
     and tourney_hand_summary.cnt_players = 2 
     and tourney_hand_summary.str_actors_p LIKE '%8' 
     and lookup_actions_f.action = 'XC', 1, 0])


For cnt_t_call and cnt_r_call, I also changed lookup_actions_f.action = 'XC' accordingly.

For cnt_f_raise, I use:

Code: Select all

sum(if[tourney_hand_player_statistics.position = 8 
     and tourney_hand_summary.cnt_players = 2 
     and tourney_hand_summary.str_actors_p LIKE '%8' 
     and lookup_actions_f.action = 'XR', 1, 0])


And for cnt_t_raise and cnt_r_raise, I made the same change with lookup_actions_f.action = 'XR'.

The Total Fold statistic now seems to display correctly, but the Total Fold on the River does not show any data.
Did I set this up correctly? Am I missing something specific for river folds?

Thanks!

[Flag_Hippo]

I decided to modify the standard PokerTracker 4 columns because I didn’t like the way they were calculated. Here’s what I changed:

What you have here isn't total folds - it's specific to the BB when playing 2-handed,when the BB was the final player to VPIP preflop (call or raise) and only when faced with a flop/turn/river bet so if that's what you want it's fine other than lookup_actions_f.action = 'XR' which isn't going to count hands with further flop actions when the BB faces a flop 3bet from the SB. When the BB is check-folding or check-calling in a heads up hand they are closing the action but that isn't necessarily true when raising.

The Total Fold statistic now seems to display correctly, but the Total Fold on the River does not show any data.
Did I set this up correctly? Am I missing something specific for river folds?

Rebuild your custom database cache via 'Database -> Database Management -> Rebuild Cache -> Custom Cache Rebuild'. If that doesn't change anything please provide the relevant column expressions and value expression used for the statistic.