Stat: How often do I face a bet after checking the turn?

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

Stat: How often do I face a bet after checking the turn?

Postby fritos » Sat May 02, 2009 9:47 am

Ok,

I'm trying to build a custom stat that tells me how often I get led into on the river after checking behind on the turn. I *think* the scenario would be described by

flg_f_cbet AND NOT flg_f_face_raise AND flg_t_saw AND flg_t_check***** AND ___

and now I would need something like flg_r_facing_bet, but it doesn't seem to exist.

What's my line?




**** I assume that this should exclude cases like c/c donk by my opponent?
fritos
 
Posts: 38
Joined: Wed Feb 04, 2009 5:15 pm

Re: Stat: How often do I face a bet after checking the turn?

Postby kraada » Sat May 02, 2009 10:47 am

You don't need flg_t_saw if you have flg_t_check - by being able to check the turn it means you saw the turn :)

For the river, you want holdem_hand_player_detail.amt_r_bet_facing > 0 -- you faced a non-zero river bet.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Stat: How often do I face a bet after checking the turn?

Postby fritos » Sat May 02, 2009 11:29 am

k, thanks,

one other thing:

In the documentation, it says that flg_f_has_position is true if this player is first to act on the turn. That can't be true, can it? Someone haveing position on the flop usually has position on the turn as well? Same for flg_t_has_position and the documentation for flg_r_has_position doesnt really make any sense to me either (p27/28).
fritos
 
Posts: 38
Joined: Wed Feb 04, 2009 5:15 pm

Re: Stat: How often do I face a bet after checking the turn?

Postby kraada » Sat May 02, 2009 11:43 am

That should say "last to act". I'll make sure that gets fixed.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Stat: How often do I face a bet after checking the turn?

Postby fritos » Mon May 04, 2009 9:09 am

K, looks I need help with this...

I've decided to do this from the POV of the player betting the river after someone checks behind on the trn.

I think the stat now calculates correctly, however in the main window, the stats don't align. The lower number, 50 seems to be true over all the hands I've played vs. this guy, but not over the sub-set of hands I've filtered for.

The stat itself is calculated by creating two colums, one where he bet the river, one where he doesn't and then dividing b_r / (b_r + ch_r) *100.

Here's the b_r stat:

sum(if[holdem_hand_player_statistics.flg_blind_b AND (holdem_hand_player_statistics.flg_f_cbet_def_opp) AND NOT (holdem_hand_player_statistics.flg_f_check_raise) AND (holdem_hand_player_statistics.flg_t_saw) AND (holdem_hand_player_detail.amt_t_bet_facing = 0) AND (holdem_hand_player_statistics.flg_r_bet),1,0])


Image


(since I can'T seem to post an imagine, here's the link:

http://www.freeimagehosting.net/uploads/56f7d7c8bc.jpg
fritos
 
Posts: 38
Joined: Wed Feb 04, 2009 5:15 pm

Re: Stat: How often do I face a bet after checking the turn?

Postby fritos » Mon May 04, 2009 9:34 am

Actually, upon trying this out for a number of players, the 50 at the bottom seems to stay there no matter which player I look at and no matter how many hands I have on the guy... Even if I have someone with stats from 3 different stakes and a B_ri_if_ch_to of 80+ for each individual stakes, the total still shows 50. So it seems clearly wrong but I don't know _what_ exactly is the problem. :/
fritos
 
Posts: 38
Joined: Wed Feb 04, 2009 5:15 pm

Re: Stat: How often do I face a bet after checking the turn?

Postby kraada » Mon May 04, 2009 10:43 am

What do you have as the format summary expression for your stat?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Stat: How often do I face a bet after checking the turn?

Postby fritos » Mon May 04, 2009 10:47 am

kraada wrote:What do you have as the format summary expression for your stat?



/%.2f

I have that from the c-bet success guide...
fritos
 
Posts: 38
Joined: Wed Feb 04, 2009 5:15 pm

Re: Stat: How often do I face a bet after checking the turn?

Postby kraada » Mon May 04, 2009 11:33 am

And the value expression is just the b_r column?

What do you have as the summary type for the column?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Stat: How often do I face a bet after checking the turn?

Postby fritos » Mon May 04, 2009 12:39 pm

kraada wrote:And the value expression is just the b_r column?

What do you have as the summary type for the column?



I have no idea, though that probably means "default" (if there is such a thing). Where do I look that up?

Here's another pic of one opponent that shows that things are def. wrong.

http://www.freeimagehosting.net/uploads/90e182f7e0.jpg

Interestingly enough, I've added the stat to my HUD just to see what happenes and it seems to work fine there - so it seems only this summary field in the player stats is wrong.
fritos
 
Posts: 38
Joined: Wed Feb 04, 2009 5:15 pm

Next

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

Who is online

Users browsing this forum: No registered users and 1 guest

cron
highfalutin