Can I do this with a custom stat?

[kavonr]

I am evaluating PT3 and it won't allow me to access the Configure Stats section in the trial version. I would like to know how doable a report I will need is. I started with the assumption I would need to build my own table(s) to pre-process some data before building the report. It appears I might be able to use the custom stats and the built-in reporting hence my question.

The report: For each position, I want to compare my hole cards to a group (different for each position) and show some of the stats (VP$IP, PFR etc) when I played cards in the group and when played cards not in the group. I also want to be able to see individual hands and be able to replay them like shown in the POSITIONS TAB (stats by position, hands grouped by hole cards and individual hand detail). I cannot use the built-in definitions of EP, MP as these don't isolate the UTG and I am evaluating each individual position opposite the PT3 way (UTG, UTG + 1, etc).

I did a SQL query to select hands with more than 5 players in the hand, UTG and some pre-defined hole cards. My first question is can I use a custom stat to, for example, set a bool at the player hand level if the following condition is true or set a stat identifying this player hand as a UTG? Many thanks in advance.

Da Old Goat

SELECT holdem_hand_summary.id_hand,holdem_hand_player_statistics.id_hand,holdem_hand_summary.cnt_players,
holdem_hand_player_statistics.id_holecard,
holdem_hand_player_statistics.position
FROM holdem_hand_summary,holdem_hand_player_statistics
WHERE holdem_hand_summary.id_hand = holdem_hand_player_statistics.id_hand AND
holdem_hand_summary.cnt_players > 5 AND
holdem_hand_player_statistics.position = (holdem_hand_summary.cnt_players - 3) AND
(holdem_hand_player_statistics.id_holecard = 1 OR
holdem_hand_player_statistics.id_holecard = 2 OR
holdem_hand_player_statistics.id_holecard = 3 OR
holdem_hand_player_statistics.id_holecard = 4 OR
holdem_hand_player_statistics.id_holecard = 26 OR
holdem_hand_player_statistics.id_holecard = 27 OR
holdem_hand_player_statistics.id_holecard = 49)

[doco]

Are you want to create hand ranges by position? EG. UTG: { AA, KK, QQ, JJ, TT, 99, AKs, AKo }; UTG+1: { ... }, etc. Then compare your current position and pocket cards to those ranges? Not sure custom stats alone would work. Might need to create another table. Sounds like an interesting project - I'll tinker with.

[WhiteRider]

You can add groups of hole cards in the Filters window without creating any custom stats.

You can also add the "Position" stat to your report to split it up my positions if you need a custom report, but the filters will allow you to see your sets of hands in the main reports.

[kavonr]

I have done this with filters and card range selection but there are issues. The main issue is the positions reported are not correct for my purposes. Position 6 is UTG for a 9 player table but is not if there are 10 players. Likewise position 5 is UTG +1 in a 9 player table but is UTG in a 8 player table. How do I select position = cnt_players > 5 AND cnt_players - 3 = position? And of course I'd need 15 reports or so (1 for each position for in set and 1 for out of set) and couldn't cross reference and sub total.

BTW I did see a cnt_players in holdem_hand_player_statistics but it's not in the documentation. It appears to be the same as the value in holdem_hand_summary.

This is not to compare my current position (like to use in the HUD). It's for reporting to identify leaks. It's used to confirm a player changes their opening range base on their position. In my case, I want to compare the set of what I should be opening with against what I actually did and show if success in the no no group or failure in the yes yes group means I should adjust my opening ranges. For example, I have a starting hand chart showing suggested opening cards and it says I should receive these 11% of the time in that position. Did I? (hands in the group for the position / total hands for that position).

For kicks I changed some values of data in the position column to 10, 11, 12 etc. in holdem_hand_player_statistics and the positions tab gave me exactly what I wanted. I suppose if I could just redefine position, saving the PT3 value elsewhere, run my analysis using the existing filters and the position tab, then restore the data that would work. But I prefer not to muck core columns so I can share what I do.

[WhiteRider]

You could certainly make custom stats to split a report into positions like "UTG", "UTG +1", etc. (once you are registered, of course).
Alternatively you could add stats to a report so that you have a line for each combination of number of players and your position.