3bet vs call raise

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

3bet vs call raise

Postby ShyPh » Sun Dec 12, 2010 11:33 am

Hi,

I'd these stats:

pf_3bet_ip / pf_3bet_oop where the ip and oop are relative to the initial preflop raiser. Would this work:

Code: Select all
cnt_p_3bet_oop =
sum(if[ holdem_hand_player_statistics.flg_p_3bet AND
holdem_hand_player_statistics.position > holdem_hand_player_detail.val_p_raise_aggressor_pos, 1, 0])


Code: Select all
cnt_p_3bet_oop_opp=
sum(if[ holdem_hand_player_statistics.flg_p_3bet_opp AND
holdem_hand_player_statistics.position > holdem_hand_player_detail.val_p_raise_aggressor_pos, 1, 0])


and the ip variant would be position < aggressor_pos

also I'd like a call stat for that e.g. cnt_p_pfr_call_ip / oop, however the call refers to the first preflop raise:

Code: Select all
cnt_p_pfr_call_oop =
sum(if[ holdem_hand_player_statistics.flg_p_3bet_opp AND
holdem_hand_player_statistics.flg_p_fold = false AND
holdem_hand_player_statistics.cnt_p_raise=0 AND 
holdem_hand_player_statistics.position > holdem_hand_player_detail.val_p_raise_aggressor_pos, 1, 0])


the opp = the 3bet opp.

Would these work?
ShyPh
 
Posts: 17
Joined: Wed Apr 09, 2008 1:06 pm

Re: 3bet vs call raise

Postby kraada » Sun Dec 12, 2010 11:45 am

That will work in all hands in which there wasn't a 4-bet - if someone 4-bets cold, val_p_raise_aggressor_pos becomes their position and thus causes things to not work as you would like.

Adding AND NOT(holdem_hand_player_statistics.flg_p_4bet_def_opp) will eliminate potential 4-bet pots though.
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 2 guests