Calling on the Button a 2Bet from CO...

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

Calling on the Button a 2Bet from CO...

Postby stasia42 » Tue Aug 25, 2009 12:55 pm

Hi guys, couldn't find this stat anywhere, after half an hour of searching...
I would want to have a HUD stat that tells me how many times did a player called a steal attempt made from CO, while the calling player being on the Button.

Does anyone know how to build this stat, or did someone already build it?

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

Re: Calling on the Button a 2Bet from CO...

Postby kraada » Tue Aug 25, 2009 1:07 pm

I don't think this stat currently exists, and while you can build something very close you can't build something that's perfect. This is because of the way PT3 keeps records of the initial raiser's position - specifically, it doesn't. Further, there's no flag for "facing a steal" when you're not in a blind. The stat that I've laid out below will catch all times that: (1) there is a raise from the cutoff and (2) there is no reraise from either blind. The reasons for (2) are twofold:

(a) The val_p_raise_aggressor_position field would not be 1 (cutoff) if either blind 3-bets unless the CO 5-bets.
(b) We need to eliminate times the CO opens with a 3-bet (e.g. UTG raises, CO 3-bets, action to you on the button). The only way to do this is to preclude times you face a 3-bet. This will eliminate times that the blinds reraise as well.

In the Holdem Hand Player Statistics section you'd need two new columns as follows:

cnt_p_btn_face_steal:
sum(if[holdem_hand_player_statistics.position = 0 and holdem_hand_player_detail.val_p_raise_aggressor_pos = 1 and not(holdem_hand_player_statistics.flg_p_3bet_def_opp), 1, 0])

cnt_p_btn_face_steal_action_call:
sum(if[holdem_hand_player_statistics.position = 0 and holdem_hand_player_detail.val_p_raise_aggressor_pos = 1 and not(holdem_hand_player_statistics.flg_p_3bet_def_opp) and holdem_hand_player_statistics.cnt_p_call = 1, 1, 0])

Create a statistic on the stats tab putting the latter over the former and multiplying by 100 and you should be all set (you can fill in names and descriptions as you see fit).
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Calling on the Button a 2Bet from CO...

Postby stasia42 » Tue Aug 25, 2009 2:04 pm

Thanks a lot. Just finished building it, and going to try it...:-)
stasia42
 
Posts: 35
Joined: Tue Aug 25, 2009 12:51 pm


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

Who is online

Users browsing this forum: No registered users and 0 guests