Give up and fold turn, and river Stat

[Masakik86]

Could you please make a "Give up and fold turn" and "Give up and fold river" in 3bet and non-3bet pots

Not a fold to float stat, but a stat for.

% of the time Opponent passed on opportunity to Cbet on turn when oop and folded to bet
% of the time Opponent passed on opportunity to Cbet on river when oop and folded to bet
Also,

% of time Opponent passed on cbetting on flop IP, and folded to a turn bet
% of time Opponent passed on cbetting on turn IP, and folded to a river bet

I'd make them myself but my PT4 statistic skills are very noob. If you can tell me how to make them I'll try and make them myself.

Thank you!

[Masakik86]

% of the time Opponent passed on opportunity to Cbet on flop when oop and folded to bet

As well, sorry!

[kraada]

These shouldn't be too hard to build.

Each street has its own cbet and cbet opportunity flag, so for example cash_hand_player_statistics.flg_t_cbet_opp is true when a player has a chance to cbet the turn and cash_hand_player_statistics.flg_t_cbet is true when a player did cbet. You can combine these to make sure you had a chance but did not actually cbet:

cash_hand_player_statistics.flg_t_cbet_opp and not(cash_hand_player_statistics.flg_t_cbet)

We also have cash_hand_player_statistics.flg_r_fold which is true if the player folded on the river (and there are _t_ and _f_ versions for the turn and flop respectively)

Finally, you'll want to be able to check that you faced a bet or raise - you can easily test that by seeing if:
cash_hand_player_statistics.cnt_r_call > 0 or cash_hand_player_statistics.cnt_r_raise > 0 or cash_hand_player_statistics.flg_r_fold

Because each time you face a bet or raise you must either call, raise or fold (and those exist for the turn and fold also).

[Masakik86]

So,

Make a new column when had opp to cbet but didn't and call it "skipped_t_cb_folded"

sum(if[(cash_hand_player_statistics.flg_t_cbet_opp and not(cash_hand_player_statistics.flg_t_cbet)) AND (cash_hand_player_statistics.cnt_r_call > 0 or cash_hand_player_statistics.cnt_r_raise > 0 or cash_hand_player_statistics.flg_r_fold), 1, 0])


If the above is true, how do you build the statistic?

just placing "skipped_t_cb_folded" ?

Thank you

[kraada]

That would actually be chance to fold after skipping the turn cbet - you'll want to build actual folds too, just replace (cash_hand_player_statistics.cnt_r_call > 0 or cash_hand_player_statistics.cnt_r_raise > 0 or cash_hand_player_statistics.flg_r_fold) with cash_hand_player_statistics.flg_r_fold by itself.

Then you have two columns - the opportunities and the times that you did it. Create your stat with the value expression (times / opportunities) * 100 and set it formatted to percent (you can fill in description, title, width, etc however you see fit) and then your stat is ready to use!

[Masakik86]

So, one column would read as: "gaveup"

sum(if[cash_hand_player_statistics.flg_t_cbet_opp and not(cash_hand_player_statistics.flg_t_cbet), 1, 0])

The other: "fold"

sum(if[cash_hand_player_statistics.flg_t_fold, 1,0])


Stat would be:

(fold / gaveup) * 100


That doesn't make sense to me. hmmm Or is it

first column

sum(if[(cash_hand_player_statistics.flg_t_cbet_opp and not(cash_hand_player_statistics.flg_t_cbet)) AND (cash_hand_player_statistics.flg_t_fold), 1, 0]


2nd column

sum(if[cash_hand_player_statistics.flg_t_cbet_opp, 1, 0])

Stat:

(1st column / 2nd) * 100


Does that look right for when hero is IP on the turn?

[kraada]

You were closer on your other attempt.

Two columns:

cnt_t_give_up_fold_river: sum(if[(cash_hand_player_statistics.flg_t_cbet_opp and not(cash_hand_player_statistics.flg_t_cbet)) AND cash_hand_player_statistics.flg_r_fold, 1, 0])

cnt_t_give_up_face_river_bet: sum(if[(cash_hand_player_statistics.flg_t_cbet_opp and not(cash_hand_player_statistics.flg_t_cbet)) AND (cash_hand_player_statistics.cnt_r_call > 0 or cash_hand_player_statistics.cnt_r_raise > 0 or cash_hand_player_statistics.flg_r_fold), 1, 0])

then in your stat use (cnt_t_give_up_fold_river / cnt_t_give_up_face_river_bet) * 100

[Masakik86]

Okay great, thank you.

That one you posted is for when

They don't cbet turn, and fold to a river bet?

If I were to make it so they dont cbet turn and fold to a turn bet


I'd do this:

Two columns:

cnt_t_give_up_fold_turn: sum(if[(cash_hand_player_statistics.flg_t_cbet_opp and not(cash_hand_player_statistics.flg_t_cbet)) AND cash_hand_player_statistics.flg_t_fold, 1, 0])

cnt_t_give_up_face_turn_bet: sum(if[(cash_hand_player_statistics.flg_t_cbet_opp and not(cash_hand_player_statistics.flg_t_cbet)) AND (cash_hand_player_statistics.cnt_t_call > 0 or cash_hand_player_statistics.cnt_t_raise > 0 or cash_hand_player_statistics.flg_t_fold), 1, 0])

then in your stat use (cnt_t_give_up_fold_turn / cnt_t_give_up_face_turn_bet) * 100

[Masakik86]

Oh shoot. How do I go about making it non-3bet pots?

[kraada]

To make it non 3bet pots add in AND char_length(cash_hand_summary.str_aggressors_p) <= 2 to both columns.

Otherwise, you've got it now it looks like