Cbet/3bet; Fold to XR; XF - all for 3bet and non-3bet pots

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Cbet/3bet; Fold to XR; XF - all for 3bet and non-3bet pots

Postby Hellos » Mon Jan 21, 2013 4:59 pm

I'm looking to incorporate the following stats in my HUD:

Cbet/3bet in non-3bet-pot
Cbet/3bet in 3bet pot
Fold to Check/Raise in non-3bet-pot
Fold to Check/Raise in 3bet pot
Check/Fold in non-3bet-pot
Check/Fold in 3bet pot

Is there an option to just add in 3bet pot and non 3bet pot, because most of the stats are available for the general case?
Hellos
 
Posts: 45
Joined: Thu Dec 09, 2010 1:17 pm

Re: Cbet/3bet; Fold to XR; XF - all for 3bet and non-3bet po

Postby Hellos » Mon Jan 21, 2013 6:27 pm

I'm interested in these for Flop, Turn and River each.

I've done the Fold to Flop Check/Raise in 3bet and non 3bet Pots. Could you please validate my solutions.

Fold Flop Check Raise % in 3Bet+ Pot:
Code: Select all
(cnt_p_3bet_f_face_xr_fold / cnt_p_3bet_f_face_xr) * 100


cnt_p_3bet_f_face_xr_fold:
Code: Select all
sum(if[(cash_hand_player_statistics.flg_p_3bet_def_opp OR cash_hand_player_statistics.flg_p_4bet_def_opp) AND substring(lookup_actions_f.action from 2 for 1) = 'F' AND flg_f_bet AND cash_hand_player_statistics.flg_f_face_raise AND ((substring(cash_hand_summary.str_aggressors_f from 2 for 1)::int > cash_hand_player_statistics.position) OR (cash_hand_summary.cnt_players = 2 AND cash_hand_player_statistics.flg_blind_s)), 1, 0])


cnt_p_3bet_f_face_xr:
Code: Select all
sum(if[(cash_hand_player_statistics.flg_p_3bet_def_opp OR cash_hand_player_statistics.flg_p_4bet_def_opp) AND flg_f_bet AND cash_hand_player_statistics.flg_f_face_raise AND ((substring(cash_hand_summary.str_aggressors_f from 2 for 1)::int > cash_hand_player_statistics.position) OR (cash_hand_summary.cnt_players = 2 AND cash_hand_player_statistics.flg_blind_s)), 1, 0])


Then non 3bet+ pot is simply:
Code: Select all
(cnt_f_face_xr_fold - cnt_p_3bet_f_face_xr_fold / cnt_f_face_xr - cnt_p_3bet_f_face_xr) * 100
Hellos
 
Posts: 45
Joined: Thu Dec 09, 2010 1:17 pm

Re: Cbet/3bet; Fold to XR; XF - all for 3bet and non-3bet po

Postby kraada » Mon Jan 21, 2013 6:45 pm

That looks good.

There isn't a general switch for 3bet/non-3bet pots but, as you've found, creating them out of our defaults really isn't that bad :)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Cbet/3bet; Fold to XR; XF - all for 3bet and non-3bet po

Postby Hellos » Mon Jan 21, 2013 6:58 pm

The only problem I have is that now in the popup it shows time times/opportunites correctly. However, the value up front is way off.

For example Fold to C/R is 6,398 (68/115) on Flop. How is this possible? It should be 59.

Edit: Found the mistake: I forgot some brackets in the formula. How does PT4 know the times/opportunities for custom stats though?

And for cbet/3bet and check/fold flop I am not sure how to do the stat. Would it be possible to show me for 3bet pots on the flop, please? :) Then I can derive the rest from there.
Last edited by Hellos on Mon Jan 21, 2013 7:05 pm, edited 1 time in total.
Hellos
 
Posts: 45
Joined: Thu Dec 09, 2010 1:17 pm

Re: Cbet/3bet; Fold to XR; XF - all for 3bet and non-3bet po

Postby kraada » Mon Jan 21, 2013 7:05 pm

That's a parentheses issue, I think. Try this instead:

((cnt_f_face_xr_fold - cnt_p_3bet_f_face_xr_fold) / (cnt_f_face_xr - cnt_p_3bet_f_face_xr)) * 100
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Cbet/3bet; Fold to XR; XF - all for 3bet and non-3bet po

Postby Hellos » Mon Jan 21, 2013 8:40 pm

I've also managed the check/fold stat which is basically a fold to F Bet OOP and then added the 3bet non 3bet pot thing.

However, for cbet/3bet I have no idea which stat to use as a basis. I'd appreciate some help.
Hellos
 
Posts: 45
Joined: Thu Dec 09, 2010 1:17 pm

Re: Cbet/3bet; Fold to XR; XF - all for 3bet and non-3bet po

Postby kraada » Tue Jan 22, 2013 9:13 am

Start with the built in CBet in 3Bet+ Pot and to add that you 3bet on the flop you'd just test for cash_hand_player_statistics.flg_f_3bet.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 26 guests

cron
highfalutin