PokerTracker

hi,

sorry if this is a dumb/obvious question; i'm new to this and trying to learn how to create conditional stats.

i'd like to create a custom stat that calculates how often a player:

raises preflop
is lead into on the flop and calls
folds to a turn barrel from the donkbettor

is it as simple as just going:

cnt_f_donk_def_opp_action_call and (cnt_t_bet_def_action_fold / cnt_t_bet_def_opp) * 100

No - you will need to build new columns to build this stat.

The best way will be to make a new version of the "Call F Donk Bet" stat and add in the extra criteria.

The "actions" column cnt_f_face_donk_call is defined as:

sum( if[lookup_actions_p.action LIKE '%R' AND holdem_hand_player_detail.amt_f_bet_facing>0 AND NOT holdem_hand_player_statistics.flg_f_check AND lookup_actions_f.action LIKE 'C%', 1, 0] )

To include a check for folding to a bet on the turn we can use:
holdem_hand_player_detail.amt_t_bet_facing > 0 AND lookup_actions_t.action = 'F'
(the player faced a bet and their first action was to fold.)

If you want to make sure that the bettor was the same player on the flop and turn you can use:
holdem_hand_player_detail.val_f_bet_aggressor_pos = holdem_hand_player_detail.val_t_bet_aggressor_pos

This makes the final actions column:

sum( if[lookup_actions_p.action LIKE '%R' AND holdem_hand_player_detail.amt_f_bet_facing>0 AND NOT holdem_hand_player_statistics.flg_f_check AND lookup_actions_f.action LIKE 'C%' AND holdem_hand_player_detail.val_f_bet_aggressor_pos = holdem_hand_player_detail.val_t_bet_aggressor_pos AND holdem_hand_player_detail.amt_t_bet_facing > 0 AND lookup_actions_t.action = 'F', 1, 0] )

The opportunities column is very similar, just missing the check for folding on the turn:

sum( if[lookup_actions_p.action LIKE '%R' AND holdem_hand_player_detail.amt_f_bet_facing>0 AND NOT holdem_hand_player_statistics.flg_f_check AND lookup_actions_f.action LIKE 'C%' AND holdem_hand_player_detail.val_f_bet_aggressor_pos = holdem_hand_player_detail.val_t_bet_aggressor_pos AND holdem_hand_player_detail.amt_t_bet_facing > 0, 1, 0] )

You can then build a stat to divide the former by the latter and multiply by 100 (as in most existing stats) to get the percentage.

See the Tutorial: Custom Reports and Statistics for how to build a stat from these expressions.

wow. thanks so much for taking the time to explain this in detail.

You're welcome.

quick followup question:

can you confirm that the above stat will include both 3bet and single-raised pots?
if so, would adding the following to both the action and opportunity count columns make the stat only calculate for single-raised pots:

and not(holdem_hand_player_statistics.flg_p_3bet)

Yes, that stat will include 3-bet and single-raised pots - any hand where the player was the the last preflop raiser.
Your addition is good, but you might want to include a check to ignore 4-bets too.

and not(holdem_hand_player_statistics.flg_p_3bet OR holdem_hand_player_statistics.flg_p_4bet)

Note: 4bets in PT3 include all 4-bets and higher.