Build of custom stats correct?

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

Build of custom stats correct?

Postby jscobie » Tue Nov 22, 2011 6:30 am

Hi,

Think I'm getting the hang of this now but was wondering if you can give the OK for these stats.

1) Cbet the flop then check the turn:

Column 1:
sum(if[holdem_hand_player_statistics.flg_t_cbet_opp AND holdem_hand_player_statistics.flg_t_check, 1, 0])

Column 2:
cnt_t_cbet_opp

Stat:
(Column1 / Column 2) * 100


2) Cbet the flop then c/f the turn

Column 1:
sum(if[holdem_hand_player_statistics.flg_t_cbet_opp AND holdem_hand_player_statistics.flg_t_check AND holdem_hand_player_statistics.flg_t_fold, 1, 0])

Column 2:
cnt_t_cbet_opp

Stat:
(Column1 / Column 2) * 100


3) Double barrel then x river

Column 1:
sum(if[holdem_hand_player_statistics.flg_r_cbet_opp AND holdem_hand_player_statistics.flg_r_check, 1, 0])

Column 2:
cnt_r_cbet_opp

Stat:
(Column1 / Column 2) * 100


4) Double barrel then c/f river

Column 1:
sum(if[holdem_hand_player_statistics.flg_r_cbet_opp AND holdem_hand_player_statistics.flg_r_check AND holdem_hand_player_statistics.flg_r_fold, 1, 0])

Column 2:
cnt_r_cbet_opp

Stat:
(Column1 / Column 2) * 100
jscobie
 
Posts: 76
Joined: Sat Apr 30, 2011 10:48 am

Re: Build of custom stats correct?

Postby kraada » Tue Nov 22, 2011 9:02 am

Those all look good.
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 2 guests