Fold to Cbet Raise, stat to small

[js2002]

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.

[EinSIM]

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

[js2002]

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])

[EinSIM]

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

[js2002]

cbet AND face_raise not enough?

[kraada]

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.

[js2002]

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?

[kraada]

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

[js2002]

no, it works now

[js2002]

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" ?