Barrel after CRing

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

Barrel after CRing

Postby Lakestone » Tue Feb 19, 2013 11:25 am

I wan't to see how often my opponent(s) shoot the turn after check-raising flop and one stat for the river too (after check-raising flop and barrel turn).

I have built a lot of stats so far but this one is a tough one imo :(

And btw hurry up with PT4 for Mac will ya! :lol:
Lakestone
 
Posts: 86
Joined: Tue Jan 31, 2012 2:29 pm

Re: Barrel after CRing

Postby kraada » Tue Feb 19, 2013 11:38 am

You can look at the columns for Check Raise Flop and Bet Turn - that's the data you want to combine to make your new columns. Anytime flg_t_bet is true the player made the first bet on the turn and anytime flg_t_open_opp is true they had a chance to.

And PT4 for Mac is being worked on and is in alpha testing currently - we hope to have it out soon!
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Barrel after CRing

Postby Lakestone » Tue Feb 19, 2013 10:51 pm

I really cannot find a column like that in PT3... Can you take a snapshot perhaps?
Lakestone
 
Posts: 86
Joined: Tue Jan 31, 2012 2:29 pm

Re: Barrel after CRing

Postby kraada » Wed Feb 20, 2013 9:08 am

Click Configure --> Configure Statistics. Choose the Holdem Cash Player Statistics section (or Tourney if that's what you play) and change to the Columns tab. That's where you'll find this data.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Barrel after CRing

Postby Lakestone » Wed Feb 20, 2013 10:58 pm

Really, I cannot find that in PT3, are you sure its just not in PT4?

Image
Lakestone
 
Posts: 86
Joined: Tue Jan 31, 2012 2:29 pm

Re: Barrel after CRing

Postby kraada » Thu Feb 21, 2013 8:22 am

cnt_f_check_raise is right below cnt_f_check in the middle of your screenshot. Click on that and duplicate it. Start with that information and add in holdem_hand_player_statistics.flg_t_bet into the sum(if[] statement to specify times that the player also bet the turn. Do the same in a different column using holdem_hand_player_statistics.flg_t_open_opp to specify times the player could bet the turn. Put the former new column over the latter new column and multiply by 100 to get your stat.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Barrel after CRing

Postby Lakestone » Sun Feb 24, 2013 10:24 pm

No stat like holdem_hand_player_statistics.flg_t_open_opp exists.
Lakestone
 
Posts: 86
Joined: Tue Jan 31, 2012 2:29 pm

Re: Barrel after CRing

Postby WhiteRider » Mon Feb 25, 2013 4:17 am

In PT3 that database field is in a different table:

holdem_hand_player_detail.flg_t_open_opp
WhiteRider
Moderator
 
Posts: 53972
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 15 guests

cron