Report which faces the preflop action

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

Report which faces the preflop action

Postby R3mbrandt » Wed Feb 11, 2009 12:03 pm

Hello!

10 Month ago, this post was made. But there was no final answer. So, I'ill ask again. ;-)
Is it possible to create a report, which faces the preflop action similiar like this one in HM?

Thx,
Rembrandt
R3mbrandt
 
Posts: 15
Joined: Fri Sep 12, 2008 4:17 pm

Re: Report which faces the preflop action

Postby kraada » Wed Feb 11, 2009 1:24 pm

Rembrandt,

Did you create the support ticket as requested by APerfect10?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Report which faces the preflop action

Postby R3mbrandt » Wed Feb 11, 2009 1:34 pm

I dont know if the OP did create such a ticket. I'm just interested in this report too and found his post, when I searched in the forum.
Should I create such a ticket?

Thx,
Rembrandt
R3mbrandt
 
Posts: 15
Joined: Fri Sep 12, 2008 4:17 pm

Re: Report which faces the preflop action

Postby kraada » Wed Feb 11, 2009 1:45 pm

Oh, sorry, I thought you were the one that had originally asked :oops:

I'll see about looking that original ticket up and get back to you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Report which faces the preflop action

Postby WhiteRider » Wed Feb 11, 2009 6:23 pm

Do you want to filter your report to show hands where you faced a raise at your first action, or do you want a stat you can display in a report that indicates what action you were facing at your first action?

You could create a stat in the Holdem Cash Hands section easily enough, but that will only allow you to filter Custom Reports in the Holdem Cash Hands section.
Please let us know exactly what you want to do so that we can work out whether it is possible.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Report which faces the preflop action

Postby R3mbrandt » Thu Feb 12, 2009 12:52 am

Hi!

I want a stat/flag/filter that indicates the action before my first action. E.g. Unopened pot, 1 limper, 2+ limpers, raiser+caller(s), 1 raiser, 2+ raiser, folded to bb. I need this not only for the Cash Hands section, but also for Tourneys.

Would this be possible?

Thx!
R3mbrandt
 
Posts: 15
Joined: Fri Sep 12, 2008 4:17 pm

Re: Report which faces the preflop action

Postby kraada » Thu Feb 12, 2009 11:20 am

You can find out if you're in an unopened pot (flg_p_open_opp is true), if there are some limpers (flg_p_open_opp is false, flg_p_face_raise is false), if there has been 1 (flg_p_face_raise is true, flg_p_3bet_def_opp is false, flg_p_4bet_def_opp is false) 2 (flg_p_3bet_def_opp is true) or 3+ (flg_p_4bet_def_opp is true) raises, but you can't tell whether those raises have been called by 3rd parties at this point.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Report which faces the preflop action

Postby R3mbrandt » Thu Feb 12, 2009 11:56 am

Can you give me a (quick and dirty) example (or a link to one) how I can uses these flags to create a custom report?

TIA,
Rembrandt
R3mbrandt
 
Posts: 15
Joined: Fri Sep 12, 2008 4:17 pm

Re: Report which faces the preflop action

Postby kraada » Thu Feb 12, 2009 12:49 pm

Say you want VP$IP and PFR for all players in spots when they're facing a PFR.

On the reports tab, choose the Holdem Cash Player Statistics section, add Player, VP$IP and PFR to the report from the bottom left section, then click on the blue Filters link, uncheck "filter on active player" and click "Simple Filters", go to the Facing tab, check "Facing Raise" click "Add Selected to Filters" then "OK". Save and run your report.

(You need the specific database flags more for creating stats; I was referring to them to explain why you can find out certain spots, but you can use any of the filters in the filters section for a report. I should've been more clear, sorry :)
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 14 guests