Question - Average opponent steal % by position

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Question - Average opponent steal % by position

Postby uconnrounder » Wed Sep 15, 2010 3:33 am

I am a 9man sng player and I would like to know if it's possible to customize a statistic to show me what my average opponent is stealing with (percentage-wise) in various positions at specific blind levels. How would I go about doing that?

Furthermore, would it be possible to customize that statistic to filter out specific players? For example, I have a pretty good idea what the good regs are pushing from the CO, and their range skews the average opponent pushing range closer to optimal than it should be. Is it possible to filter a stat to remove specific players from the calculation?
uconnrounder
 
Posts: 52
Joined: Wed Feb 20, 2008 12:34 am

Re: Question - Average opponent steal % by position

Postby kraada » Wed Sep 15, 2010 9:11 am

Is this something you want to see on the HUD or would you be happy running custom reports to get these ideas away from the table?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Question - Average opponent steal % by position

Postby uconnrounder » Wed Sep 15, 2010 11:53 am

away from the table would be fine.
uconnrounder
 
Posts: 52
Joined: Wed Feb 20, 2008 12:34 am

Re: Question - Average opponent steal % by position

Postby kraada » Wed Sep 15, 2010 12:08 pm

In that case if you create a custom report in the Player Statistics section you can add the Position statistic and that will break all results down by position. Add the Attempt to Steal statistic, and something like number of hands if you'd like and run your report. You can filter to the players you want to see and the limits you want to see in the blue Filters area.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Question - Average opponent steal % by position

Postby uconnrounder » Fri Sep 17, 2010 3:38 am

Rather than creating a report based on the statistics of a single player, I am looking to find the ranges of the average player in my database. I can use my HUD to show me whether a player is loose/tight/solid/fishy etc and deviate my standard play based on that information, but having a general idea of what the average opponent is doing from a given position would be very helpful.

I play 9man super turbos, which are unique in the sense that nearly identical push/fold situations arise in almost every sng. For example, a 255 chip BTN push into a 300 chip BB and 270 chip SB is extremely common. I would like to know what percentage of hands is being pushed on average by the overall player pool from any given position at various blind levels (I have a 2010 database of about 100,000 different players). Rather than creating a report which focuses on the statistics of a single player, is it possible to gather and combine the statistics of ALL players in my database so as to paint an accurate picture of the 'average player's' range given certain conditions (i.e blind level/position/etc)?

Thanks again for all your help, I really appreciate it.

-Rob
uconnrounder
 
Posts: 52
Joined: Wed Feb 20, 2008 12:34 am

Re: Question - Average opponent steal % by position

Postby kraada » Fri Sep 17, 2010 8:51 am

This can definitely be done.

On the Tournament -> Reports tab, choose the Player Statistics section and create a new report. Add to it hands and attempt to steal.

Click the blue Filters link on the left. Uncheck "Filter on Active Player".

Now comes the part where you customize the filter.

tourney_holdem_hand_player_detail.amt_before is the player's starting stack in chips.
tourney_holdem_blinds.amt_bb is the size of the big blind for that hand.

So if you wanted to look at, for example, hands where a player had between 8 and 10 big blinds when they were attempting to steal you'd add the filter:

tourney_holdem_hand_player_detail.amt_before / tourney_holdem_blinds.amt_bb >= 8 AND tourney_holdem_hand_player_detail.amt_before / tourney_holdem_blinds.amt_bb <= 10

Then click save.

You can edit as you'd like, of course, and each time you change it, save and run your report and you'll get the data from your entire database on ATS % with the parameters you've set up.

You can of course also go further with this; see the Simple Filters section if you want to use any normal filter (e.g. >= 5 players at the table), and you can add any other stat you'd like as well.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Question - Average opponent steal % by position

Postby uconnrounder » Sat Sep 18, 2010 3:15 am

WOW! This is fantastic. I can't begin to tell you how helpful you've been. Thanks so much Kraada!
uconnrounder
 
Posts: 52
Joined: Wed Feb 20, 2008 12:34 am

Re: Question - Average opponent steal % by position

Postby kraada » Sun Sep 19, 2010 8:55 am

You're welcome :)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests