fold to 3bet PF

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 to 3bet PF

Postby stanko123 » Tue Jan 12, 2010 2:49 am

HI, the current default "fold to 3bet PF" stat shows player's PF fold stat when faced any 3bet.

How do I make a custom stat where the "player A raised PF, got 3bet by player B and player A folds". Current "fold to 3bet PF" stat also includes player folding to 3bet action before him. Thanks.
stanko123
 
Posts: 11
Joined: Tue Oct 20, 2009 11:17 am

Re: fold to 3bet PF

Postby marvin » Tue Jan 12, 2010 5:00 am

times:
cnt_p_3bet_def_opp_when_open_raised:
sum(if[holdem_hand_player_statistics.flg_p_3bet_def_opp and holdem_hand_player_statistics.flg_p_first_raise and not(holdem_hand_player_statistics.flg_steal_att), 1, 0])

this count when he raises and faces a 3b (the originalraiser is not in steal situation, if you want include the steal delete the last condition "and not(holdem_hand_player_statistics.flg_steal_att)"

opoortunity:
sum(if[holdem_hand_player_statistics.flg_p_3bet_def_opp and holdem_hand_player_statistics.flg_p_first_raise and not(holdem_hand_player_statistics.flg_steal_att), 1, 0]).

it would be works, but i dunno why in my hud apperas (). try it and let me know if work to you.
marvin
 
Posts: 327
Joined: Tue Jul 08, 2008 10:17 am

Re: fold to 3bet PF

Postby WhiteRider » Tue Jan 12, 2010 5:43 am

Thanks marvin - there is a "Fold to 3bet preflop" which is built as you want it already available for download from the Repository.
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 0 guests