SB limp and call BB raise

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

SB limp and call BB raise

Postby pr1mo » Wed Nov 26, 2008 12:45 am

In the repository there is the "SB limp and call BB raise" stat which is a correction done from a stat from the HU 6 stats in one group posting by pt forum member: Al1_Ge The stat says how often someone is folded to in the SB and calls and then calls a raise from the BB. Will this work for 6max and Full ring as well? or just HU situations? formula is: (cnt_sb_limp_call / cnt_sb_limp_face_raise) * 100 I tried msg'n him but said user was not found on forum.
pr1mo
 
Posts: 192
Joined: Tue Apr 29, 2008 10:22 pm

Re: SB limp and call BB raise

Postby WhiteRider » Wed Nov 26, 2008 7:20 am

I'm pretty sure that the stat will work for all table sizes.
Have a look at the columns (cnt_sb_limp_call & cnt_sb_limp_face_raise) and if they don't refer to the number of players then it will work for all sizes.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: SB limp and call BB raise

Postby pr1mo » Thu Nov 27, 2008 2:33 am

ok i had a look and for the first line it says position = 9 for both of them so does this mean on a 10 handed table position 9 is the SB? so this stat only works on a 10 handed table? because in his stat definition he states that it's for HU so not sure what that means.

cnt_sb_limp_face_raise:

sum(if[holdem_hand_player_statistics.position = 9 AND
holdem_hand_player_statistics.flg_p_face_raise = true AND
holdem_hand_player_statistics.flg_p_fold = false AND
holdem_hand_player_statistics.cnt_p_raise = 0, 1, 0])

cnt_sb_limp_face_raise:

sum(if[holdem_hand_player_statistics.position = 9 AND
holdem_hand_player_statistics.flg_vpip AND
holdem_hand_player_statistics.flg_p_first_raise = false AND
holdem_hand_player_statistics.flg_p_face_raise, 1, 0])
pr1mo
 
Posts: 192
Joined: Tue Apr 29, 2008 10:22 pm

Re: SB limp and call BB raise

Postby WhiteRider » Thu Nov 27, 2008 5:26 am

The SB is always position 9 for all table sizes, and BB=8. This is to avoid problems with stats like this. It will work for all sizes.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: SB limp and call BB raise

Postby Weedobooty » Thu Nov 27, 2008 8:33 am

Is there a stat that shows limp/call raise or limp/fold to a raise from other positions?
Weedobooty
 
Posts: 7
Joined: Sat May 17, 2008 11:40 am

Re: SB limp and call BB raise

Postby WhiteRider » Thu Nov 27, 2008 11:03 am

I've added updated versions of these here: viewtopic.php?f=15&t=9500&p=68770#p68770
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 0 guests