PokerTracker

lookup_actions_f.action = 'BF'

cnt_f_cbet_fold_to_raise_SRP_HU:
sum(if[
lookup_actions_f.action = 'BF' AND
cash_hand_player_statistics.flg_f_cbet AND
cash_hand_summary.cnt_players_f=2
AND NOT(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet), 1, 0])

cnt_f_cbet_fold_to_raise_SRP_HU:
sum(if[
cash_hand_player_statistics.flg_f_cbet AND
cash_hand_summary.cnt_players_f=2
AND NOT(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet), 1, 0])

we have many people with only 5% at this stat. That cant be correct.

2nd stat is wrong, the trigger face raise is missing or something like
lookup_actions_f.action like 'B_%'

I see, tu!

(cnt_f_cbet_fold_to_raise / cnt_f_cbet_face_raise) * 100

We took the wrong denumerators.

This one is the correct build in:

cnt_f_cbet_face_raise
sum(if[cash_hand_player_statistics.flg_f_cbet AND cash_hand_player_statistics.flg_f_face_raise, 1, 0])

that denum is wrong, too ;-)
the preconditions are missing and should be the same as the first one :

Code: Select all

cash_hand_summary.cnt_players_f=2
AND NOT(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet

cbet AND face_raise not enough?

It should be but you probably want to exclude times the pot was 3bet or 4bet preflop if you're doing it in the numerator - otherwise you're not comparing apples to apples.

I do have "AND NOT(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet), 1, 0])" in numerator and denumerator, where is the problem?

Then it should be working fine. Can you find any cases that match the stat which should not?

no, it works now

new problem:

AND NOT(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet)

should filter for single raised pots (SRP), but Player can call a 3bet or 4bet+, so my filter is wrong?!
How do I fix it?

EDIT: AND NOT(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet_opp)

counts some cases where player 5bets :-(

maybe we should add a "last action preflop != call" ?