Validation of Fold to Min Raise SB vs BB in 3-Max Scenario

[TIGANCIC]

Hello,

I have created a custom statistic to calculate the Fold to Min Raise in the specific scenario where:

Hero is on the Small Blind (SB),
Big Blind (BB) makes a minimum raise,
Button (BTN) folds,
It's a 3-max game.
Here are the expressions I am using:

1. Column: fold_to_min_raise_sb_vs_bb
This counts cases where Hero folds to a min-raise from BB:

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 9
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.flg_p_face_raise
    AND tourney_hand_player_statistics.amt_p_raise_facing = tourney_blinds.amt_bb * 2
    AND lookup_actions_p.action = 'F',1, 0])


2. Column: opportunities_to_fold_to_min_raise_sb_vs_bb
This counts cases where Hero has an opportunity to face a min-raise from BB:

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 9
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.flg_p_face_raise
    AND tourney_hand_player_statistics.amt_p_raise_facing = tourney_blinds.amt_bb * 2,1, 0])


3. Final Stat: Fold to MR SB vs BB
This calculates the percentage of folds:

Code: Select all

(fold_to_min_raise_sb_vs_bb / opportunities_to_fold_to_min_raise_sb_vs_bb) * 100


Question: Are these expressions correct for calculating Fold to Min Raise in this specific scenario? Additionally, are there any improvements or best practices I should consider to ensure accuracy?

Thank you in advance for your help!

[Flag_Hippo]

Hero is on the Small Blind (SB),
Big Blind (BB) makes a minimum raise,
Button (BTN) folds,
It's a 3-max game.

This order of action doesn't make sense. What is SB doing? Are they limping? That would be:

BTN fold
SB limps
BB raise

lookup_actions_p.action = 'F'

If the SB is limp folding their preflop action would be 'CF' and not just 'F'.

AND tourney_hand_player_statistics.flg_p_face_raise
AND tourney_hand_player_statistics.amt_p_raise_facing = tourney_blinds.amt_bb * 2

I would recommend using (tourney_hand_player_statistics.amt_p_2bet_facing / tourney_blinds.amt_bb) = 1 instead. Note that raises faced are the amount the player needs to call so you need to account for what's already been invested by the player.

[TIGANCIC]

I apologize for the poorly formulated question. I need a statistic for folds to my min-raise when I am on the SB against the BB in a 3-max format. Is this the correct logic for building the statistic?
fold_to_min_raise_bb_vs_sb

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.flg_p_face_raise
    AND  ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb)  = 1
    AND lookup_actions_p.action LIKE 'F%', 1, 0])


opp_to_fold_to_min_raise_bb_vs_sb

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.flg_p_face_raise
    AND  ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb)  = 1, 1, 0])


Fold to Min Raise BB vs SB

Code: Select all

(fold_to_min_raise_bb_vs_sb / opp_to_fold_to_min_raise_bb_vs_sb) * 100


[Flag_Hippo]

I need a statistic for folds to my min-raise

There is nothing here that says you are on the SB. For that you need a 'vs Hero' custom statistic which we have covered previously.

((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) = 1

This would be equal to 2 if the BB was facing a minraise.

lookup_actions_p.action LIKE 'F%'

This works although it would normally be written as lookup_actions_p.action = 'F' since it's not possible to take any other actions after folding.

[TIGANCIC]

Thank you. Fixed it. I don’t want to use SELECT. If there are many of them, my HUD doesn’t work. Is there no other way except SELECT?

Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.flg_p_face_raise
    AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) = 2
    AND lookup_actions_p.action = 'F',
1, 0])


Code: Select all

sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 3
    AND tourney_hand_summary.str_actors_p LIKE '9%'
    AND tourney_hand_player_statistics.flg_p_face_raise
    AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) = 2,
1, 0])


Code: Select all

(fold_to_min_raise_bb_vs_sb / opp_to_fold_to_min_raise_bb_vs_sb) * 100


[Flag_Hippo]

I don’t want to use SELECT. If there are many of them, my HUD doesn’t work. Is there no other way except SELECT?

In PokerTracker 4 that can only be done using SELECT.