Re-Steal % Stat

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-Steal % Stat

Postby FancyBazil » Sat Aug 30, 2008 7:55 pm

I am trying to to build a resteal % stat for tournaments

This would basically be how often the BB or SB reraised an open raise from the SB, button or cut-off.

I already have the first part, ie how often the SB. button or cut-off raise, so I need to add a THEN or AND function which adds the later position reraise condition. I know there is a similar stat for cash games involving the SB 3-betting a steal from the button, but I'm not sure if the 3 bet reraise stat for limit cash games would work in a tournament stat.
FancyBazil
 
Posts: 2
Joined: Fri Aug 01, 2008 12:01 pm

Re: Re-Steal % Stat

Postby WhiteRider » Sun Aug 31, 2008 4:46 am

These stats are already built in for cash players, so have a look at Raise_BB_Steal / Raise_SB_Steal (in section 'holdem cash player statistics') and you should be able to see how the columns are constructed and do the same in 'holdem tournament player statistics'.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 20 guests