Custom Reports involving HU sessions.

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

Custom Reports involving HU sessions.

Postby Kevweiser » Thu Dec 11, 2008 7:35 am

I play alot of hu. I'm trying to build a custom report that allows me to see my winrate verse opponents who have certain stats (looseness for example). However, there is a tricky thing here... if my opponent does poorly, usually they bust and I never get enough hands to have useful stats on them. If my opponent does well, they stay and I do get useful stats on them. When I create my custom reports, I always filter out the opponents who haven't played enough hands to have useful stats. So I'm testing my winrate verse players who have played more then 30 hands for example... by doing this I end up drawing from a data set of opponents WHO DID NOT BUST early... and therefore have in greatly increased chance of having had a winning session so far. So what I'm trying to do is nullify this effect.
One possible solution is to ignore the amount won in the first 30 hands, but not to ignore the stats I'm looking at. So what I would like to do is to create a custom report that only starts factoring in the amount won after the first 30 hands of the session. Any pointers on how to go about this?
Kevweiser
 
Posts: 52
Joined: Wed Jul 09, 2008 1:44 pm

Re: Custom Reports involving HU sessions.

Postby kraada » Thu Dec 11, 2008 10:20 am

There should be a way to build a custom stat that displays amount won after 30 hands, but it's not immediately obvious to me how to do it.

I'll take a look at the problem later today and get back to you.
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 1 guest