Raise pf, fold to pf3bet or to flop bet/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

Raise pf, fold to pf3bet or to flop bet/raise

Postby PeteX » Wed May 23, 2012 1:59 pm

I want to make a stat that tells me the % of times the player raises preflop (open-raise or raises after limpers) and doesn't 3bet/4bet and folds either to a preflop 3bet or flop bet or raise. The idea being that I want to know if I have a big probability of pushing a player off the pot when he raises in (e.g.) MP and I 3bet from the button and then bet at the flop when he checks or raise his bet or if a player folds easily when he tries to steal my BB from button and I 3bet and then donk-bet the flop or check-raise him. So in general the state should tell me, what are my chances of stealing the pot from the initial preflop agressor by getting more agressive on him preflop and on the flop.

These are the conditions that I came up with:
cnt_p_raise>0 AND NOT flg_p_3bet AND NOT flg_p_4bet AND (flg_p_fold OR flg_f_fold)

divided by the sum of

cnt_p_raise>0 AND NOT flg_p_3bet AND NOT flg_p_4bet AND (flg_p_face_raise OR flg_f_face_raise OR amt_f_bet_facing>0)

Would those be the proper conditions?
PeteX
 
Posts: 194
Joined: Sat Apr 05, 2008 9:12 am

Re: Raise pf, fold to pf3bet or to flop bet/raise

Postby kraada » Wed May 23, 2012 3:25 pm

That should work and show you what you want to see.
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