My image in opponent's eye

General discussion of PokerTracker 3.

Moderator: Moderators

My image in opponent's eye

Postby vpmarat » Thu Dec 02, 2010 5:50 am

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?
vpmarat
 
Posts: 30
Joined: Tue Nov 10, 2009 2:25 pm

Re: My image in opponent's eye

Postby kraada » Thu Dec 02, 2010 10:08 am

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.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: My image in opponent's eye

Postby PHJJR » Fri Dec 03, 2010 8:37 pm

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.
PHJJR
 
Posts: 47
Joined: Fri May 16, 2008 11:37 am

Re: My image in opponent's eye

Postby WhiteRider » Sat Dec 04, 2010 4:40 am

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'))
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: My image in opponent's eye

Postby PHJJR » Sat Dec 04, 2010 11:32 am

( 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
 
Posts: 47
Joined: Fri May 16, 2008 11:37 am

Re: My image in opponent's eye

Postby WhiteRider » Sat Dec 04, 2010 11:38 am

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
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: My image in opponent's eye

Postby PHJJR » Sat Dec 04, 2010 11:56 am

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
PHJJR
 
Posts: 47
Joined: Fri May 16, 2008 11:37 am

Re: My image in opponent's eye

Postby WhiteRider » Sat Dec 04, 2010 12:24 pm

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.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: My image in opponent's eye

Postby sfifield » Sat Feb 11, 2012 5:32 pm

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.
sfifield
 
Posts: 31
Joined: Sun Apr 04, 2010 4:24 pm

Re: My image in opponent's eye

Postby WhiteRider » Sun Feb 12, 2012 1:40 pm

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')
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to General [Read Only]

Who is online

Users browsing this forum: No registered users and 14 guests

cron