WCR Session 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

WCR Session Stat?

Postby sfifield » Sun Jan 22, 2012 5:43 pm

Is it possible to build a WCR stat for a session (i.e., total weighted contributed rake paid in that session) to go with the MGR that is part of the default stats. If have tried creating a column under 'Holdem Cash Session' with the formula below and while it checks as a "Valid" expression, it generates errors when I try to run a report.

sum(if[holdem_hand_player_detail.amt_bet_ttl > 0, (holdem_hand_player_detail.amt_bet_ttl / holdem_hand_summary.amt_pot) * holdem_hand_summary.amt_rake, 0])

Alternately, is WCR going to be built into PT4 as a default stat? If so, I guess I can wait for PT4 (is the plan to release the public beta this month?).
sfifield
 
Posts: 31
Joined: Sun Apr 04, 2010 4:24 pm

Re: WCR Session Stat?

Postby WhiteRider » Sun Jan 22, 2012 6:33 pm

You can't build that kind of stat in the "session" section because it needs information about individual hands, but here we only know about overall session results.
This distinction doesn't exist in PT4 and we have a weighted contributed rake stat built in, which can be displayed in any kind of report.

In the meantime, in PT3 you can use the custom report I published ("HCPS Session Stats" in Customize PokerTracker) to display Holdem Cash Player Statistics stats grouped by session. You could add your WCR stat to that, assuming you have one in the Holdem Cash Player Statistics section.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: WCR Session Stat?

Postby sfifield » Sun Jan 22, 2012 6:35 pm

Thanks. Eagerly awaiting PT4...
sfifield
 
Posts: 31
Joined: Sun Apr 04, 2010 4:24 pm


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

Who is online

Users browsing this forum: No registered users and 5 guests