vs missed CB

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

vs missed CB

Postby js2002 » Tue Dec 16, 2008 5:21 am

Hi,

does anyone have this stat?
f.e. how often the opponent bets when I miss my CB.
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: vs missed CB

Postby kraada » Tue Dec 16, 2008 1:41 pm

I'm not sure what stat you're asking about. What do you mean by "when I miss my CB"?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: vs missed CB

Postby js2002 » Tue Dec 16, 2008 5:34 pm

Sitting at the table as PFA I ask myself "how often does he bet, if I check (oop) to him" fe. Ich I flopped the nutz and I see this stat having 70 - 100% I ll check so he bets and I ll c/r him"

In other word. I miss a CB = I am PFA (preflop aggressor) and dont want to make a CB so I dont do it so I miss it ;)

just lock at the HM screenshot, this stat ist there in the main popup.
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: vs missed CB

Postby kraada » Tue Dec 16, 2008 10:01 pm

This stat isn't available by default but it isn't hard to make.

You'll want there to be a PFR, the person in question to have a chance to bet in position that isn't a cbet opportunity. You'll need an opportunities field and a count of times that the person bets, then you can create the ratio you're looking for.

Both columns should be in the Holdem Cash Player Statistics section:

cnt_f_probe_bet_raised_pot:

sum(if[flg_f_bet and not(flg_f_cbet) and (cnt_p_raise > 0 or flg_p_face_raise) and holdem_hand_player_detail.flg_f_has_position])

This adds up the times when the player in question: bets, that isn't a cbet, when there was either a preflop raise from them or they faced one, and they are in position.

Times he had a chance to would just be:

cnt_f_probe_bet_raised_pot_opp:

sum(if[flg_f_open_opp and not(flg_f_cbet) and (cnt_p_raise > 0 or flg_p_face_raise) and holdem_hand_player_detail.flg_f_has_position])

as open opportunities require nobody else having bet.

Make the stat then using those columns as the former over the latter times 100 (to make it a percent) and you should be all set.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: vs missed CB

Postby js2002 » Wed Dec 17, 2008 4:55 am

Nope sry 4 ur work but my def is another:

Me = Player A

Opportunities for Player X (denominator) are: A makes no CB oop, so X has the chance to "Bet vs a missed CB".
Nominator is: The times X does a Bet there.

So this stat is too hard 4 me to make because u have to check 2 players and u ll have to check if the PFA etc....

EDIT: with ur solution u ll get even unraised pots etc
And X did not raise preflop
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: vs missed CB

Postby kraada » Wed Dec 17, 2008 10:35 am

My definition should work for what you're looking for.

The reason why I included the player raising is to deal with situations where you raise and face a 3bet. If you raise, and you bet the flop, it's only not a cbet if someone else made a 3bet or a 4bet. This seemed easier than including facing 3bet and facing 4bet (as it includes just checking one stat instead of 2).

This may not work quite right in multiway pots, but this definition should:

cnt_f_probe_bet_raised_pot:

sum(if[flg_f_bet and (cnt_p_raise > 0 or flg_p_face_raise) and holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position])

cnt_f_probe_bet_raised_pot_opp:

sum(if[flg_f_open_opp and (cnt_p_raise > 0 or flg_p_face_raise) and holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position])

As now it looks to see if you're in position relative to the preflop raiser. Conveniently we can remove the not(cbet) part because you can never cbet in this spot -- the val_p_raise_aggressor_pos is -1 if you're the aggressor, and you can only cbet if you're aggressor, and -1 is never going to be greater than your current position.

And you can't bet if he already bet (you'd have to raise, call, or fold), so this should catch exactly the cases you want now.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: vs missed CB

Postby js2002 » Wed Dec 17, 2008 11:13 am

No! I dont mean Pots where Im not the preflop aggressor. In dont want em in this stat.
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: vs missed CB

Postby kraada » Wed Dec 17, 2008 2:38 pm

Okay there's two stats here:

And I'm going to describe things from the perspective of the person on whom the stat is given. That is, for an opponent A, I'm describing the stat from A's point of view.

Stat #1:
(I've fixed a couple of things in the definition hence I'm giving it again.)
Probe Bet in Raised Pots:

How often you bet into a raised pot after the preflop aggressor checks to you.

cnt_f_probe_bet_raised_pot:


sum(if[flg_f_bet and flg_p_face_raise and not(flg_f_cbet_opp) and holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position, 1, 0])

cnt_f_probe_bet_raise_pot_opp:


sum(if[flg_f_open_opp and flg_p_face_raise and not(flg_f_cbet_opp) and holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position, 1, 0])

Stat #2:

Fold to Probe Bet in Raised Pots:

cnt_f_probe_bet_raise_pot_def_opp:

sum(if[flg_f_cbet_opp and flg_f_check and flg_f_face_bet, 1, 0])

This counts how many times you could've cbet, didn't, and faced a bet.

and

cnt_f_probe_bet_raise_pot_def_opp_action_fold:

sum(if[flg_f_cbet_opp and substring(lookup_actions_f.action from 1 for 2) = 'XF', 1, 0])

This counts how many times you could've cbet, didn't, and check/folded.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: vs missed CB

Postby js2002 » Wed Dec 17, 2008 3:04 pm

1. flg_f_open_opp <---whats that again?
A CB can only be missed out of position. (else it is "check behind" and non-PFA cant make a probe)-bet) So why do you check this? Even in 2. see below

2. holdem_hand_player_detail.val_p_raise_aggressor_pos > holdem_hand_player_statistics.position
Do you check there if the probe better is oop?! If yes: Does this work for BB and SB positions in combination with other posis?
huh? The probe better cant be oop, Im wierd now;)
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: vs missed CB

Postby kraada » Wed Dec 17, 2008 4:31 pm

flg_f_open_opp = a chance to open the pot on the flop; that is, nobody's bet before you.

The position numbers count up. 0 is the button, 1 is the cutoff, 2 is the hijack, etc. So if the aggressor's position is greater than yours you have position on the aggressor.

I think you may be confused about the perspectives here. Remember that each stat looks at you as if you are the "hero". When you're playing on the table each stat for each player will show for him as to what he's done or not done.

So if you have the two stats I've made for you set up and an opponent with a Probe % of 70, that means 70% of the time that he's in position and checked to by the preflop raiser, he'll bet. If he has a Fold to Probe % of 85 that means 85% of the time that he's the aggressor preflop, and checks the flop, he's folded to a bet.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

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

Who is online

Users browsing this forum: Google [Bot] and 27 guests

cron