Help finding a sepcific hand

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

Help finding a sepcific hand

Postby Tor Ktall » Wed Jan 27, 2010 9:25 pm

I could use some help trying to drill down a specific I hand I played in the last month.
Since I have in excess of 15,000 hands in that time frame (a small number, I know) it is like finding a needle in a hay stack for this very specific hand.

I understand that my first step would be to limit myself to a few facts I know
1 - it was a tournament
2 - it was on a specific site
3 - it happened in the last 30 days

Those three filters are pretty easy to setup. Here comes the tricky part:
4 - I know that I didn't play the hand (was delt cards but didn't play them)
5 - I know that the hand did not go to a flop
6 - I know that there was at least one raise and a reraise, but there may have been a raise, reraise, and another reraise (but I don't think this is the case).
7 - The final raiser won, but with a exceptionally small raise (I beleive it was less than the required min raise, if memory serves it was only 35 chips).


After trying to find this hand a few different ways, it dawned on me that what I was trying to build was a filter that could point out an apparent chip dumping situations, NOT all cases like these are chip dumping. For my personal knowledge I would like to be able to know if some players are so week that they would fold to a 3rd or 4th bet even when the math says they must call (aka the price is right to play with any two cards).I understand that third and fourth bet statistics already exist, I'm not look to re-invent that wheel.

I think the biggest issue I'm having in building the filter set myself is that I am compairing actions of other people at the table to each other with out knowing their names to do comparisons from their persepctive (selecting one of them in the list and then applying a folded to third bet filter). The only personal action I can compair against is that I chose NOT to V$IP (unless I was the initally raiser in a 4bet preflop scenario). The fact that their should be no flop is something I should be able to setup but have failed to do this.

I know there are lots of someones that have more skill at this filter business than I do and any help would be appreciated in building a filter to find this hand.


Summary:
I'm looking for a filter that says a player V$IP (via a raise) and then folded to a min-raise or less, when that players betting and folding are not me (though I could on either side of that equation, I guess... but if I was I think I could have found those hands).


Disclaimer: I do not have a large enough data set of any player besides myself to truelly tell if someone is cheating via chip dumping (stuff I don't know about them in these instances: their hole cards, their mind set on an attempted steal, if they have a read on another player, or another player has a read on them and made a cood counter move). At this time I am not accusing anyone of cheating. I will assume they are just making really bad plays.

~ TK
Tor Ktall
 
Posts: 1
Joined: Wed Jan 27, 2010 8:42 pm

Re: Help finding a sepcific hand

Postby WhiteRider » Thu Jan 28, 2010 6:33 am

It may be possible to do something like this in a custom report in the Holdem Tournament Hands section, using a custom filter on the difference between the existing column "amt_bet_p" and a new column for the size of the raise faced using the database field "tourney_holdem_hand_player_detail.amt_p_raise_facing".
I'll have a play around with this and let you know, but feel free to experiment yourself: Tutorial - Custom Reports and Statistics.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Help finding a sepcific hand

Postby WhiteRider » Thu Jan 28, 2010 4:24 pm

OK, I think this is actually fairly straightforward to add now that I've worked it out.
If you create a new column in the Holdem Cash Hand section like this:
val_p_raise_facing_pct =
holdem_hand_player_detail.val_p_raise_facing_pct
..this will hold the size of the last raise a player faced preflop, as a percentage of the pot.

We can then use that column as a filter in a custom report (again in the Holdem Cash Hand section), like this:
holdem_hand_player_detail.val_p_raise_facing_pct < 10
This will only display hands where a player faced a final raise of less than 10% of the pot - you may want to tweak this number, of course - I've just picked a number.
You will also then want a simple filter for folding preflop - I've chosen to use Fold to 3 Bet Preflop OR Fold to 4 Bet Preflop so that only hands where a player folded to a 3 or 4 bet (or higher) will be included. I've also added filter for VP$IP so that we don't get hands where the player folds immediately but the pot is huge from 2 min raises and lot of callers, although this sort of case is pretty rare at NL tables I guess so you may not feel the need.

I have attached my version of the report (zipped) - save the attached file and extract the .pt3rpt file from it then import it to the Cash Games > Reports tab. This will import the custom column needed too.
Attachments
Fold to small raise PF.zip
(1.46 KiB) Downloaded 88 times
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