RWPC form specific position. can you count the limper?

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

RWPC form specific position. can you count the limper?

Postby marvin » Sun Dec 19, 2010 1:13 pm

Is possible having a count of the limper (or of the pot value pf) when someone RWPC? ty
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: RWPC form specific position. can you count the limper?

Postby kraada » Sun Dec 19, 2010 1:28 pm

Only for hands in which you RWPC, this should be doable I think - would you want this in a Hands or in a Player Statistics report?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: RWPC form specific position. can you count the limper?

Postby marvin » Mon Dec 20, 2010 7:34 am

player statistic in table 3way, if BB RWPC i need to discriminate if the limper is SB, is the button or are button and SB. for doing it i need to compute value of the pot.
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: RWPC form specific position. can you count the limper?

Postby WhiteRider » Mon Dec 20, 2010 10:01 am

Please see this post on the same topic.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: RWPC form specific position. can you count the limper?

Postby marvin » Mon Dec 20, 2010 6:22 pm

what kind of differences can i use if bb RWPC (in 3way pot) if
1) the limper is only p0
2) the limpers are p0 & P9
3) the limper is only P9 (ijn this case i think i can use your stats, but i wish understand the logic that you have used)
specifically, i wish understand what means:
"and round((holdem_hand_player_detail.amt_p_raise_made / (holdem_limit.amt_bb * holdem_limit.val_nlpl_mult)) * 100) = round(holdem_hand_player_detail.val_p_raise_made_pct), 1, 0])"
can you explain?
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: RWPC form specific position. can you count the limper?

Postby WhiteRider » Tue Dec 21, 2010 4:22 am

In understanding the expression ignore the "round" function – that is needed to avoid differences due to rounding errors, but doesn't affect the understanding.

We are comparing the absolute size of the raise (holdem_hand_player_detail.amt_p_raise_made) with the size of the raise as a percentage of the pot (holdem_hand_player_detail.val_p_raise_made_pct).

If the small blind has limped and everyone else has folded then the pot is 2 BBs before the big blind acts. If another player limped and the small blind folded then the pot is 2.5 BBs. If another player and a small blind both limped then the pot is 3 BBs.
We can use that information in conjunction with the absolute size of the raise in BBs and the percentage raise to determine the number of limpers.

See this thread for calculation examples.

We need to use "round" around each part if we're going to do exact comparisons using =, since we using divisions and can end up with very slightly different decimals.
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 16 guests