Page 1 of 4

Creating an alias for all HUSNG villains

PostPosted: Fri Jun 08, 2012 7:07 am
by benharvey
Hi guys,

I would like to analyse the population tendencies for all villains I play in hyper turbo heads up sit and go's. I assume the best way to do this is by creating a custom alias for all villains and going from there?

Is there a way to do this quickly without adding villains from cash and MTT's etc?

Thanks

Re: Creating an alias for all HUSNG villains

PostPosted: Fri Jun 08, 2012 9:03 am
by kraada
Unfortunately there is no functionality to expedite this kind of thing. What you could do though is create a custom report on the My Reports page that doesn't filter to active player, but does filter to HUSNGs and filters yourself out - then you'll see data on all players who are not you and, given the tournament structure, therefore played you.

You can do this by adding the following filter in the blue Filters link:

player.player_name != 'Your Screen Name'

Note that you do need the single quotes around your screen name for this purpose.

Re: Creating an alias for all HUSNG villains

PostPosted: Fri Jun 08, 2012 9:45 am
by benharvey
Thanks. That was easier than I expected.

Is there any way I can get them into the holdem hand range visualiser like that? Then I can analyse shoving/calling/3betting/etc frequencies with a little more accuracy than 3bet = 15%. I have a feeling that something like this may require an alias...

Thanks again

Re: Creating an alias for all HUSNG villains

PostPosted: Fri Jun 08, 2012 10:54 am
by kraada
The Visualizer only shows data based on the current active player, so there's no easy way to get it into the Visualizer, but if you add the Hole Cards stat to the report it will break the report down into one line per pair of holecards. It's not as pretty as the visualizer, but it will show you the same data.

Re: Creating an alias for all HUSNG villains

PostPosted: Sun Jun 24, 2012 12:50 am
by benharvey
Hey thanks for your help before. I've been messing around in PostGreSQL with some help from some more computer literate people, trying to create an Alias for all players apart from hero (again for heads up population tendencies)

So far I have:

Created an alias with a villain selected at random (the villain is number 5724 in my DB)
Gone into SQL and entered this code:

Code: Select all
UPDATE player
SET id_player_alias = 5724
WHERE id_player != 1 AND id_player != -1 AND id_player != 0 AND id_player != 5724
;


player 1 is me, -1 is "no low winner" (not sure what that is), 0 is "split pot" and 5724 is the player that will be the alias.

So I go back into PT4 and all of the players are in the alias as expected (see attached screenshot), however there are only 13 hands showing. I think these are the hands that were in the original profile of player 5724 (actual name is 0AA0 as in the screenshot).

Are you guys able to help with this or is it beyond PT4 as I'm working with the database directly in PostGreSQL?

Re: Creating an alias for all HUSNG villains

PostPosted: Sun Jun 24, 2012 5:56 am
by WhiteRider
Adding an alias does much more than just change that reference field - it combines the stats for all the players aliased. Effectively all the aliased players are removed from the database, leaving on player with combined stats. (This process can be undone, of course.)
This would mean that when you actually play you'd see opponent stats in the Hud for all of your opponents combined (when you play one of the names which was aliased), which I'm sure isn't what you want.

There are better ways to see population stats.

For example the Results > Player Summary report lists all players.
This does include your names, but you can remove those by clicking More Filters > Hand Details > Player is Hero, then Add to Filter. In the Current/Active Filters page click on (Player is Hero) and then click 'NOT' Selected at the bottom, and click Save & Apply Filters. This will filter out all of your stats.
The Summary row at the bottom of the report shows population totals.

You can do a similar thing in the My Reports page with a new All Players Report.

Re: Creating an alias for all HUSNG villains

PostPosted: Sun Jun 24, 2012 6:43 am
by benharvey
Yes I understand that, I plan on making an alias so that I can see stats like I see my own - it's much easier to work with then.

As for the hud, I have just been backing up my DB then messing around with SQL, then restoring the DB after I am finished so no damage done :)

This explains why you can't look at an individual player if they are part of an alias then, as the individual player "no longer exists" in the DB (although can be put back as you say).

I have messed around with the reports as you mentioned earlier, filtering out my name from the results, however I think that it is better to be able to work with the population data as I can work with my own.

Thanks anyway for your help, I know this isn't exactly a routine enquiry.

Re: Creating an alias for all HUSNG villains

PostPosted: Sun Jun 24, 2012 6:52 am
by WhiteRider
If you really want to combine all players as aliases then the best thing I can suggest is that you add an alias normally within PT4 and then look at the PokerTracker4.log file from C:\Users\yourname\AppData\Local\PokerTracker 4\ (which you can access from the PT4 File menu) to see what queries are done. It's pretty complex, though, and for everything to work you'll need to do every step exactly right. As long as you're working with a copy of your database it's fine to experiment of course, but I would expect there to be a lot of work involved, and you may actually find it faster to pick a set of players with the most hands and alias them manually within PT4.

Re: Creating an alias for all HUSNG villains

PostPosted: Sun Jun 24, 2012 7:44 am
by benharvey
ok thanks again :)

Re: Creating an alias for all HUSNG villains

PostPosted: Wed Jun 27, 2012 12:58 pm
by tigerjack89
Well, I think the PT4 alias is the correct way to think of an alias.
But maybe, it should be possible to create one more simple table, like 'Group Player', and then make possible to add different players to every groups.
IE, you may want to create a group for 'Fish', another one for 'Regs', another for 'HU regs' and so on. Then, you can treat every group such as a single player, without removing players from database.

I don't know if it requires a lot of work, but it would be a great future.