Two Plus Two Publishing LLC
Two Plus Two Publishing LLC
 

Go Back   Two Plus Two Poker Forums > >

Notices

Heads Up SNG and Spin and Gos Discussion of heads up Sit & Go and Spin and Go poker games. Sponsored by HUSNG.com, the leading heads up poker video site.

Reply
 
Thread Tools Display Modes
Old 05-12-2016, 12:55 AM   #101
_dave_
_Pooh_Bah_
 
Join Date: Feb 2005
Location: UK (or what remains of it)
Posts: 13,083
Re: Help - Using PT4 to analyse population tendencies

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.
_dave_ is offline   Reply With Quote
Old 05-12-2016, 08:02 AM   #102
bettinglife
journeyman
 
Join Date: Nov 2011
Location: Portugal
Posts: 246
Re: Help - Using PT4 to analyse population tendencies

Quote:
Originally Posted by _dave_ View Post
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.
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
bettinglife is offline   Reply With Quote
Old 07-31-2016, 03:44 AM   #103
Falcore
newbie
 
Join Date: Oct 2015
Posts: 24
Re: Help - Using PT4 to analyse population tendencies

Quote:
Originally Posted by _dave_ View Post
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.
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
Falcore is offline   Reply With Quote
Old 07-31-2016, 06:55 AM   #104
_dave_
_Pooh_Bah_
 
Join Date: Feb 2005
Location: UK (or what remains of it)
Posts: 13,083
Re: Help - Using PT4 to analyse population tendencies

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

https://forumserver.twoplustwo.com/18...y-hem-1212650/
_dave_ is offline   Reply With Quote
Old 10-31-2016, 08:19 PM   #105
Apollonia
stranger
 
Join Date: Aug 2015
Posts: 3
Re: Help - Using PT4 to analyse population tendencies

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?
Apollonia is offline   Reply With Quote
Old 10-02-2018, 08:19 PM   #106
rowhousepd
grinder
 
rowhousepd's Avatar
 
Join Date: Jun 2009
Location: Philadelphia, PA
Posts: 630
Re: Help - Using PT4 to analyse population tendencies

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.
rowhousepd is offline   Reply With Quote
Old 07-27-2020, 07:12 AM   #107
Harambee
journeyman
 
Join Date: Nov 2016
Posts: 281
Re: Help - Using PT4 to analyse population tendencies

Anyone successfully done this for full-ring MTTs?
Harambee is offline   Reply With Quote
Old 07-28-2020, 07:16 AM   #108
Mike Litoris
centurion
 
Join Date: Aug 2009
Posts: 137
Re: Help - Using PT4 to analyse population tendencies

Quote:
Originally Posted by Benjamin the Donk View Post
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).
Mike Litoris is offline   Reply With Quote
Old 08-01-2020, 05:27 PM   #109
Mike Litoris
centurion
 
Join Date: Aug 2009
Posts: 137
Re: Help - Using PT4 to analyse population tendencies

Quote:
Originally Posted by Mike Litoris View Post

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 View Post
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
Mike Litoris is offline   Reply With Quote

Reply
      

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Forum Jump


All times are GMT -4. The time now is 01:10 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2008-2017, Two Plus Two Interactive
 
 
Poker Players - Streaming Live Online