Quick Custom Report ?

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

Quick Custom Report ?

Postby kes1981 » Tue Aug 10, 2010 6:34 pm

Wondering if this was possible as a pop up stat:

How often a villan 3B from the button versus a CO open and FOLDS TO A 4B

If PT3 can do this, I'll buy it right now.
kes1981
 
Posts: 141
Joined: Tue Aug 10, 2010 6:28 pm

Re: Quick Custom Report ?

Postby kes1981 » Tue Aug 10, 2010 8:47 pm

The learning curve seems pretty high for building stats :( but I enjoy challenges.

here is one that should be pretty simple: Folded to CO raise; utg and hj both fold and CO raises preflop (so no limpers too).

What existing columns do I use?
kes1981
 
Posts: 141
Joined: Tue Aug 10, 2010 6:28 pm

Re: Quick Custom Report ?

Postby WhiteRider » Wed Aug 11, 2010 2:54 am

Finding the position of the open-raiser is only possible in some situations. The database field "holdem_hand_player_detail.val_p_raise_aggressor_pos" holds the position of the last player to raise preflop other than the active player. Once there is a re-raise by anyone other than the active player you lose the information about the position of the open raise.
See this thread or [url=http://www.pokertracker.com/forums/viewtopic.php?f=18&t=27835&hilit=preflop+raise+position+aggressor#p134903]
this one[/url] for a discussion.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Quick Custom Report ?

Postby kes1981 » Wed Aug 11, 2010 4:57 pm

I figured out all the stuff about villans 3B from specific position vs position (button vs cutoff, small blind versus utg) and how often they fold to a 4B....

I'm having trouble figuring out how to write facing a 3B from a specific position:

Player opens in the CO and the SB 3B, how often does the player fold....
kes1981
 
Posts: 141
Joined: Tue Aug 10, 2010 6:28 pm

Re: Quick Custom Report ?

Postby kraada » Wed Aug 11, 2010 5:20 pm

You're not going to be able to get accurate stats in those cases because if any other player raises the pot besides you, you cannot tell who the original raiser was.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Quick Custom Report ?

Postby kes1981 » Wed Aug 11, 2010 5:23 pm

That's fine... it's actually what I want... HJ is first to open and its folded to the SB who 3B, I want to know how often the CO folds in this spot.

I basically need to know how to write facing a 3B from a specific position and folds to that 3B
kes1981
 
Posts: 141
Joined: Tue Aug 10, 2010 6:28 pm

Re: Quick Custom Report ?

Postby kraada » Wed Aug 11, 2010 5:39 pm

holdem_hand_player_detail.val_p_raise_aggressor_pos is the position value of the last player who was not you to raise preflop.

So if the HJ opens and the SB 3-bets and everyone else folds, from the HJ's perspective, val_p_raise_aggressor_pos = 9. From the SB's perspective, it's 2.

Here's the problem in two ways: HJ opens, SB 3-bets, BB calls, HJ 4-bets, SB folds, BB 5-bet shoves. From HJ's perspective now val_p_raise_aggressor_pos = 8 -- not 9. UTG limps, HJ opens, SB 3-bets, UTG 4-bets, HJ goes all in, SB folds, UTG calls. From HJ's perspective now val_p_raise_aggressor_pos is UTG's position value, not SB's.

So we're not going to be able to get all cases and some things are just going to be flagged wrong, which is why this stat just can't be built accurately.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Quick Custom Report ?

Postby kes1981 » Wed Aug 11, 2010 6:03 pm

Can you give me the complete example: hj open raises, sb 3B

I need an expression for the opportunites to fold

and the amount of times he folded
kes1981
 
Posts: 141
Joined: Tue Aug 10, 2010 6:28 pm

Re: Quick Custom Report ?

Postby kes1981 » Wed Aug 11, 2010 7:34 pm

kraada wrote:holdem_hand_player_detail.val_p_raise_aggressor_pos is the position value of the last player who was not you to raise preflop.

So if the HJ opens and the SB 3-bets and everyone else folds, from the HJ's perspective, val_p_raise_aggressor_pos = 9. From the SB's perspective, it's 2.

Here's the problem in two ways: HJ opens, SB 3-bets, BB calls, HJ 4-bets, SB folds, BB 5-bet shoves. From HJ's perspective now val_p_raise_aggressor_pos = 8 -- not 9. UTG limps, HJ opens, SB 3-bets, UTG 4-bets, HJ goes all in, SB folds, UTG calls. From HJ's perspective now val_p_raise_aggressor_pos is UTG's position value, not SB's.

So we're not going to be able to get all cases and some things are just going to be flagged wrong, which is why this stat just can't be built accurately.


I don't think the stat you gave me is correct (I could be wrong though). That expression seems to apply when you are facing a raise preflop and can't be interchanged with 3B.... Just an observation from grinding the stats for the past 2 days
kes1981
 
Posts: 141
Joined: Tue Aug 10, 2010 6:28 pm

Re: Quick Custom Report ?

Postby kraada » Thu Aug 12, 2010 8:59 am

Nobody's given you a stat in this thread; I'm a bit confused.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

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

Who is online

Users browsing this forum: No registered users and 0 guests