Need a report to show flop FD and SD come in by the river %

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

Need a report to show flop FD and SD come in by the river %

Postby eroock » Sun Mar 27, 2011 12:16 am

I saw the setmine report in the download list and wondered if it may be possible to create another report to show how good I am running with playing my draws. I am not good with creating this myself. Can you guys help me out here?
eroock
 
Posts: 147
Joined: Sun Jun 20, 2010 8:50 pm

Re: Need a report to show flop FD and SD come in by the rive

Postby WhiteRider » Sun Mar 27, 2011 5:13 am

The easiest way to do that kind of thing is to use the Filters. You will want the "Draws" tab.
If you can't isolate the situations that you want please let us know exactly what you're trying to do and we'll help you out.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Need a report to show flop FD and SD come in by the rive

Postby eroock » Mon Mar 28, 2011 6:41 am

I agree that it can be done with filters. However, this would be a time consuming endevour, even with filter presets.
Here's what I had to do:

Filter for
A1. SD on the flop & saw the flop
A2. Made straight on the river & saw the river
B1. FD on the flop & saw the flop
B2. Made flush on the river & saw the river
C. Do some manual calculations about the hitting percentage

Now, I figured a report would come in handy. But I wouldn't know how to do it myself.
eroock
 
Posts: 147
Joined: Sun Jun 20, 2010 8:50 pm

Re: Need a report to show flop FD and SD come in by the rive

Postby kraada » Mon Mar 28, 2011 9:27 am

Some reports on these can be found in the attached zip file.
Attachments
draws.zip
(4.33 KiB) Downloaded 111 times
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Need a report to show flop FD and SD come in by the rive

Postby eroock » Mon Mar 28, 2011 9:36 am

Awesome, that's what I needed. I just removed the grouping by hole cards.
eroock
 
Posts: 147
Joined: Sun Jun 20, 2010 8:50 pm

Re: Need a report to show flop FD and SD come in by the rive

Postby eroock » Mon Mar 28, 2011 9:46 am

As an aside, in the report download section there is one report called "Flopped Sets" which is deceiving as it counts in PP that didn't see the flop. Results are skewed. There's a different report called "Pocket Pair Hit Flop" which does the job right, so I see no use for first one.
eroock
 
Posts: 147
Joined: Sun Jun 20, 2010 8:50 pm

Re: Need a report to show flop FD and SD come in by the rive

Postby kraada » Mon Mar 28, 2011 10:01 am

Thanks I'll mention that to the appropriate people.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Need a report to show flop FD and SD come in by the rive

Postby eroock » Mon Mar 28, 2011 11:39 am

I am now trying to get into this custom report thing. One more question, I want to break the stats down by months. So how can I transfer the report from "Holdem Cash Hand" to "Holdem Cash Play Statistics". Is it possible in the first place?
eroock
 
Posts: 147
Joined: Sun Jun 20, 2010 8:50 pm

Re: Need a report to show flop FD and SD come in by the rive

Postby kraada » Mon Mar 28, 2011 11:42 am

You can't directly transfer a report like that. What you could do though is use the Filters to filter for one month at a time and see your results that way of this report as it stands.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Need a report to show flop FD and SD come in by the rive

Postby eroock » Mon Mar 28, 2011 11:51 am

Just for the records, how does the transfer work? When I try to import a report it goes straight to the section it was made for.
eroock
 
Posts: 147
Joined: Sun Jun 20, 2010 8:50 pm

Next

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

Who is online

Users browsing this forum: No registered users and 1 guest