Fold 4bet to 5bet

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

Fold 4bet to 5bet

Postby TopChan » Wed Jan 04, 2012 5:58 pm

I have stat 4bet oop from utg
Raise 3Bet Percentage out of position in utg
(cnt_p_rfi_raise3bet_oop_utg / cnt_p_rfi_face3bet_oop_utg) * 100
where cnt_p_rfi_raise3bet_oop_utg =
sum( if[ holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.enum_p_3bet_action='R' AND holdem_hand_player_statistics.position = 3 AND holdem_hand_player_statistics.position < holdem_hand_player_detail.val_p_raise_aggressor_pos, 1, 0 ] )
and
cnt_p_rfi_face3bet_oop_utg =
sum( if[ holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_3bet_def_opp AND holdem_hand_player_statistics.position = 3 AND holdem_hand_player_statistics.position > holdem_hand_player_detail.val_p_raise_aggressor_pos, 1, 0 ] )

How can I make stat «Fold to 5bet when 4bet oop from utg»?

Thanks in advance.
TopChan
 
Posts: 36
Joined: Wed May 14, 2008 3:00 pm

Re: Fold 4bet to 5bet

Postby WhiteRider » Thu Jan 05, 2012 4:32 am

It isn't possible to tell when you face exactly a 5-bet in PT3 (it is in PT4) so you can't build this stat exactly, but you can check for facing a 4-bet or higher using "holdem_hand_player_statistics.flg_p_4bet_def_opp". In this case, since you know the player made exactly a 4bet this must mean they are facing a 5bet or higher. You can also just use "holdem_hand_player_statistics.flg_p_fold" to check for them folding to a 5bet+ since if they made a 4bet and fold that has to be the case.

You have your < and > signs opposite ways round when comparing positions in your expressions - hopefully that's just a typing mistake in this post, but you might want to check your actual columns to make sure they are both doing the same thing.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 9 guests