BvB stats

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

BvB stats

Postby banshee » Mon Oct 27, 2008 12:23 pm

Does someone find a mistake in my stats. Sometimes they conflict (i.e. someone opened 5 of 5 SBs and opencompleted 5 of 5)

open SB:

numerator: SUM(if[holdem_hand_player_statistics.position = 9 AND holdem_hand_player_statistics.flg_p_open_opp,1,0])
denominator: sum(if[holdem_hand_player_statistics.flg_p_open AND holdem_hand_player_statistics.position = 9,1,0])

opencomplete SB:

numerator: sum(if[holdem_hand_player_statistics.flg_p_open_opp AND holdem_hand_player_statistics.flg_p_limp AND holdem_hand_player_statistics.position = 9,1,0])
denominator: same as above
banshee
 
Posts: 53
Joined: Thu May 08, 2008 6:10 am

Re: BvB stats

Postby WhiteRider » Mon Oct 27, 2008 12:29 pm

For open SB you have the numerator and denominator the wrong way round - or is that a typo?

"Open" just means entered the pot, though - so that's not a conflict..
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: BvB stats

Postby banshee » Mon Oct 27, 2008 5:26 pm

okay I thought about that but the documentation explicitly said open = openraise so that kept me trusting ^^
banshee
 
Posts: 53
Joined: Thu May 08, 2008 6:10 am

Re: BvB stats

Postby WhiteRider » Mon Oct 27, 2008 5:33 pm

Where does it say that?
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