Custom 3 bet stat from bb

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

Custom 3 bet stat from bb

Postby rod stewart » Fri Sep 09, 2011 11:34 pm

im looking to make a custom 3 bet stat from bb and couldnt find anything in the repository or forum.

looking to find 3bet% from bb vs sb RFI. once i figure this out i should be able to build bb vs btn, and bb vs co individually, and from there i should be able to create custom sb stats by just changing the position values. i have raise vs steal stats but i cant figure out how to dissect it and build a more specific stat
rod stewart
 
Posts: 9
Joined: Thu Dec 30, 2010 9:15 pm

Re: Custom 3 bet stat from bb

Postby WhiteRider » Sat Sep 10, 2011 4:34 am

There is a built-in stat called "BB v SB Steal - Raise" (and also Call and Fold versions) which does what you want.
To build BB vs button or cutoff have a look how that is built and make copies changing the position to 0 for button and 1 for cutoff.
It isn't possible to build a fully correct version of this stat for the SB because if the BB re-raises then we lose the position of the initial raiser, but it will work OK for most cases. (This will be possible in PT4.)

The Tutorial: Custom Reports and Statistics has a section on making new versions of existing stats.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Custom 3 bet stat from bb

Postby rod stewart » Sun Sep 11, 2011 5:23 am

im trying to build a stat that is 3bet by position vs RFI from other positions. for example bb 3 bets HJ open or button 3bets utg open. the bb vs sb steal stat won't let me deal with any non steal situations
rod stewart
 
Posts: 9
Joined: Thu Dec 30, 2010 9:15 pm

Re: Custom 3 bet stat from bb

Postby kraada » Sun Sep 11, 2011 7:42 am

It's not possible to build this stat 100% accurately.

This problem has been resolved for PT4.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Custom 3 bet stat from bb

Postby rod stewart » Sun Sep 11, 2011 5:16 pm

i dont mind if its not 100% accurate as long as i know why. it shouldnt be hard for someone competent to come up with this stat should it? I'm embarrassingly bad at this but it seems like you just need to have player facing RFI (by position), action 3bet (position). im not worried about weather its a squeeze or there is limpers

is it possible to try the pt4 (alpha or beta) where this stat is available?
rod stewart
 
Posts: 9
Joined: Thu Dec 30, 2010 9:15 pm

Re: Custom 3 bet stat from bb

Postby WhiteRider » Sun Sep 11, 2011 5:24 pm

The problem is that as soon as someone re-raises we don't know the position of the initial raiser anymore. If you're willing to only count hands where there was no further action beyond the 3-bet (or at least, not by any other players) then we can build it. It's late here now but if you're interested in that I'll take another look at it in the morning.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Custom 3 bet stat from bb

Postby rod stewart » Sun Sep 11, 2011 6:33 pm

yes i think that stat would still be very helpful

thanks a lot, i really appreciate the help
rod stewart
 
Posts: 9
Joined: Thu Dec 30, 2010 9:15 pm

Re: Custom 3 bet stat from bb

Postby WhiteRider » Mon Sep 12, 2011 3:51 am

Note: this will get some cases wrong, as noted above. We can only know the position of the last player to raise, not the first. Also, we cannot tell that the first raise was an open-raise (there could have been a limp first).

The position of the last player to raise preflop (other than the active player) is stored as "holdem_hand_player_detail.val_p_raise_aggressor_pos", so for instance this counts the number of times the last raiser was the hijack and the active player 3-bet.

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

If you want to rule out hands where there was a 4-bet so that we can eliminate most of the error cases you can include "AND NOT holdem_hand_player_statistics.flg_p_4bet_def_opp".
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Custom 3 bet stat from bb

Postby Mr Tiger » Mon Feb 27, 2012 6:34 pm

WhiteRider wrote:If you want to rule out hands where there was a 4-bet so that we can eliminate most of the error cases you can include "AND NOT holdem_hand_player_statistics.flg_p_4bet_def_opp".

I suppose, most of the error cases occur when we fold to HJ open and player behind us (BU, SB or BB) 3bets. Am I right?
Mr Tiger
 
Posts: 143
Joined: Tue Sep 09, 2008 5:14 am

Re: Custom 3 bet stat from bb

Postby kraada » Mon Feb 27, 2012 6:49 pm

Correct
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

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

Who is online

Users browsing this forum: No registered users and 0 guests