Help - Using PT4 to analyse population tendencies - Page 5 - Heads Up SNG and Spin and Gos -- Two Plus Two Poker Forums

No. This method relies on the fact that opponents are never playing each other, which in 3+ handed games they do all the time.

You can get simple global averages etc with an "all players" report, add NOT(hero) to the simple filters to stop yourself distorting the results.

For actual global alias, HEM is the tool of choice.

Quote

05-12-2016 , 08:02 AM

#102

bettinglife

journeyman

Join Date: Nov 2011 Posts: 246

Quote:

Originally Posted by _dave_

Thanks man, I already can do it in reports, but my goal would be to see in the range visualizer to actually know what type of ranges they 3bet polarized.

So do you think HEm has that option?

Thank you

Quote

07-31-2016 , 03:44 AM

#103

Falcore

newbie

Join Date: Oct 2015 Posts: 24

Quote:

Originally Posted by _dave_

Hey Dave, I have been going over this post trying to find a way to do this for 6max in PT4, but it seems the conclusion was that this is possible but only in HEM. I currently have only HEM1 and PT4-is there a way to do this with HEM1 or would I need an upgrade? Either way could you point me to threads on this? Can't seem to find any instructions anywhere. Thanks

Quote

07-31-2016 , 06:55 AM

#104

_dave_

_Pooh_Bah_

Join Date: Feb 2005 Posts: 13,146

Here's the HM1 thread (with lots of PT4 mixed in too, not ideal for clarity)

http://forumserver.twoplustwo.com/18...y-hem-1212650/

Quote

10-31-2016 , 08:19 PM

#105

Apollonia

stranger

Join Date: Aug 2015 Posts: 3

Is there a way to do it for Spin&Gos?
It would be nice enough if it would be possible to filter-out all the 3-handed play and just show the population tendencies for heads up. Unfortunatly it is not possible to only export the heads up hands in PT4. Is there a way to do this?

Quote

10-02-2018 , 08:19 PM

#106

rowhousepd

grinder

Join Date: Jun 2009 Posts: 651

I think I got this to work for both PT4 and HM2 after reading the instructions above. Yay!

This may be a dumb question, but how exactly are you reviewing this data in PT4 to evaluate general population read-less tendencies? I'm mean specifically within the software, are you running reports for specific scenarios and looking at the Hand Range Visualizer? Are you looking at the various reports in the Statistics section? If so, which ones? I guess I'm just confused about how an alias will tell you about tendencies that you can't, for instance, figure out by looking at Results > Player Summary.

Quote

07-27-2020 , 07:12 AM

#107

Harambee

journeyman

Join Date: Nov 2016 Posts: 361

Anyone successfully done this for full-ring MTTs?

Quote

07-28-2020 , 07:16 AM

#108

Mike Litoris

centurion

Join Date: Aug 2009 Posts: 143

Quote:

Originally Posted by Benjamin the Donk

It Works!!!

Very special thanks to _dave_ who sorted this out for me. I am not much goodness with das computermachines talky language

So how to do it:

backup your database!
in PT4 you need to export all of your HUSNG hands to hand history files. This is because it is difficult to filter the SQL command for HUSNG only and it won't work if there are hands with >2 players at the table. You can do this in Database -> export hands -> advanced -> tournament, and select HU tourney's
create a new DB in PT4. Database ->Database management -> new. Name it something nice, like "all villains" or "general population". when working with data later, if it doesn't look right you may have the wrong database active
make the new database active in database management
import your exported hands into the new database, you now have a HUSNG only db!

Now, to create an alias for all villains in SQL:

open up PostgreSQL admin (pgadmin III in start menu)
doubleclick PostgreSQL DB... on left to open it up
click on your new db and click +
+ schemas
+ public
+ tables
left click player -> view data -> view all rows
scroll to the bottom and note the last player name and the number in the id_player column (2nd from left, not the number in bold)
go back to the main pgadmin III screen and click the "execute arbitrary SQL queries" button (SQL note with pencil graphic)
enter this code:

Code:

UPDATE tourney_hand_summary SET id_winner = 1446 WHERE id_winner != 1 AND id_winner != 0 AND id_winner != -1;
UPDATE tourney_hand_player_statistics SET id_player = 1446 WHERE id_player != 1 AND id_player != 0 AND id_player != -1;
UPDATE tourney_hand_player_combinations SET id_player = 1446 WHERE id_player != 1 AND id_player != 0 AND id_player != -1;
UPDATE tourney_summary SET id_winner = 1446 WHERE id_winner != 1 AND id_winner != 0 AND id_winner != -1;
UPDATE tourney_results SET id_player = 1446 WHERE id_player_real != 1 AND id_player_real != 0 AND id_player_real != -1;
UPDATE player SET id_player_alias = 1446 WHERE id_player != 1 AND id_player != 0 AND id_player != -1;

replace all "1446" with the last player_id number from the player table. This will set your player alias as the last player in your DB
click "execute query" (green arrow)
you should not have any errors down the bottom
now it should be done. Open up PT4 and make sure your new db is the active one. It will usually default to your normal database.
under the player drop down menu, select "choose new player" and type in the last player name in the player_id table from earlier.
that should be it, look at the holdem heatmap and start messing around with filters to see what the average villain does!

Enjoy

Dave will hopefully have a look at this and check for any errors, I think I've got it right though.

thats quiete a big surgery

whats the advantage of this method compared to creating an all player report and excluding Hero (NOT Player is Hero).

Quote

08-01-2020 , 05:27 PM

#109

Mike Litoris

centurion

Join Date: Aug 2009 Posts: 143

Quote:

Originally Posted by Mike Litoris

whats the advantage of this method compared to creating an all player report and excluding Hero (NOT Player is Hero).

Quote:

Originally Posted by Benjamin the Donk

You can do something similar to this without going to all the trouble (see my first post in the first thread linked to above), however you can't use things like the starting hands visualiser which imo makes things that much easier.

Source

Quote

09-09-2021 , 12:06 PM

#110

skyl1ne

newbie

Join Date: Sep 2012 Posts: 20

Quote:

Originally Posted by Benjamin the Donk

You may also be able to exclude the regs 'player numbers' from the code when creating the population DB in this step:

Code:

UPDATE tourney_hand_summary SET id_winner = 1446 WHERE id_winner != 1 AND id_winner != 0 AND id_winner != -1;
UPDATE tourney_hand_player_statistics SET id_player = 1446 WHERE id_player != 1 AND id_player != 0 AND id_player != -1;
UPDATE tourney_hand_player_combinations SET id_player = 1446 WHERE id_player != 1 AND id_player != 0 AND id_player != -1;
UPDATE tourney_summary SET id_winner = 1446 WHERE id_winner != 1 AND id_winner != 0 AND id_winner != -1;
UPDATE tourney_results SET id_player = 1446 WHERE id_player_real != 1 AND id_player_real != 0 AND id_player_real != -1;
UPDATE player SET id_player_alias = 1446 WHERE id_player != 1 AND id_player != 0 AND id_player != -1;

and just add on a WHERE id_winner != 'reg1 player number' AND id_winner != 'reg2 player number' etc. for each line in the code above. (i.e. use id_player for line 2...)

I know nothing about SQL so maybe someone else can comment.

Did anyone try excluding regs?

Quote

Page 5 of 5

First

1 2 3 4 5

Last

Post Reply Subscribe

...

Page 5 of 5

First

1 2 3 4 5

Last