About 3bet vs steal%

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

Re: About 3bet vs steal%

Postby WhiteRider » Sat Sep 05, 2009 4:51 am

pr1mo wrote:what about that rule that you can put what our exact actions were on a particular street? couldn't we set a rule where we only 'R' preflop then this would take out all the 4bet behind us opportunities because we are saying that we have only acted once preflop and we raised on button facing a steal and with a 3bet def opp.

You're right about checking for your actions being only 'R', but on the button you are not facing a blind steal, because you haven't posted a blind.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: About 3bet vs steal%

Postby pr1mo » Sat Sep 05, 2009 2:15 pm

so then only option would be to label opponent as making a steal attempt but i guess if we are building this stat for the player on the button...impossible to also select that the opponent = cutoff and has attempted a steal
pr1mo
 
Posts: 192
Joined: Tue Apr 29, 2008 10:22 pm

Re: About 3bet vs steal%

Postby WhiteRider » Sat Sep 05, 2009 2:54 pm

That's right - that's why this is a difficult case to track down.
We have requested/suggested in the past that further information to cover this kind of situation be added but I don't know when that will be done.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: About 3bet vs steal%

Postby pr1mo » Sat Sep 05, 2009 3:23 pm

WhiteRider wrote:We have requested/suggested in the past that further information to cover this kind of situation be added but I don't know when that will be done.


being able to classify actions on 2 different players in the same stat would pretty much be the holy grail i think. endless possibilities. looking forward to that functionality one day!
pr1mo
 
Posts: 192
Joined: Tue Apr 29, 2008 10:22 pm

Re: About 3bet vs steal%

Postby kraada » Sun Sep 06, 2009 9:06 am

I agree, and hopefully this will be possible at one point, though it likely won't be anytime soon as much as we'd like it to be :)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: About 3bet vs steal%

Postby Mr Tiger » Sun Feb 26, 2012 2:08 pm

I've made a stat Resteal BUvsCO with some limitations, which were noted here: https://www.pokertracker.com/forums/vie ... 26#p106693
But I'm not sure, if I'm correct.

cnt_p_BU_3bet_to_CO_steal_approx
sum(if[holdem_hand_player_statistics.flg_p_3bet AND
holdem_hand_player_statistics.position = 0 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 1 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0])

cnt_p_BU_3bet_to_CO_steal_opp_approx
sum(if[holdem_hand_player_statistics.position = 0 AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 1 AND holdem_hand_player_statistics.flg_blind_def_opp,1,0])

Does the expression holdem_hand_player_statistics.flg_blind_def_opp,1,0 make sense here?
What if HJ open raises, CO 3bets and BU folds? Does it count as BU doesn't 3bet vs CO here?
And I'm also afraid of this issue: https://www.pokertracker.com/forums/vie ... 27#p194638 Does it take place here too?
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: About 3bet vs steal%

Postby WhiteRider » Sun Feb 26, 2012 4:38 pm

These stats won't work accurately for the reasons described in the posts you linked. If anyone re-raises then you lose the information about the position of the original raiser.

Furthermore, holdem_hand_player_statistics.flg_blind_def_opp is never true for the button as they have nothing committed to the pot yet to be "stolen".
It isn't possible to tell whether the raise they face was an open (steal) raise or not.

All of this is possible in PT4, and some of it is already built in to existing stats.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: About 3bet vs steal%

Postby Mr Tiger » Sun Feb 26, 2012 5:24 pm

WhiteRider
Thanks for the answer. I haven't yet understood only one thing. Why am I get value>0, if "holdem_hand_player_statistics.flg_blind_def_opp is never true for the button"?
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: About 3bet vs steal%

Postby WhiteRider » Sun Feb 26, 2012 5:32 pm

Hmm - that is odd! Please export your stat and attach it to a Support Ticket with a link to this thread so that we can check it out.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: About 3bet vs steal%

Postby Mr Tiger » Sun Feb 26, 2012 7:05 pm

Done. Looking forward for your answer soon.
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

PreviousNext

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

Who is online

Users browsing this forum: No registered users and 1 guest