check fold stat for 3 bet pots, check raise stat for 3 bet p

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Re: check fold stat for 3 bet pots, check raise stat for 3 b

Postby VCardKiller » Tue Sep 10, 2019 2:10 pm

I cant figure this out man.

I changed all columns for OTF, OTT & OTR to the strings you mentioned and still getting the same results. I dont know what to do and trying to sort this out over forums is extremely difficult for me to do because I have 0 idea what I am doing. Clearly there is a reason why the stat is not included by default as its that "difficult" to make. I ask you one more time, can you please just post what I need to input for OTT & OTR?

Otherwise just forget about. :roll:
VCardKiller
 
Posts: 58
Joined: Mon Feb 24, 2014 4:31 pm

Re: check fold stat for 3 bet pots, check raise stat for 3 b

Postby Flag_Hippo » Thu Sep 12, 2019 1:31 pm

Check Fold FTR 3BP Stats.zip
(1.89 KiB) Downloaded 364 times
Flag_Hippo
Moderator
 
Posts: 15049
Joined: Tue Jan 31, 2012 7:50 am

Re: check fold stat for 3 bet pots, check raise stat for 3 b

Postby VCardKiller » Thu Sep 12, 2019 6:13 pm

Flag_Hippo wrote:
Check Fold FTR 3BP Stats.zip


Ty so much mate and apologies for my stupidity. Im extremely happy! I uploaded the zip file onto the warehouse with the title "Check Fold vs Float Bet 3bet Pot" for anyone else to DL.

<3
VCardKiller
 
Posts: 58
Joined: Mon Feb 24, 2014 4:31 pm

Re: check fold stat for 3 bet pots, check raise stat for 3 b

Postby VCardKiller » Thu Sep 12, 2019 6:59 pm

I know I might be pushing my luck but could you also give me instructions for doing the fold to check raise in 3bet pots?

I see there is stats for fold to check raise FTR. What I was planning to do is duplicate all 3 and edit expressions used but Im not sure what to change. Expressions "(cnt_f_face_xr_fold / cnt_f_face_xr) * 100" are used. Below I listed details. If you could post what needs to be changed then I'll edit them myself and hopefully figure it out for FLOP, TURN & RIVER.

cnt_f_face_xr_fold

sum(if[substring(lookup_actions_f.action from 2 for 1) = 'F' AND cash_hand_player_statistics.flg_f_bet AND cash_hand_player_statistics.flg_f_face_raise AND ((cash_hand_summary.cnt_players > 2 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_f_face_xr

sum(if[cash_hand_player_statistics.flg_f_bet AND cash_hand_player_statistics.flg_f_face_raise AND ((cash_hand_summary.cnt_players > 2 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])
VCardKiller
 
Posts: 58
Joined: Mon Feb 24, 2014 4:31 pm

Re: check fold stat for 3 bet pots, check raise stat for 3 b

Postby Flag_Hippo » Fri Sep 13, 2019 9:13 am

VCardKiller wrote:I uploaded the zip file onto the warehouse with the title "Check Fold vs Float Bet 3bet Pot" for anyone else to DL.

I've removed the upload from the warehouse since the definition you posted does not match how I've defined and written those stats. You posted the definition as follows:
VCardKiller wrote:Amount of times a player 3bet preflop and check folded..

The statistics I created are not specific to the player who made the 3Bet. I've asked for clarification earlier in this thread and given different methods of writing the statistic because I've never been sure exactly what you wanted:
Flag_Hippo wrote:Is this as the preflop aggressor or caller? Or does it not matter?

VCardKiller wrote:It would be a both

At this stage I thought it was as both aggressor and caller but when you posted further code I asked for clarification:
Flag_Hippo wrote:When I asked this earlier and you said both did you mean in the same statistic or each separately?

Your reply was this which didn't really clarify anything for me:
VCardKiller wrote:At this stage the only stat I want is the "X/F" stat for OTF,OTT,OTR.

I then gave you different expressions as I still wasn't sure for but unfortunately you ran into some trouble getting the code to work so I made an assumption based on the information I had.
VCardKiller wrote:HM has it built in why cant PT4?

You never specified the names of the statistics so I checked Holdem Manager 2 and saw the following:

1) Flop Check-Fold - 3Bet Pot OOP (this is for both 3bettors and callers)

2) Fold Check-Fold to CB 3Bet Pot OOP (this is only for callers)

2) Skip Flop CB and Check-Fold - 3Bet Pot OOP (this is only for 3bettors)

Since you've never specified anything that would imply the latter two statistics I've assumed it was the first so please accept my apologies for getting it wrong. If you want the statistic for the 3bettor only then you can add cash_hand_player_statistics.flg_p_3bet back into each of the columns I created.
VCardKiller wrote:Amount of times a player 3bet preflop and check folded either OTF, OTT and OTR vs float bet.

Furthermore this definition you gave was the first time you've even mentioned a float and this would require another change. A float in PokerTracker 4 is when a player bets vs a missed CBet and the turn and river statistics I built do not take into account whether the player CBet the previous streets or not. If that's what you want then you would need to add cash_hand_player_statistics.flg_x_float_def_opp to the turn and river columns (where 'x' is the street the player skipped cbetting and faced a float bet).
VCardKiller wrote:I know I might be pushing my luck but could you also give me instructions for doing the fold to check raise in 3bet pots?

Who is the 3bettor? Who is the caller? Is it both? Is the bet before the check-raise a CBet, float bet or any bet? Is the statistic in Holdem Manager 2? If so please give the exact name. Sorry for all the questions but it's very important to me that I understand exactly what you want so that any advice/code I give will result in a statistic that is 100% accurate and is not counting things it shouldn't (and/or vice versa).
Flag_Hippo
Moderator
 
Posts: 15049
Joined: Tue Jan 31, 2012 7:50 am

Re: check fold stat for 3 bet pots, check raise stat for 3 b

Postby VCardKiller » Mon Sep 16, 2019 6:08 pm

What I wanted originally was when player 3bets preflop oop (co vs sb or bt vs bb for example) and how frequent 3better x/f OTF,OTT,OTR. Is that what you gave me? I am of also made the mistake of naming it wrong. I changed expression to what you mentioned anyways "cash_hand_player_statistics.flg_p_3bet". Expression works all good!

Who is the 3bettor? Who is the caller? Is it both? Is the bet before the check-raise a CBet, float bet or any bet? Is the statistic in Holdem Manager 2? If so please give the exact name. Sorry for all the questions but it's very important to me that I understand exactly what you want so that any advice/code I give will result in a statistic that is 100% accurate and is not counting things it shouldn't (and/or vice versa).


For 3bet scenarios I want a fold to check raise stat. So if player opens cutoff and button 3bets and cutoff calls. Cutoff checks OTF and button cbets and folds to a check raise. I want that exact statistic for OTF, OTT, OTR.

I hope I made myself clear. :)
VCardKiller
 
Posts: 58
Joined: Mon Feb 24, 2014 4:31 pm

Re: check fold stat for 3 bet pots, check raise stat for 3 b

Postby Flag_Hippo » Thu Sep 19, 2019 8:28 am

VCardKiller wrote:What I wanted originally was when player 3bets preflop oop (co vs sb or bt vs bb for example) and how frequent 3better x/f OTF,OTT,OTR. Is that what you gave me?

No. The statistics I attached count how often any player check-folds on a given street vs any bet in a 3Bet pot.
VCardKiller wrote:I changed expression to what you mentioned anyways "cash_hand_player_statistics.flg_p_3bet".

If you've made that change then the statistics will now be specific to the player who made the 3Bet but it still won't be counting only vs float bets (see my previous reply).
VCardKiller wrote:For 3bet scenarios I want a fold to check raise stat. So if player opens cutoff and button 3bets and cutoff calls. Cutoff checks OTF and button cbets and folds to a check raise. I want that exact statistic for OTF, OTT, OTR.

You can build a flop version of this statistic with the following columns (I've assumed you want this for all positions and not just CO vs BTN). I've also highlighted the characters you need to change to create turn and river versions:

cnt_f_cbet_face_xr_fold_3bp

sum(if[substring(lookup_actions_f.action from 2 for 1) = 'F' AND cash_hand_player_statistics.flg_f_cbet AND cash_hand_player_statistics.flg_f_face_raise AND ((cash_hand_summary.cnt_players > 2 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)) AND char_length(cash_hand_summary.str_aggressors_p) = 3, 1, 0])

cnt_f_cbet_face_xr_3bp

sum(if[cash_hand_player_statistics.flg_f_cbet AND cash_hand_player_statistics.flg_f_face_raise AND ((cash_hand_summary.cnt_players > 2 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)) AND char_length(cash_hand_summary.str_aggressors_p) = 3, 1, 0])
Flag_Hippo
Moderator
 
Posts: 15049
Joined: Tue Jan 31, 2012 7:50 am

Re: check fold stat for 3 bet pots, check raise stat for 3 b

Postby fedayn10 » Sun Sep 08, 2024 11:07 am

Hi, downloaded the file "Check Raise Flop 3BP.zip" Is it possible to add the stat directly to popup?
Attachments
popup.jpg
fedayn10
 
Posts: 2
Joined: Wed Jan 06, 2021 9:37 am

Re: check fold stat for 3 bet pots, check raise stat for 3 b

Postby Flag_Hippo » Mon Sep 09, 2024 5:55 am

fedayn10 wrote:Hi, downloaded the file "Check Raise Flop 3BP.zip" Is it possible to add the stat directly to popup?

After you have extracted and imported the statistic into PokerTracker 4 (File -> Import Statistic) you can add the statistic to the popup by clicking the '+' symbol to the right of the line you want to add it to.
Flag_Hippo
Moderator
 
Posts: 15049
Joined: Tue Jan 31, 2012 7:50 am

Previous

Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 12 guests

cron