all in preflop - cash

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 - cash

Postby Blondy » Thu Sep 09, 2010 4:32 am

Hi
Very simple question - how can I filter all hands when we are all-in preflop?
thx
Blondy
 
Posts: 5
Joined: Sat Jan 10, 2009 2:13 pm

Re: all in preflop - cash

Postby WhiteRider » Thu Sep 09, 2010 4:56 am

On the Filters Window there are filters for going all-in on the Actions tab, and for calling all-ins on the Facing tab.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: all in preflop - cash

Postby Blondy » Thu Sep 09, 2010 5:17 am

I use these filters, but I have several hands like this:

shortstacker have 10$ and I have 100$
he raise to 3, I 3bet to 10 (amount he has) and he calls. So we are allin pre, but this hand doesnt qualify for mentioned filters
Blondy
 
Posts: 5
Joined: Sat Jan 10, 2009 2:13 pm

Re: all in preflop - cash

Postby WhiteRider » Thu Sep 09, 2010 6:15 am

Ah yes - you won't be able to filter for that situation at the moment I don't think.
Please create a Support ticket about this, preferably with the hand history for an example hand, and I'll report it to the development team.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: all in preflop - cash

Postby WhiteRider » Thu Sep 09, 2010 6:21 am

You could probably do this in a custom report, though.
If you untick 'Filter on Active Player' in the report filters window and add a custom filter for:

holdem_hand_player_statistics.enum_allin = 'P'

..for all-in preflop, or:

holdem_hand_player_statistics.enum_allin != 'N'
(for not 'none', so they were all in at any point)

..then it should find all the all-in hands.

Tutorial: Custom Reports and Statistics
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: all in preflop - cash

Postby Blondy » Thu Sep 09, 2010 6:42 am

i send support ticket with real hand history example
Thx for custom report - i will try
Blondy
 
Posts: 5
Joined: Sat Jan 10, 2009 2:13 pm

Re: all in preflop - cash

Postby bigblue1ca » Thu Sep 09, 2010 9:12 pm

Somewhat related to this, is there a HUD stat for 3Bet Preflop All-in%? Meaning out of the times they 3Bet, who many time do they shove AI. I think such a stat would be great to help differentiate fish who buy in small, from short stackers who's only game is to 3Bet shove AI. I looked through the stat list an I couldn't find something like this, perhaps I missed it though. The closest I found was 3 stats AI Flop, Turn, River.
bigblue1ca
 
Posts: 14
Joined: Tue Sep 29, 2009 7:45 pm
Location: Canada

Re: all in preflop - cash

Postby WhiteRider » Fri Sep 10, 2010 4:20 am

There isn't a built-in stat for that but you could make a new version of the 3-bet stat and include a check for:
holdem_hand_player_statistics.enum_allin = 'P'

See the Tutorial: Custom Reports and Statistics for a walkthrough of building a new version of a stat.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: all in preflop - cash

Postby bigblue1ca » Fri Sep 10, 2010 12:04 pm

Thanks, I've never created a custom stat, this looks the like the perfect opportunity to learn how.
bigblue1ca
 
Posts: 14
Joined: Tue Sep 29, 2009 7:45 pm
Location: Canada

Re: all in preflop - cash

Postby WhiteRider » Fri Sep 10, 2010 1:04 pm

It's well worth the effort of the initial learning curve - it really opens up the possibilities of PT3.
If you get we're here to help - post what you've got so far and we'll help you out.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 0 guests