Need Stat Call PF 3Bet in position

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

Need Stat Call PF 3Bet in position

Postby Dinslakener » Mon Apr 19, 2010 3:09 pm

Hi,

i can't build it myselt. Does anyone build Call 3Bet in position. Obviously i mean to be in position on flop as MP open, sb 3bets, MP calls
Dinslakener
 
Posts: 5
Joined: Thu Mar 20, 2008 1:22 pm

Re: Need Stat Call PF 3Bet in position

Postby WhiteRider » Mon Apr 19, 2010 4:49 pm

Do you want to count exactly the times a player raises and then calls a 3-bet preflop and is in position on the flop?

cnt_p_rfi_call3bet_ip =
sum( if[ holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.enum_p_3bet_action='C' AND holdem_hand_player_statistics.position < holdem_hand_player_detail.val_p_raise_aggressor_pos, 1, 0 ] )

cnt_p_rfi_face3bet_ip =
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 < holdem_hand_player_detail.val_p_raise_aggressor_pos, 1, 0 ] )

Then build a stat with Value Expression:
(cnt_p_rfi_call3bet_ip / cnt_p_rfi_face3bet_ip) * 100

See the Tutorial - Custom Reports and Statistics for a walkthrough of building a stat from these expressions.

NOTE: there are a few cases where the position < raise-aggressor-position check won't work correctly, but these are cases where someone else called the raise and then 4-bets.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Need Stat Call PF 3Bet in position

Postby Dinslakener » Tue Apr 20, 2010 12:30 am

Thanks a lot! That helped me!
Dinslakener
 
Posts: 5
Joined: Thu Mar 20, 2008 1:22 pm

Re: Need Stat Call PF 3Bet in position

Postby Skull_AK » Wed Jun 09, 2010 6:15 am

hi everybody
i need almost the same but instead in position in general, without taking care about if the player is in position or out position.
i have just realized that the stat built in PT3 Fold PF to 3ª bet is not the same as if you raise first (rfi or with limpers) then other player does a three bet and you fold.
well i have found in this page this last stat build, but i need too the percentage of call to that three bet.
i suppose it is almost the same that the above but i dont know which part of sentence i must avoid. so i wrote this in order you can help me .
sorry for my 'macarronic' english :mrgreen:
grettings.
Skull_AK
 
Posts: 32
Joined: Fri Apr 30, 2010 8:24 am

Re: Need Stat Call PF 3Bet in position

Postby kraada » Wed Jun 09, 2010 9:25 am

Remove the "AND holdem_hand_player_statistics.position < holdem_hand_player_detail.val_p_raise_aggressor_pos" from both expressions and that will remove the in position qualifier.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Need Stat Call PF 3Bet in position

Postby Skull_AK » Wed Jun 09, 2010 10:00 am

nice, thanks for the help, i have done it and go to check it.
i have noted one case in which fold to 3bet after raise is a 29 % and call to 3b after raise is a 83%. i think this is not possible.
the rest cases i have seen is more or less right.
thanks again
Skull_AK
 
Posts: 32
Joined: Fri Apr 30, 2010 8:24 am

Re: Need Stat Call PF 3Bet in position

Postby kraada » Wed Jun 09, 2010 12:10 pm

With the definitions above that shouldn't happen . . . can you locate the hand that is considered both a call and a fold?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Need Stat Call PF 3Bet in position

Postby Skull_AK » Wed Jun 09, 2010 2:43 pm

hi,
i don't understand well your question and i don't know how locata that hand.
i tell you what i did:
i created two columms:
cnt_p_rfi_call3bet_p
sum( if[ holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.enum_p_3bet_action='C', 1, 0 ] )
and:
cnt_rfi_face3bet_p
sum( if[ holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_3bet_def_opp, 1, 0 ] )
then i built a stat in this way:
C3B_pf
(cnt_p_rfi_call3bet_p / cnt_p_rfi_face3bet_p) * 100

i hope i did it in the right way.
Skull_AK
 
Posts: 32
Joined: Fri Apr 30, 2010 8:24 am

Re: Need Stat Call PF 3Bet in position

Postby Skull_AK » Wed Jun 09, 2010 3:32 pm

Skull_AK wrote:cnt_rfi_face3bet_p
sum( if[ holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_3bet_def_opp, 1, 0 ] )
then i built a stat in this way:


sorry, the columm is: cnt_p_rfi_face3bet_p
Skull_AK
 
Posts: 32
Joined: Fri Apr 30, 2010 8:24 am

Re: Need Stat Call PF 3Bet in position

Postby WhiteRider » Wed Jun 09, 2010 4:30 pm

That looks like it should work correctly.
Please export both of your new stats and attach them to a Support ticket and we'll check them out.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Next

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

Who is online

Users browsing this forum: No registered users and 17 guests

cron