PokerTracker

I'm sure its been asked and I'm sure its a simple step I'm not seeing, but I can't figure out how to run a report to show my stats vs a specific player OR specific player vs me. I don't see any type of filter for this. This is for HU analysis only.

Are you using PT3 or PT4?

WhiteRider wrote:Are you using PT3 or PT4?

Sorry. PT4

You can do that with a custom report filter.
Go to My Reports and create a new Player report.
Click the blue Filters link and select 'expression filters' and paste this in:

( 0 < (SELECT count(hhps.id_hand) FROM tourney_hand_player_statistics hhps WHERE hhps.id_hand = tourney_hand_player_statistics.id_hand AND hhps.id_player = (SELECT p.id_player FROM player p WHERE player_name='VillainName')) )

..and replace 'VillainName' with the name of the player you're interested in. This will show your stats (specifically, the stats of the active player - the one selected in the player list) in hands where this villain was dealt in.
This is a tournament filter - if you play cash replace tourney_ with cash_.

This works excellent. But when you want to look at your stats vs a player who has a name that is used on multible sites, then it doesnt work. It could easily be different players that has those names.

How can I solve that problem?

If the same player is playing multible sites with same screen name, then I could create an alias. But it will not work either unless I can change the alias name to something unique. How do I do that?

You can narrow it down to a specific site by adding p.id_site = X where X is the site identifier. So for example:

( 0 < (SELECT count(hhps.id_hand) FROM tourney_hand_player_statistics hhps WHERE hhps.id_hand = tourney_hand_player_statistics.id_hand AND hhps.id_player = (SELECT p.id_player FROM player p WHERE p.id_site = 100 and p.player_name='VillainName')) )

would restrict it to PokerStars only.

So if I understand this correctly p.id_site = 100 is pokerstars
Where can I find id numbers for the different poker sites?

Just a quick one please. How often do these codes get updated?

They are not changed - they're only added to if a new site is added to PokerTracker.