Statistic 3bet preflop

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

Re: Statistic 3bet preflop

Postby abs2000 » Sun Dec 11, 2011 2:14 pm

I got it, tnx.
abs2000
 
Posts: 40
Joined: Tue Dec 28, 2010 12:15 pm

Re: Statistic 3bet preflop

Postby lifeisagame69 » Thu Dec 15, 2011 4:23 pm

So, when i desactivate the box "filter on active player" it show me the stat for all the vilain who played against me or for all people on my database play ?

How can i do also if i want to know the % of time vilain check raise me on flop when he call his BB when i raise sb in a HU match with a gutshot.

Also can i know after a c/r flop with a specific hand (let say gutshot same as above), the % of time he contibet turn and river ? or contibet just the turn and not the river ?




thanks
lifeisagame69
 
Posts: 227
Joined: Wed Oct 29, 2008 12:27 am

Re: Statistic 3bet preflop

Postby kraada » Thu Dec 15, 2011 6:03 pm

When you are not filtering on the active player you get all data in the database (unless you specifically filter it out).

The specific filter request you have set up is a bit complicated - If you filter for times a villain calls a steal in the big blind and look at his check/raise percentage though you'll see how often he does that.

Remember, when villain decides to check raise he doesn't know if you have a gutshot or not. Only once you've shown the hand down does he know what you have.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Statistic 3bet preflop

Postby lifeisagame69 » Thu Dec 15, 2011 7:13 pm

when i desactivate the box "filter on active player" i get all data in the database? with mine also?

Because what i'm looking for it's the data off my opponement who's playing against me.

you said "If you filter for times a villain calls a steal in the big blind" what mean "for time" ?

i make a mystake in my last post, when i say "i want to know the % of time vilain check raise me on flop when he call his BB when i raise sb in a HU match with a gutshot", i want to said << i want to know the % of time vilain check raise me with gutshot on flop when he call his BB when i raise sb in a HU match>>.


thanks
lifeisagame69
 
Posts: 227
Joined: Wed Oct 29, 2008 12:27 am

Re: Statistic 3bet preflop

Postby WhiteRider » Fri Dec 16, 2011 5:27 am

If you uncheck "Filter on Active Player" it will display data for all players, including you, but the filter Kraada gave you earlier allows you to filter out your own hands.

kraada wrote:Create the report in the Player Statistics section, add the stats Hole Cards and Times to it. In the blue Filters section uncheck the "Filter on Active Player" box, click Simple Filters, and add a filter for 3Bet Preflop. After adding that to the filters (the words "Simple Filters" will appear in blue once this is done) add the following to the text box:

player.player_name != 'Your ScreenName Here'

Replace the words Your ScreenName Here with your actual screen name - this will filter out your hands (note you still need the quotes around your name).

"filter for times" means to filter for the hands where something happened.

You can filter for having a gutshot using the "Draws" tab of the Filter window.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Previous

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

Who is online

Users browsing this forum: No registered users and 5 guests