New stat, check Please

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

New stat, check Please

Postby sym25 » Fri Mar 30, 2012 8:07 am

i create stat: won when bet turn
(cnt_t_bet_won / cnt_t_bet) *100
where cnt_t_bet_won is
sum(if[cash_hand_player_statistics.flg_won_hand AND cash_hand_player_statistics.flg_t_bet, 1, 0])
is it correct?
sym25
 
Posts: 208
Joined: Wed Nov 26, 2008 3:38 am

Re: New stat, check Please

Postby kraada » Fri Mar 30, 2012 8:21 am

That should work, yes.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: New stat, check Please

Postby sym25 » Fri Mar 30, 2012 8:52 am

Won when Saw F in 3Bet+ Pot %
(cnt_won_f_saw_3bet_pot / cnt_f_saw_3bet_pot) * 100
where cnt_f_saw_3bet_pot is
sum(if[cash_hand_player_statistics.flg_f_saw AND (cash_hand_player_statistics.flg_p_3bet or cash_hand_player_statistics.flg_p_4bet), 1, 0])
cnt_won_f_saw_3bet_pot is
sum(if[cash_hand_player_statistics.flg_won_hand AND cash_hand_player_statistics.flg_f_saw AND (cash_hand_player_statistics.flg_p_3bet or cash_hand_player_statistics.flg_p_4bet), 1, 0])
is it correct?
sym25
 
Posts: 208
Joined: Wed Nov 26, 2008 3:38 am

Re: New stat, check Please

Postby kraada » Fri Mar 30, 2012 12:17 pm

The way it's written the person in question needs to have been the one to make the 3/4bet - if that's what you want, then you're good. If you want it to also include times a player called a 3bet you should change it to (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) - if they defended against a 3bet or a 4bet and they saw the flop either they raised or called - and now we don't care which.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: New stat, check Please

Postby sym25 » Fri Mar 30, 2012 3:55 pm

if i understand correct for all situations must be like:
sum(if[cash_hand_player_statistics.flg_f_saw AND (cash_hand_player_statistics.flg_p_3bet or cash_hand_player_statistics.flg_p_4bet or holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp), 1, 0])
and
sum(if[cash_hand_player_statistics.flg_won_hand AND cash_hand_player_statistics.flg_f_saw AND (cash_hand_player_statistics.flg_p_3bet or cash_hand_player_statistics.flg_p_4bet or holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp), 1, 0])

Is it right?
sym25
 
Posts: 208
Joined: Wed Nov 26, 2008 3:38 am

Re: New stat, check Please

Postby kraada » Fri Mar 30, 2012 4:58 pm

Yes that will work.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 1 guest