4bet without cold 4bets stat

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

4bet without cold 4bets stat

Postby soultori » Fri Mar 13, 2009 11:26 pm

Sorry if this is already posted somewhere s but i couldn't find it...

what i am looking for is a custom stat.. percentage of times person 4 bet after he raised preflop and someone 3 bet him.
soultori
 
Posts: 1
Joined: Fri May 16, 2008 6:34 pm

Re: 4bet without cold 4bets stat

Postby kraada » Sat Mar 14, 2009 9:41 am

Create two new custom columns in the Holdem Cash Player Statistics section:

cnt_p_4bet_after_raising:

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.flg_p_4bet, 1, 0])

This adds up the times when you are the first raiser and you face a 3bet then 4bet.

cnt_p_3bet_def_opp_after_raising:

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.flg_p_4bet_def_opp, 1, 0])

This adds up the times when you are the first raiser and you face a 3bet or a 4bet. The reason for facing a 4-bet here is in case you raise, face a 3bet then a 4bet and 5bet, that will get picked up in the numerator so we want it picked up in the denominator as well.

Create a statistic on the stats tab that puts the first over the second and you'll have your stat. (Don't forget to fill out the Format tab.)

This stat won't be perfect but it will be basically as close as PT3 can come. Part of the reason it won't be perfect is that there aren't flags for exactly 4-betting in PT3. The 4bet flag is a 4-bet and anything higher than a 4bet (5bet, 6bet, etc). So we can't actually distinguish between the two. This stat is more accurately called "4+bet after raising", but it should be pretty close since those cases where you're raising getting 3bet and 4bet are going to be pretty rare.

[Note: Edited for clarity and correctness.]
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 4 guests