PokerTracker

how can I see stats for me from opponent's point of view?
Let's say I played 10K hands (and from them only 500 hands with one guy). How to see MY stats in HIS hud?

You can't do that at this point in the HUD, but you could do that as a custom report.

Go to the Reports tab, and in the Holdem Cash Player Statistics section create a new report. Add whatever stats you want to see. In the blue Filters link make sure filter on active player is on, and add the following filter and save it:
holdem_hand_player_statistics.id_hand in (SELECT distinct hhps.id_hand from holdem_hand_player_statistics hhps, player p where p.id_player = hhps.id_player and p.player_name = 'Villains Name Here')

Replace Villains Name Here with the name of your villain. Note that you do need the single quotes. Save and run your report and you'll see your own stats only from hands in which Villain was dealt in.

Kradda I know we have been thru this b4 but has anyone come up with a way to do this using "villain" as active player?
Also I would like to see this for tourneys as well as cash.

You can use a filter like the one described in this post - just remove the check for first raise.

holdem_hand_player_statistics.id_hand in (SELECT hhps.id_hand from holdem_hand_player_statistics hhps where hhps.id_player = (SELECT setting_value::int from settings where setting_name = 'my_player_id'))

( 0 < (SELECT count(hhps2.id_hand) FROM tourney_holdem_hand_player_statistics hhps2 WHERE hhps2.id_hand = tourney_holdem_hand_player_statistics.id_hand AND hhps2.id_player = (SELECT setting_value::int from settings where setting_name = 'my_player_id'))
)

WR this is a filter that does not work properly. It appears the only difference is the "hhps2" vs "hhps"
This filter return the filtered players stats not my stats when Im in hand with player..

EDIT Pulling my hair out now nothing is working I may be putting my player Id in wrong place. AM substituting my player id for "my_player_id" also is the single quote mark (apostrophe ') critical here?

PHJJR wrote:Kradda I know we have been thru this b4 but has anyone come up with a way to do this using "villain" as active player?

I thought you wanted to select an opponent and see their stats when you were in the hand?

WhiteRider wrote:

PHJJR wrote:Kradda I know we have been thru this b4 but has anyone come up with a way to do this using "villain" as active player?

I thought you wanted to select an opponent and see their stats when you were in the hand?

This is possible without a custom report unless I have a bunch of datamined stats. Just set him as active player and look at positions tab. as welll as others.
No I want to see " my" stats when I am in the hand with villian.
But now cant get anything to work unless i leave the 'my_player_id' just like that. Then I get active player stats.
Zeros when I substuite my player id

If you want to see your own stats then you need to set yourself as the active player and use the filter that kraada gave you at the start of this thread. If you set another player as active then you will see their stats.

kraada wrote:You can't do that at this point in the HUD, but you could do that as a custom report.

Go to the Reports tab, and in the Holdem Cash Player Statistics section create a new report. Add whatever stats you want to see. In the blue Filters link make sure filter on active player is on, and add the following filter and save it:
holdem_hand_player_statistics.id_hand in (SELECT distinct hhps.id_hand from holdem_hand_player_statistics hhps, player p where p.id_player = hhps.id_player and p.player_name = 'Villains Name Here')

Replace Villains Name Here with the name of your villain. Note that you do need the single quotes. Save and run your report and you'll see your own stats only from hands in which Villain was dealt in.

Can this be done in PT4? I tried importing this custom report from PT3, but the formula doesn't work in PT4.

The database structure has changed a little in PT4, so you need to replace "holdem_" with "cash_", like this:

cash_hand_player_statistics.id_hand in (SELECT distinct hhps.id_hand from cash_hand_player_statistics hhps, player p where p.id_player = hhps.id_player and p.player_name = 'Villains Name Here')