2 custom stats

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

2 custom stats

Postby mager » Mon Jun 14, 2010 8:41 am

Hey.
I want to make "PF 3bet" and "fold to PF 3bet" more accurate. So i want to do something like "PF 3bet(not include "raise vs steal att") and "Fold to PF 3bet(not include "fold steal to blind raise").
Is that possible? If so, how ?

thanks.
mager
 
Posts: 180
Joined: Thu Sep 17, 2009 7:04 pm

Re: 2 custom stats

Postby kraada » Mon Jun 14, 2010 9:16 am

To build 3-bet NvBS (not vs blind steal), you want to build and use these two columns:

cnt_p_3bet_nvbs: sum(if[not(holdem_hand_player_statistics.flg_blind_def_opp) and holdem_hand_player_statistics.flg_p_3bet, 1, 0])
cnt_p_3bet_nvbs_opp: sum(if[not(holdem_hand_player_statistics.flg_blind_def_opp) and holdem_hand_player_statistics.flg_p_3bet_opp, 1, 0])

In the stat put the former over the latter, multiply by 100 and you're good (don't forget to fill out the Format tab).

One thought about the fold to pf 3-bet though, before I give you those columns would you also want to limit to only times that you made the open raise?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: 2 custom stats

Postby mager » Mon Jun 14, 2010 9:47 am

i don't understand what you mean by times i made the open raise. Maybe you meant times i made the 3bet?
Here is what i want:
BB
SB
UTG+1 raise
CO reraise(ie pf3bet)

UTG+1 fold(ie fold to pf 3bet).

I want this stat but do not include "fold steal to blind raise" which is also "fold to pf 3bet" but in special opportunity(which i want to reduce in order to have more accurate stat).

If i didn't understand something correctly let me know...
mager
 
Posts: 180
Joined: Thu Sep 17, 2009 7:04 pm

Re: 2 custom stats

Postby kraada » Mon Jun 14, 2010 11:16 am

Do you want the BB and SB in that case to also have counted as folding to a 3bet there? That's the question. The default fold to PF 3bet counts how often you fold to any 3bet regardless of who made the initial raise. So normally if you're in the BB and UTG opens an the BTN 3bets and you fold, that's a fold to 3bet for you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: 2 custom stats

Postby mager » Mon Jun 14, 2010 12:29 pm

Oh now i understand.
I want it to only count as "fold to PF 3bet" for the raiser(and people who call that raise if that's possible). But not for limpers or blinds.

If you can't make it count as "fold to PF 3bet" for raiser caller but not for limpers, make it to not count for both(if i have to choose whether to count it or not for both). (Tell me who it count for).
mager
 
Posts: 180
Joined: Thu Sep 17, 2009 7:04 pm

Re: 2 custom stats

Postby kraada » Mon Jun 14, 2010 1:53 pm

You anticipated what my next questions would be very well :)

You are correct that there's no easy way to distinguish between people who call a raise before the 3bet and people who call the 3bet.

So the best thing to do is going to be to not count callers, just open raisers.

cnt_p_fold_to_3b_nvbs_no_blind: sum(if[holdem_hand_player_statistics.enum_p_3bet_action = 'F' and holdem_hand_player_statistics.position < 8 and not(holdem_hand_player_statistics.flg_steal_att) and holdem_hand_player_statistics.flg_p_first_raise, 1, 0])

cnt_p_face_3b_nvbs_no_blind: sum(if[holdem_hand_player_statistics.flg_p_3bet_def_opp and holdem_hand_player_statistics.position < 8 and not(holdem_hand_player_statistics.flg_steal_att) and holdem_hand_player_statistics.flg_p_first_raise, 1, 0])

Put the former over the latter, multiply by 100 and you're good to go.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: 2 custom stats

Postby zubs1aa » Wed Jun 23, 2010 11:16 am

kraada wrote:You anticipated what my next questions would be very well :)

You are correct that there's no easy way to distinguish between people who call a raise before the 3bet and people who call the 3bet.

So the best thing to do is going to be to not count callers, just open raisers.

cnt_p_fold_to_3b_nvbs_no_blind: sum(if[holdem_hand_player_statistics.enum_p_3bet_action = 'F' and holdem_hand_player_statistics.position < 8 and not(holdem_hand_player_statistics.flg_steal_att) and holdem_hand_player_statistics.flg_p_first_raise, 1, 0])

cnt_p_face_3b_nvbs_no_blind: sum(if[holdem_hand_player_statistics.flg_p_3bet_def_opp and holdem_hand_player_statistics.position < 8 and not(holdem_hand_player_statistics.flg_steal_att) and holdem_hand_player_statistics.flg_p_first_raise, 1, 0])

Put the former over the latter, multiply by 100 and you're good to go.



This should be added to your standard stats. I have the same problem with your stats. I want to know the actions of only the open raiser, don't care about any limpers or flatters. This stat is only useful in the sense that it tells you who raise/folds. (people who limp/fold are already accounted for by the limp/fold stat. people who flat raises and fold - well I'd expect that 95%+ of the time they do..only the trickiest flat raises and don't fold. BUt one shoud have noted that they flatted QQ+, AK etc for those guys....)

similarly the raise to steal/fold to 3bet stat needs to be fixed in teh same way. It should be the same as above I believe, only position of the open raisor is BU, CO or Hijack. (EXCLUDING SB). The way that stat is written now is just not realistic for making decisions.

Stat needs to be redone a third time to reflect only steal attempts where the raise/fold to 3bet cam from the SB.

Can you give me the changes needed for those 2 situations i have mentioned? I've been meaning to fix that in my HUD for ages. (I'd also make the suggestion that you add those 2 to the standard stat lists as for tny play it's the way to go...
zubs1aa
 
Posts: 2219
Joined: Fri Feb 08, 2008 1:52 pm

Re: 2 custom stats

Postby kraada » Wed Jun 23, 2010 1:01 pm

Fold Steal to Blind Reraise is already the percentage that a person steals and folds to a 3-bet from the blinds - you cannot steal if you are not either the button or the cutoff. Technically if you actually steal and face a 3bet from the button I think that would count as a fold for that stat too (so perhaps the name is not the best). So I'm not sure exactly what you're looking for - can you be a bit more explicit?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: 2 custom stats

Postby zubs1aa » Wed Jun 23, 2010 1:24 pm

kraada wrote:Fold Steal to Blind Reraise is already the percentage that a person steals and folds to a 3-bet from the blinds - you cannot steal if you are not either the button or the cutoff. Technically if you actually steal and face a 3bet from the button I think that would count as a fold for that stat too (so perhaps the name is not the best). So I'm not sure exactly what you're looking for - can you be a bit more explicit?


A) These days, there are PLENTY of steals coming from the Hijack. The old definition may have stopped at CO, but todays game you need to include Hijack (at least a great number of us will want to do this probably the vast majority IMO if you took a poll)

What this is really saying is that anything in LP ( bu/co/HI ) is a suspect and likely lighter raise. What we are doing with the steal stat is really looking for people who abuse the late position privilege and may be likely to fold and be punished for doing this.


B) so, what I want to do (and think you guys should make standard) is the following:

1) Steal attempts made - meaning open raise from Bu, Co or Hijack. but NOT including SB steals. Currently SB is included in the steal % stat. I want steal from SB as a separate item that can be looked at for BvB. BvB steals and Bu/Co/Hi steals are truly different beasts.

2) Fold to 3bet: First off, whether it's from a steal or not, I only want it to reflect the folds by the original raiser- same as what OP said.

3)I want a fold to 3bet when stealing stat that matches my steal definition above. So if there is an open raise (no limpers) from the Hi, Co or Bu.. and they fold to a 3bet from either Co, Bu, Sb or BB - I consider that a steal folding to a 3bet. I do NOT want Sb stealing and folding to 3bet by BB included here.

4) sb steal folding to 3bet by BB is a different stat that I also want to see.
zubs1aa
 
Posts: 2219
Joined: Fri Feb 08, 2008 1:52 pm

Re: 2 custom stats

Postby WhiteRider » Wed Jun 23, 2010 2:05 pm

Given that there are (as you point out) different options for how to view these stats, and different people will want different things, I think it would be dangerous to change the behaviour/definition of things like "steal", but the custom stats mechanism allows you to have your own versions of stats like this.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Next

Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests