Average Stats of all Players?

[Jonko]

I got a question:
I want to figure out the perfect raising range from each position at the table. To do this I have to know the average stats of all players which I played with.
Where can I see it in Pockertracker 4?
Jonko

[WhiteRider]

Please post PT4 questions in the PT4 section of the forum to ensure the most accurate answers.

You can see a list of all players in the Results > Player Summary report, and you can add other stats to that (right-click > Configure Report).

Alternatively, go to the "My Reports" page and create a new "All Players" report.
This will give you a list of all players and you can add whatever stats you like to the report.
If you remove the "Player" [name] stat from the report it will show combined stats from all players in a single line.

[Jonko]

Thank you.
Now given that I have the stats of all players, I recognized that I dont have a idea how to figure out the most profitable raising range against opponents who have VPIP 20.
Does anyone have a idea for this?
Jonko

[nbiresev]

Hi,

How do you calculate average stats of all players? For example, if I am looking for 3bet stat preflop, is it calculating average 3bet stat for all players by summing the 3bet stats over all players and deviding by number of players, or is it calculating using number of hands and threating all players as one player? If it is the second one, than it will be the case that HERO is dominating the stat because he has the most hands.
I am asking this because I created all players report, deleted player name, and then it shows me average stats for all players, and then when I put a mouse above 3bet stat it shows me 10% and number of occurances of 3bet which is very large, so it looks to me that it actually threats all players as one and calculates 3bet stat which is in my opinion not accurate (at least not what I need).

[name14]

Jonko, VPIP 20 is not enough since it's hardly the top-20% percent of hands
U need to know the exact hands to do that

[WhiteRider]

You can eliminate hero's stats from your report using a filter.
Add the filter Hand Details > Player Is Hero and then on the current/active filter page select it and click 'NOT' Selected at the bottom to negate it.

[nbiresev]

Ok, I managed to do it and stats are already without hero a lot different as I suppoused, hero is biasing the stats significantly.
Beside hero, also the players (regulars) from whom I have the most stats are also effecting the stats in the same way as hero, which means that my
average stats will be close to regular stats, instead of being close to average player stats (simple example, I have total 10k hands from 5 regulars, and only 1k hands from 100 other players (fish), which will mean that the average stats are the average from those 5 players which is totally wrong).

1)
So in order to have more realistic results, I would need stats for each player devided by the total number of all players. Also, I would like to set the threshold to account only
players who have more than X number of hands (to have enough sample size).

2) Another thing which I need is to select only players having certain stat (e.g. VPiP > 40%) and then have average player stats for those players

[WhiteRider]

If you add the Player stat back into the report you'll see each player on a separate line (but you'll still see the totals in the summary line) and you can then filter for players as yous suggest. Click the blue Filters link and choose 'expression filters'.
You can filter for number of hands using a filter like:
#Hands# > 1000
..and VPIP like this:
#VPIP# > 40

[nbiresev]

Ok, it all works, it is great!
Just a positive feedback, yesterday I tried to do similar thing in holdem manager, they have so many options for filters but it is very hard to find options you need, so I like it much more in
pt4. Good job!

[nbiresev]

Just to report bug, when I set expression filter #Hands# > 200
and then removed Player_name stat, then the sql error showed
"Unable to execute query SELECT ... ", over the whole Report.

I guess, when I remove stat Player_name, it should remove all expressive filters.