New delayed Cbet Stat

[stevi3p]

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

[kraada]

Steve,

That looks good to me

[stevi3p]

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

[WhiteRider]

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)

[stevi3p]

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.

[WhiteRider]

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.

[stevi3p]

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

Steve

[kraada]

It looks good to me.