Creating a report to filter for play vs specific players

[pt4pt4pt4]

Would this work:

Quick Filters for specific situation.

Tag all displayed hands

Export all Tagged hands

Create another DB

Import only tagged hands

Run report with this filter

[kraada]

That could work yes.

[pasita]

Im still coming back to this. I could manually go through all of certain situations in the hand replayer and then write down the numbers but it seems crazy. It should be done automatically. The replayer shows the HUD stats as they were at the time of the play. It takes about a second for the HUD to appear. So going through a thousand hands shouldnt take no more then 15 minutes. Even if the stats are not cached.

You should probably learn to use PGadmin (comes with postgres) and run the queries from there... you can run several queries at the same time, go to the gym, come back to see the results and save them for later refererence. I did that to figure out my winrates when I'm sitting x seats away from a fish, where 'fish' was defined by some set of preflop stats and a minimum hand count. (OK I didn't do the gym part.)

EDIT: Oh and you can come of with some type of data considerably faster than querying via PT... those queries are tied to the way the queries are generated, if you throw in an extra join manually it can shorten the time VERY much. Not sure about the examples given here.

[Darvini]

Would this work:

That sounds like an improvement to manual so thank you.

You should probably learn to use PGadmin (comes with postgres) and run the queries from there... you can run several queries at the same time, go to the gym, come back to see the results and save them for later refererence. I did that to figure out my winrates when I'm sitting x seats away from a fish, where 'fish' was defined by some set of preflop stats and a minimum hand count. (OK I didn't do the gym part.)

EDIT: Oh and you can come of with some type of data considerably faster than querying via PT... those queries are tied to the way the queries are generated, if you throw in an extra join manually it can shorten the time VERY much. Not sure about the examples given here.

Can you give an example of a simple PGadmin query and perhaps a little hint of direction from there? Ill go to the gym while waiting for your answer =)

[pasita]

here's a very simple one:)

Code: Select all

select * from player

[pasita]

To give some more complicated info:
anything that you put in a custom column (when building a stat) goes to the SELECT part of that query. (i.e. replacing the * from my example). PT4 adds the FROM part and a WHERE part, which is used to restrict the data you receive.

If you have logging enabled: start PT4, open replayer so a hud is opened OR run a report, open pokertracker.log, scroll to the bottom. You'll find the queries that generated the data you see in PT4.

EDIT: Breaking a sweat yet?

[Darvini]

Where would I write this code and how would I run it? Can you give an example of a simple query I can actually do to see the results? If I have a working model I can start from there and explore, but if I dont Im completely in the dark.

[pasita]

-start pgadmin (it's installed somewhere in your postgres installation if you're on windows)
-connect to your server
-connect to your database
-click the SQL button (looks like a magnifying glass in my installation)
-type in the sql query
-press F5

The connect parts from above are just clicking the correct graphical element.. you may need to enter a password or something on the first start though.

[simpsp31]

Have downloaded the 3 bet matrix reports and been playing around with them. I have added in a couple of stats eg call BB v SB, Call BB vs BTN could you confirm that this will give correct information ie it is showing how often the active player is calling heros SB or BTN open ?