Check flop as PFR

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

Check flop as PFR

Postby colombo218 » Wed Mar 23, 2011 11:38 am

I'd like to write a script that would allow me to grab all hand histories where a specific opponent of mine (we'll call him O) raises preflop and checks back on the flop. Can anyone help with this?
colombo218
 
Posts: 6
Joined: Tue May 13, 2008 4:33 pm

Re: Check flop as PFR

Postby kraada » Wed Mar 23, 2011 11:47 am

You could build a custom report which would list all of the hands a player does this with. When you say "checks back" do you mean to imply that he's in position though?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Check flop as PFR

Postby colombo218 » Wed Mar 23, 2011 12:05 pm

kraada wrote:You could build a custom report which would list all of the hands a player does this with. When you say "checks back" do you mean to imply that he's in position though?


yes, it's a heads up match.

I tried a custom report but only got a single % metric. How do you get hand histories?

edit: If possible id only like to include hands that went to showdown
colombo218
 
Posts: 6
Joined: Tue May 13, 2008 4:33 pm

Re: Check flop as PFR

Postby kraada » Wed Mar 23, 2011 12:33 pm

Create the custom report in the Hand section and you can use the blue Filters link to filter for your specific cases. If you display the Hand # statistic you'll be able to double click on the individual hands to see the hand history files. For more on creating custom reports please see the Tutorial: Using Custom Statistics and Reports.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Check flop as PFR

Postby colombo218 » Wed Mar 23, 2011 1:09 pm

Hm..I don't see a hand number statistic.

Under avaiable stats in the bottom left corner I am choosing "PFR Flop Check"

Next I'm clicking the blue filters button, and you're saying I should be able to get the HH from here? What is the syntax?
colombo218
 
Posts: 6
Joined: Tue May 13, 2008 4:33 pm

Re: Check flop as PFR

Postby colombo218 » Wed Mar 23, 2011 1:50 pm

Ok I'm getting a little more familiar with this but I still need help.

I've figureed out how to filter my report so that it only shows hands where he checks the flop by doing (cnt_pfr_f_check > 0). Is that expression correct? Is there a way to further filter this to only include hands that went to showdown?

I still can't figure out how to get the Report to show hand history. I can get it to show his Hole Cards. is there a way to get it to show the flop?
colombo218
 
Posts: 6
Joined: Tue May 13, 2008 4:33 pm

Re: Check flop as PFR

Postby kraada » Wed Mar 23, 2011 4:16 pm

You want to build your report in the Hand section, not the Player Statistics section since you want to see individual hands. Then you want to use the Simple Filters to filter for times he checked on the flop (which is on the Actions -> Flop tab) in addition to the other filter you want, and if you add the stats from the Hand section you'll see data only from individual hands.
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 0 guests