PokerTracker

Hi,

I've created a delayed cbet stat which should only apply in heads-up and single raised pots and want to check it is correct. The numerator is:

sum(if[not(flg_p_3bet or flg_p_4bet)
and holdem_hand_player_statistics.flg_f_cbet_opp
and lookup_actions_f.action='X'
and flg_t_bet
and holdem_hand_summary.cnt_players_t=2, 1, 0])

The denominator is:

sum(if[not(flg_p_3bet or flg_p_4bet)
and holdem_hand_player_statistics.flg_f_cbet_opp
and lookup_actions_f.action='X'
and holdem_hand_player_detail.flg_t_open_opp
and holdem_hand_summary.cnt_players_t=2, 1, 0])

Grateful for any feedback.

Thanks

Steve

Steve,

That looks good to me

Thanks - your quick reply is greatly appreciated.

And its counterpart: Fold to delayed CBet

Is this OK? This was trickier for me. There doesn't seem to be a face_bet field so I used the amt_bet_facing field instead.

Numerator:

sum(if[holdem_hand_player_statistics.flg_p_face_raise and
not holdem_hand_player_statistics.flg_p_3bet_def_opp and
not holdem_hand_player_statistics.flg_p_4bet_def_opp and
not holdem_hand_player_statistics.flg_f_cbet_opp and
lookup_actions_f.action='X' and
(lookup_actions_t.action='XF' or lookup_actions_t.action='F') and
holdem_hand_summary.cnt_players_t=2, 1, 0])


Denominator:

sum(if[holdem_hand_player_statistics.flg_p_face_raise and
not holdem_hand_player_statistics.flg_p_3bet_def_opp and
not holdem_hand_player_statistics.flg_p_4bet_def_opp and
not holdem_hand_player_statistics.flg_f_cbet_opp and
lookup_actions_f.action='X' and
(holdem_hand_player_detail.amt_t_bet_facing >0) and
holdem_hand_summary.cnt_players_t=2, 1, 0])

Cheers

Steve

Just to clarify, if this stat is in the Holdem Cash Player Statistics section (which I assume it is due to the "SUM") then you are using "holdem_hand_player_statistics.flg_p_3bet" rather than just "flg_p_3bet", aren't you? (for all 4-bet and t-bet too)

Yes it's in the cash section. Since your post I've inserted the table name as well to be sure, but I'm 99.9% certain that PT3 picks up the cash table name anyway if it's unstated. But better to be safe.

If you enter it without the table name it will treat it as another column, which can cause problems.
Better to always use the full table.field names.

OK - thanks. And is the fold to delayed cbet stat OK?

Steve

It looks good to me.