merge BBJ rake?

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

merge BBJ rake?

Postby waffe7 » Sun Jan 29, 2012 8:28 pm

Anybody have a stat/report for this?
waffe7
 
Posts: 38
Joined: Thu Aug 14, 2008 8:08 pm

Re: merge BBJ rake?

Postby WhiteRider » Mon Jan 30, 2012 4:44 am

Merge do not specify rake or BBJ in their hand histories so there is nothing to import to PT3. We're discussing the possibility of storing alternative rakes like these separately in PT4, but given the lack of information provided by sites I'm not sure what will be possible.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: merge BBJ rake?

Postby waffe7 » Mon Jan 30, 2012 9:22 am

Ok, thanks. Let me ask you this, do you know if it's possible to do this filter (or report):

set filters to: won hand, saw flop, and pot size >5bbs

I didn't see any way to set the pot size to >5bbs in the normal filters.
waffe7
 
Posts: 38
Joined: Thu Aug 14, 2008 8:08 pm

Re: merge BBJ rake?

Postby kraada » Mon Jan 30, 2012 10:39 am

You have to use OR a lot to get pot sizes like that (pot size is on the Misc tab). >= is an option in PT4's filter system.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: merge BBJ rake?

Postby waffe7 » Mon Jan 30, 2012 11:08 am

Hm doesn't look possible since lowest range is Pot is 0-10bb. Might it be possible to do with a report?
waffe7
 
Posts: 38
Joined: Thu Aug 14, 2008 8:08 pm

Re: merge BBJ rake?

Postby kraada » Mon Jan 30, 2012 2:15 pm

Yes that should be possible. Do you mean total pot at the end of the hand?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: merge BBJ rake?

Postby waffe7 » Mon Jan 30, 2012 6:12 pm

Yes, total pot is >= 5bb at end of hand.
waffe7
 
Posts: 38
Joined: Thu Aug 14, 2008 8:08 pm

Re: merge BBJ rake?

Postby kraada » Tue Jan 31, 2012 9:58 am

Add a filter in your custom report (in the blue Filters area) for holdem_hand_summary.amt_pot >= (5 / holdem_limit.amt_bb)

and that will limit you to seeing data from hands where the final pot was more than 5 big blinds.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 4 guests