3-betting 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

3-betting by position

Postby treehugger » Wed Jan 07, 2009 10:54 pm

Hi,

How do you go about making the following custom stats:

3-bet preflop from button
3-bet preflop from cutoff

It shouldn't be too hard but I can't find anything. Any help would be much appreciated as these are very useful stats.
treehugger
 
Posts: 1
Joined: Wed Jan 07, 2009 7:46 pm

Re: 3-betting by position

Postby Letissie » Thu Jan 08, 2009 12:20 am

They are there but aren't working :(
Letissie
 
Posts: 39
Joined: Thu Apr 10, 2008 9:31 am

Re: 3-betting by position

Postby kraada » Thu Jan 08, 2009 10:36 am

See the How To: Advanced HUD Configuration's 2nd edition for a walkthrough on how to create position stats. Instead of using the big EP/MP/LP stat blocks, if you want specifically from the button, the button is 0, the cutoff is 1, etc (and the BB and SB are always 8 and 9 respectively).
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: 3-betting by position

Postby stevi3p » Sat Jan 10, 2009 7:20 am

I uploaded these stats. They seem to work fine for me. Here's the code for the HJ (UTG+1 in 6-max) for example:

(cnt_p_3bet_HJ / cnt_p_3bet_opp_HJ) * 100

where:
cnt_p_3bet_HJ=sum(if[holdem_hand_player_statistics.flg_p_3bet and holdem_hand_player_statistics.position = 2, 1, 0])
cnt_p_3bet_opp_HJ= sum(if[holdem_hand_player_statistics.flg_p_3bet_opp and holdem_hand_player_statistics.position=2, 1, 0])

Kraada, do these look correct to you?

Why aren't they working for you Letissie?

Steve
stevi3p
 
Posts: 71
Joined: Thu Mar 13, 2008 3:00 pm

Re: 3-betting by position

Postby WhiteRider » Sat Jan 10, 2009 8:01 am

Yes, those look good, Steve.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 18 guests