Raise limpers opportunity

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

Raise limpers opportunity

Postby stevi3p » Thu Mar 05, 2009 7:19 pm

I want to create a stat Raise PF Limpers %. cnt_p_raise_limpers already exists within PT3. I want to create a cnt_p_raise_limpers_opp field. Does this make sense: will not face_raise also filter out when facing a 3bet / 4bet.

sum( if[ not holdem_hand_player_statistics.flg_p_face_raise AND NOT holdem_hand_player_statistics.flg_p_open_opp, 1 , 0 ] )
stevi3p
 
Posts: 71
Joined: Thu Mar 13, 2008 3:00 pm

Re: Raise limpers opportunity

Postby kraada » Fri Mar 06, 2009 10:14 am

The built in stat RWPC already does what you're looking to do. I know it's in Beta 25, I'm not certain if it's in Build 4, so you may need to upgrade to get it, but it should save you significant time (and you can look at how the stat's built if you're curious how we can up with the numbers.)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Raise limpers opportunity

Postby WhiteRider » Fri Mar 06, 2009 1:31 pm

Just to clarify, since the name of this stat has caused confusion for a few people.
RWPC is Raise With Previous Callers in the same way that LWPC is Limp With Previous Callers.
"Callers" here are people who "limped" (called the big blind amount, not called a raise) - i.e. it means only callers.
It shows how often a player raised when there was already at least one limper in the pot.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Raise limpers opportunity

Postby stevi3p » Fri Mar 06, 2009 3:19 pm

Thanks for this - I missed it in PT3.

I see the cnt_p_facing_limpers is similar to my suggestion with a couple of extra criteria:

sum( if[ ((NOT holdem_hand_player_statistics.flg_p_face_raise) OR holdem_hand_player_statistics.flg_p_limp OR holdem_hand_player_statistics.flg_p_first_raise) AND NOT holdem_hand_player_statistics.flg_p_open_opp, 1 , 0 ] )

Looking at the created stats, there are slight differences in stats, with my version being about 0.5% lower. But I don't understand why - what extra situations are these extra criteria filtering out? (Not particularly significant, but I'm keen to learn....)
stevi3p
 
Posts: 71
Joined: Thu Mar 13, 2008 3:00 pm

Re: Raise limpers opportunity

Postby WhiteRider » Fri Mar 06, 2009 4:04 pm

Your formula does not count cases when you face a raise after your first action - maybe you limp or raise and then face a raise.
Mine includes these by checking for "didn't face a raise" OR "limped or made the first raise" (so you can face a raise AFTER you limped or made the first raise).
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 1 guest