Report for Stack size range for each position?

[Zangeeph]

I'm new to pokertracker . I want to create a tournament report where I could specify the stack each position has and get the result for a given position. for example I would want to return the average stats of the small blind when the stacks are the following:
Button 1000 to 3000, SB 1345 to 1942 and BB 500 to 800.
So it would return the stats of only the small blind when all the 3 players have stacks in those ranges. But in the example I would like it to ignore hands where hero was the small blind with those stack sizes - I am more interested in opponents statistics and don't want my stats mixed in with villains. Is this possible with pokertracker?

[kraada]

This is possible, just tricky to set up from scratch.

You'll want to be doing it in the custom reports - are you going to be trying to look at overall stats (VP$IP, WTSD) in these kinds of spots or do you want to review individual hands when these situations occur?

[Zangeeph]

This is possible, just tricky to set up from scratch.

You'll want to be doing it in the custom reports - are you going to be trying to look at overall stats (VP$IP, WTSD) in these kinds of spots or do you want to review individual hands when these situations occur?

I want to look at overall stats. I don't want to review individual hands.

Ages ago I made a program in python which would do this for me but it was very slow (it just parsed all the text files... terrible I know) but I lost it. I figured that pokertracker could do this much more effectively.

[kraada]

You can add filters like this in the custom reports (this sounds like a tourney report so I've presumed this is for tournaments) in the player statistics section:

tourney_holdem_hand_player_statistics.id_hand in (SELECT thhps.id_hand from tourney_holdem_hand_player_statistics thhps, tourney_holdem_hand_player_detail thhpd where thhps.id_hand = thhpd.id_hand and thhps.position = X and thhpd.amt_before BETWEEN Y and Z)

X is the position number (0 = button, 1 = cutoff . . . 8 = BB, 9 = SB always), Y and Z are the stack sizes you'd want.

You can add more than one of these and they will work together properly.

[Zangeeph]

This filter isn't working properly. It seems to be using effective stacks instead of actual stacks. In a tournament where the total chips is 9000, I have the filter "with 2 players" on, when I use the filter with the values as

tourney_holdem_hand_player_statistics.id_hand in (SELECT thhps.id_hand from tourney_holdem_hand_player_statistics thhps, tourney_holdem_hand_player_detail thhpd where thhps.id_hand = thhpd.id_hand and thhps.position = 9 and thhpd.amt_before BETWEEN 3000 and 4000)

It returns the same hand data as when I use the filter

tourney_holdem_hand_player_statistics.id_hand in (SELECT thhps.id_hand from tourney_holdem_hand_player_statistics thhps, tourney_holdem_hand_player_detail thhpd where thhps.id_hand = thhpd.id_hand and thhps.position = 9 and thhpd.amt_before BETWEEN 5000 and 6000)

(changes in bold). I dont want it to do this but I'm unsure of a way to change it.

[WhiteRider]

That doesn't seem to be filtering at all - I get the same results whether I add the filter or not. Kraada isn't around for a few days and I can't see why that isn't working, but I'll try to find out for you.

[WhiteRider]

I think we'll need to see what Kraada says when he gets back from his vacation. I'll make sure he sees this thread.

[kraada]

That is odd - what's the stack size of the player on the button in one of the hands getting returned by the filter? Are any hands getting filtered out?

[Zangeeph]

It's filtering out many hands. It's behaving in a very unpredictable and strange way. Filtering for between X and Y returns the same hands as when filtering for between totalchips-Y and totalchips-X. Also, they are in some cases not working together properly when I use more than one. I can input three of the filters for between 2800 and 3200 for position 8, between 2800 and 3200 for position 9, and between 4000 and 8000 for position 0. This should return 0 hands (because the total chips is 9000 and 2800+2800+4000 > 9000) but it isn't.

[Zangeeph]

Is there a way to see the hands in the report in a replayer so I could see where its going wrong? I feel like I'm working in the dark as I don't know how its going wrong. Not being able to see the hands its returning is a really big problem for me as I'm struggling figure out what the problem is.