cutsom report check pls

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

cutsom report check pls

Postby DrKK » Wed Jul 15, 2009 3:23 am

Hi,

I made a report to see how im doing in hands with draws on the flop.
Before I deposit these to the repository I would like someone to check them to see if I made some errors somewhere.

Download here pls. It is a zip file with the Flushdraw and Straightdraw report.
http://urahost.com/download.php?file=420097

tx in advance,


DrKK
DrKK
 
Posts: 121
Joined: Mon May 05, 2008 10:13 am

Re: cutsom report check pls

Postby WhiteRider » Thu Jul 16, 2009 4:34 am

Basically they look ok.
I'm not sure that you want to filter out straight draws on the flush draw report though (and vice versa) - this will hide hands where you have a flush draw if you have a straight draw as well, but I assume you'd want to see those as well (or is that a separate set of hands, because you have an even better draw?)
Actually, even if you don't want to see hands where you have both (flush and straight) draws on the flop your current filter will hide hands where you picked up a straight draw on the turn too, so you'd want to change 'no straight draw' to 'no straight draw on the flop' I guess.

The other thing I'd suggest is adding the Hole1, Hole2 as well as Flop1/2/3 stats so you can see the actual cards in the reports; but that's just a personal preference thing.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: cutsom report check pls

Postby DrKK » Fri Jul 17, 2009 8:29 am

Hello, Whiterider,

Thanks for the advice. You are correct concerning what I want. Indeed, I only want to see single draw situations on the flop and not the combo draws since those have very different odds and I want to look at combo draws seperately.
Also, I want to see my performance with draws on the flop. If I want to see draws on turn as well I can easily chance that in the simple filter.

So basically, I want to check how Im doing in draws on flop. Just basic performance to see if I do well with the win vs pot odds.

Hole card 1 and 2 is indeed a good idea.

Tx again for the check :)
DrKK
 
Posts: 121
Joined: Mon May 05, 2008 10:13 am

Re: cutsom report check pls

Postby WhiteRider » Fri Jul 17, 2009 10:23 am

In that case I think you ought to check for 'no straight draw on the flop' rather than 'no straight draw'; otherwise you'll filter out hands where you had a flush draw on the flop then picked up a straight draw on the turn.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: cutsom report check pls

Postby DrKK » Thu Jul 23, 2009 5:38 am

ok tanks! :)
DrKK
 
Posts: 121
Joined: Mon May 05, 2008 10:13 am


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

Who is online

Users browsing this forum: No registered users and 0 guests