precetage of a player calling after RFI from CO

[shaiheart]

Hello,

I've been trying to create a stat where the situation goes likes this:
How many times a player from CO calls when there is an RFI and no one yet has called.

It makes no difference where the RFI is made from as long as there is an RFI action and the player is in the CO postion.

any help?

thanks!

[kraada]

cnt_p_call_pfr_nosqueeze_co:

sum(if[holdem_hand_player_statistics.flg_p_face_raise and not(holdem_hand_player_statistics.flg_p_3bet_def_opp or holdem_hand_player_statistics.flg_p_4bet_def_opp) and lookup_actions_p.action LIKE 'C' and not(holdem_hand_player_statistics.flg_p_squeeze_opp) and holdem_hand_player_statistics.position = 1, 1, 0])

This will sum up the following cases:
Hero has faced a raise, but not a 3-bet or 4bet, hero called, and made no other preflop action. Hero could not squeeze (therefore there could have been nobody else calling the PFR before Hero, or it would have been a squeeze opportunity). Hero was in the CO.

For opportunities use:

sum(if[holdem_hand_player_statistics.flg_p_face_raise and not(holdem_hand_player_statistics.flg_p_3bet_def_opp or holdem_hand_player_statistics.flg_p_4bet_def_opp) and not(holdem_hand_player_statistics.flg_p_squeeze_opp) and holdem_hand_player_statistics.position = 1, 1, 0])

[shaiheart]

it looks great, thanks!
but how about if UTG limps and HJ raises, that will be included in this scenario as well, and that's not a raise first in situation..

[kraada]

Hrm, you're right that it would be included. I can't see an easy way to exclude it though.

[shaiheart]

can't there be a way to add an expression that says:
- no limping action occurred
- some one raised
and then what you wrote?

[kraada]

No because the only way you can figure out if there are limpers before you is to check to see if you can RFI. We already know you can't RFI because someone else raised. There isn't a flag for whether there are limpers at all in the hand anywhere in the database.

[shaiheart]

can't we add a lookup for limping and use a NOT for it?

[kraada]

It's just not that easy. The database doesn't have a flag for "there were limeprs at some point". You can't access what someone else does just what you see in the custom stats.

Here's how cnt_p_facing_limpers is defined:

sum( if[ ((NOT holdem_hand_player_statistics.flg_p_face_raise) OR holdem_hand_player_statistics.flg_p_limp OR holdem_hand_player_statistics.flg_p_first_raise) AND NOT holdem_hand_player_statistics.flg_p_open_opp AND lookup_actions_p.action <> '', 1 , 0 ] )

Working backwards actually explains this more easily: You didn't do nothing (ie- it wasn't a walk to you), you didn't have a chance to open (which you shouldn't have if you're facing limpers). And at least one of the following is true:
(1) You raised first - since you didn't open the action, but you made the first raise, before you there must have been limpers.
(2) You limped - since you didn't open with your limp, there could only have been limpers in front of you (as if there was a raise in front of you, you'd have called it)
(3) You didn't face a preflop raise - the only way that can happen and you have no chance to open is if there's a limper in front of you.

This exhausts all possibilities.

But when you add someone who raises after the limper, the situation that (3) covers, it no longer covers. And you can't then figure out if there was a limper in front of the raiser.

I welcome you to try to find a way to do it but I'm pretty sure it cannot be done at this point.

[shaiheart]

I suppose that's something that should be added?
If I really need it, how will it be possible to attain it?

[WhiteRider]

It's been requested before, but the information just isn't in the database at the moment.