help with a couple stats

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

help with a couple stats

Postby astro » Thu Feb 10, 2011 12:42 pm

silly question... but i need a couple of stats cause Im so lost with the name of the stats at PT3

BB 3bets the SB raise first in ( sb is stealing)

BB 3 bets the BTN raise first in ( btn is stealing)

ty a lot
astro
 
Posts: 20
Joined: Fri May 16, 2008 3:09 am

Re: help with a couple stats

Postby kraada » Thu Feb 10, 2011 1:13 pm

The first stat is "BB v SB Steal - Raise" and is available by default.

The second stat is not available by default but you can build it.

Create these two new columns:

cnt_p_bb_button_steal_def_raise: sum(if[holdem_hand_player_statistics.flg_blind_b and holdem_hand_player_statistics.flg_blind_def_opp and not(holdem_hand_player_statistics.flg_p_squeeze_opp) and holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 and holdem_hand_player_statistics.flg_p_3bet, 1, 0])

and

cnt_p_bb_button_steal_def_opp: sum(if[holdem_hand_player_statistics.flg_blind_b and holdem_hand_player_statistics.flg_blind_def_opp and not(holdem_hand_player_statistics.flg_p_squeeze_opp) and holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 and holdem_hand_player_statistics.flg_p_3bet_opp, 1, 0])

For more on creating custom statistics please see the Tutorial: Using Custom Statistics and Reports.
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 0 guests