Call 2Bet from BU.

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

Call 2Bet from BU.

Postby stasia42 » Fri May 21, 2010 7:11 am

Hi,
Lately I've been trying to build call to 2bet stats, and here's what I came up with...

BU call 2Bet.

call_PFR_2Bet_BU

sum(if[ lookup_actions_p.action like 'C%' AND {if he at least called pre-flop}
holdem_hand_player_statistics.flg_p_3bet_opp AND NOT {and it was a 2bet that he called}
holdem_hand_player_statistics.flg_p_limp AND NOT {and he didn't limp from BU, I added this to avoid situations when BU limp, one of the blinds RWPC, and then the BU has the opp to 3bet, I don't want this situations}
holdem_hand_player_statistics.flg_p_4bet AND holdem_hand_player_statistics.position = 0, 1, 0])

callopp_PFR_2Bet_BU

sum(if[holdem_hand_player_statistics.flg_p_3bet_opp AND {facing 2bet}
holdem_hand_player_statistics.position = 0 AND NOT {BU}
holdem_hand_player_statistics.flg_p_limp, 1, 0]) {didn't limp}


How does this looks..?

Regards,
Stas.
stasia42
 
Posts: 35
Joined: Tue Aug 25, 2009 12:51 pm

Re: Call 2Bet from BU.

Postby kraada » Fri May 21, 2010 9:08 am

That looks good to me.
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