All in preflop

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

All in preflop

Postby rebelry » Fri Oct 10, 2008 5:18 am

Hi, I'm new to running reports and stats and although I've read the manual I'm still lost.

I'd like to show the known hole cards for my and my opponents hands where they have gone all in pre-flop. Is there a way to do this? Thank you.
rebelry
 
Posts: 13
Joined: Tue Jul 08, 2008 4:43 pm

Re: All in preflop

Postby WhiteRider » Fri Oct 10, 2008 9:47 am

There is no way to get hole cards of specific opponents at the moment.
There is not yet a built in filter for all in preflop although we plan to add this amongst other filters pretty soon.
For now you will need to build a Custom Stat for all in PF and use that to filter a Custom Report.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: All in preflop

Postby rebelry » Fri Oct 10, 2008 12:47 pm

WhiteRider wrote:For now you will need to build a Custom Stat for all in PF and use that to filter a Custom Report.

Thanks for the response. Sorry to be so ignorant but what do I need to input to get this as I've looked through the options and can't find an all in. It's highly possible I'm not looking in the right place though!
rebelry
 
Posts: 13
Joined: Tue Jul 08, 2008 4:43 pm

Re: All in preflop

Postby kraada » Fri Oct 10, 2008 1:03 pm

You'd create the custom stat in the Configure --> Stats interface.

You want to create it in Holdem Cash Player Statistics based around enum_allin which is a field in the database that gives the letter of the street when you went all in. Valid values are: F, N, P, R, T for flop, none, preflop, river, turn.

Create a column for enum_allin, call it enum_allin. Then a stat that just displays that value should be sufficient.

Then just create a custom report and filter for #enum_allin# = P and display their hole cards in the report.

I know I went kind of fast through that, so if you're stuck on a particular piece just let me know which and I'll go through it in more detail.

The main idea is to create a stat that tells you when you went allin, then run a report for when it's preflop for everyone (make sure you uncheck filter on active player) and show the hole cards of the player for when they went all-in preflop.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: All in preflop

Postby rebelry » Sat Oct 11, 2008 9:11 am

Thanks for the reply, sorry but I need more help on what to input.

I've selected Holdem Cash Play Statistics and opened "Configure Statistics" and am on the Columns tab. I have input enum_allin as the name, what do I need to put in the Expression box and Description box?

I've found a thread on 2+2 where you're helping someone with a very similar query to what I'm looking for so I'll wait for that if it saves you time by not answering this question. The only difference is I'd like to know for any stack size rather than 100bb and for 6max rather than FR. Your help is much appreciated. http://forumserver.twoplustwo.com/114/pokertracker/filter-question-307828/
rebelry
 
Posts: 13
Joined: Tue Jul 08, 2008 4:43 pm

Re: All in preflop

Postby kraada » Sat Oct 11, 2008 10:09 am

Having a filter and having a statistic are subtly different things. It is likely we'll have expanded filters in the next beta release after this one.

On the columns tab, create a new column, call it enum_allin, in the Expression box put holdem_hand_player_statistics.enum_allin and in the description box you can put whatever you'd like.

Go to the Stats tab, create a new stat call it whatever you like, let's say "When All In" for now.
In the description field you can put whatever you'd like, in the value expression put "enum_allin" (no quotes). Format tab, title as you desire the header to look, so let's say "AI", width of 50 should be plenty. We can do a little fancy footwork on the formatting:
Code: Select all
if(enum_allin = 'N', 'No', if(enum_allin = 'P', 'Preflop', if(enum_allin = 'F', 'Flop', if(enum_allin = 'T', 'Turn', if(enum_allin = 'R', 'River', 'None')))))


This way it tells you the street directly and looks a little prettier.

Then when you go create the custom report, add #When All in# = 'X' where X is one of these values: N, P, F, T, R.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: All in preflop

Postby rebelry » Sat Oct 11, 2008 3:02 pm

Sorry to be a pain, I've got to the last bit. Its my first time at creating custom reports.

I've got as far as Reports and under section have selected Holdem Cash Player Statistics. Under Category I have selected When All in, then gone to Filters and entered #When All in# = P. I keep getting the error "Expression is not Valid".

Thanks again for all your help so far.
rebelry
 
Posts: 13
Joined: Tue Jul 08, 2008 4:43 pm

Re: All in preflop

Postby kraada » Sat Oct 11, 2008 5:38 pm

I realize I made a slight typo; if you named everything exactly as I had it you'd want #When All In# = P (note the capital 'i'). You can insert the stat directly by cl icking the blue insert link though and then you will be sure that there isn't a typo.

Basically the idea here is to add the filter for all-in-ness, then you show whatever stats you want in the report by adding them to the report. So you'd want to add hole cards, board, and whatever else suits your fancy . . .
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: All in preflop

Postby WhiteRider » Sun Oct 12, 2008 8:32 am

You'll need to put the P in single quotes..
#When All In# = 'P'
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: All in preflop

Postby rebelry » Sun Oct 12, 2008 3:23 pm

How do I create the custom report? Where is it that I put the #When All In# = 'P'?
rebelry
 
Posts: 13
Joined: Tue Jul 08, 2008 4:43 pm

Next

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

Who is online

Users browsing this forum: No registered users and 0 guests