First action facing raise PF

[preparac]

I try to build a stat, which tells me, how any player reacts to a simple raise Pf when it is his first time to act.
I cannot use the lookup_action_street field (which would be the easiest way) because it seems not to work properly for tourney statistics.
Now I have some questions:

1a) The first thing that I want to do is to seaparate the actions when player is facing a simple raise in position (not in the blinds).

First i take the denominator
cnt_p_ccall_opp

Then i crate nominators for

- immediate folds (not folding later in the hand)
cnt_p_fold_face_raise_atfirstaction_not_blinds =
sum( if[tourney_holdem_hand_player_statistics.flg_p_fold AND
tourney_holdem_hand_player_statistics.flg_p_ccall = false AND
tourney_holdem_hand_player_statistics.flg_p_3bet = false AND
tourney_holdem_hand_player_statistics.flg_p_4bet = false AND
tourney_holdem_hand_player_detail.amt_blind = 0 AND
(tourney_holdem_hand_player_statistics.flg_p_face_raise = true AND NOT (tourney_holdem_hand_player_statistics.flg_p_face_raise = false OR tourney_holdem_hand_player_statistics.flg_p_limp = true OR tourney_holdem_hand_player_statistics.flg_p_first_raise = true) AND
tourney_holdem_hand_player_statistics.flg_p_open_opp = false), 1 , 0 ] )

- cold calls
cnt_p_ccall

- 3 bets (regardless if player later folds or calls)
cnt_p_3bet_face_raise_atfirstaction_not_blinds
sum( if[tourney_holdem_hand_player_statistics.flg_p_3bet AND
tourney_holdem_hand_player_detail.amt_blind = 0 AND
(tourney_holdem_hand_player_statistics.flg_p_face_raise = true AND NOT
(tourney_holdem_hand_player_statistics.flg_p_face_raise = false OR tourney_holdem_hand_player_statistics.flg_p_limp = true OR tourney_holdem_hand_player_statistics.flg_p_first_raise = true) AND
tourney_holdem_hand_player_statistics.flg_p_open_opp = false), 1 , 0 ] )

This 3 nominators together shoud give me 100% .. but when I check them in a report, I only get 99,9% ... for most players I get correct results, but for a few players I seem to exclude some hands. You see which ones?

Where i make a mistake in my thinking process??

2) How do i do the same for calls (to a raise) in the blinds? Can I use cnt_p_call > 0 instead of flg_p_ccall?

Thanx for your advice.

[kraada]

Well, first off you can simplify cnt_p_fold_face_raise_atfirstaction_not_blinds:

cnt_p_raise is > 0 if you raise ever, so:
sum( if[tourney_holdem_hand_player_statistics.flg_p_fold AND
tourney_holdem_hand_player_statistics.flg_p_ccall = false AND
tourney_holdem_hand_player_statistics.cnt_p_raise = 0 AND

continuing through the list I'm going to use Demorgan's Law for some simplification

tourney_holdem_hand_player_detail.amt_blind = 0 AND
(tourney_holdem_hand_player_statistics.flg_p_face_raise = true AND
tourney_holdem_hand_player_statistics.flg_p_face_raise = true AND
tourney_holdem_hand_player_statistics.flg_p_limp = false AND
tourney_holdem_hand_player_statistics.flg_p_first_raise = false AND
tourney_holdem_hand_player_statistics.flg_p_open_opp = false), 1 , 0 ] )

So looking at all of this together we obviously have some redundancy. We can remove the duplicative flg_p_face_raise. Further, flg_p_first_raise being false doesn't add anything as we've eliminated all cases in which there's any raises. So we can eliminate that case as well.

I've also made another couple of changes: since you never want to be calling, as well as never cold calling, I changed flg_p_ccall to cnt_p_call. However, since you don't call and don't raise, you always have to be folding (there's no fourth option), so I also went ahead and removed the redundant flg_p_fold. Further, since you don't call, you can't limp, so flg_p_limp is now also redundant and has been removed. Since at this point you're always folding and always facing a raise you can never have an open opportunity. (If it wasn't opened to you, you're not facing a raise, and so the hand isn't counted.) So I've removed the redundant flg_p_open_opp also. That leaves us with:

sum( if[tourney_holdem_hand_player_statistics.cnt_p_call = 0 AND
tourney_holdem_hand_player_statistics.cnt_p_raise = 0 AND
tourney_holdem_hand_player_detail.amt_blind = 0 AND
(tourney_holdem_hand_player_statistics.flg_p_face_raise = true, 1 , 0 ] )


With the 3 bets case I have also removed two other things in addition to the Demorgan's Law simplification: you can never have an open opportunity, not limp, and face a 3bet. Since eliminating the limp eliminates more cases, I've kept flg_p_limp and removed the flg_p_open_opp flag as it doesn't actually do any work. Similarly, you can never 3 bet when not facing a raise (because otherwise there would be no 2bet), so we can remove the flg_p_face_raise condition. Similarly for your 3 bets case it simplifies to:

sum( if[tourney_holdem_hand_player_statistics.flg_p_3bet AND
tourney_holdem_hand_player_detail.amt_blind = 0 AND
tourney_holdem_hand_player_statistics.flg_p_limp = false AND
tourney_holdem_hand_player_statistics.flg_p_first_raise = false, 1 , 0 ] )


Try those definitions, then see if it adds up to 100%. If not I'll take a deeper look to see what's missing; I suspect that some case you wanted included was just being left out because of all of the weird redundancy you'd built in.

[preparac]

thanx a lot, I will have a look at it

[preparac]

The redundancys was not the problem. Using your simpler conditions, I get exactly the same numbers. Still missing about 0,1 % of the hands.
Any idea?

[kraada]

Regardless of whether it was the cause it'll be much easier for us now to figure out what's causing it.

Could you set up a report to filter for hands that are not in any of those three cases? If I could then look at the hand history there I should be able to pinpoint what the problem is.

[preparac]

Some examples for hands which count as ccall_opp but not as fold/ccalled/3bet when had opp to ccall:

This are all 4bet-Situations. They shouldn’t count as ccall_opportunities, I think

2 hands for babuabe1

Hand #20704668875 begins at 2008/09/26
Dealing down cards
alek47 posts the small blind of 10
biggflo69 posts the big blind of 20
tr00 raises to 40.
PabloWeber raises to 100.
Zokki-MT folds.
babuabe1 raises to 110, and is all-in.
Oleg65 folds.
Shewi folds.
Life4m folds.
alek47 calls 100.
biggflo69 folds.
tr00 calls 70.
PabloWeber calls 10.
Dealing Flop [7s Ah Qc]
alek47 checks.
tr00 checks.
PabloWeber bets 180.
alek47 folds.
tr00 folds.
Dealing Turn [As]
Dealing River [2d]
PabloWeber shows [Qs Kh]
PabloWeber has Two Pair, Aces and Queens
babuabe1 shows [Ts 5h]
babuabe1 has One Pair, Aces
PabloWeber wins 460


Hand #20707261401 begins at 2008/09/26
purpleDin0 posts the ante of 75
veippa posts the ante of 75
mkalcher2 posts the ante of 75
gyposdog posts the ante of 75
didi93150 posts the ante of 75
swisstard posts the ante of 75
shmaf posts the ante of 75
SilkysNuts posts the ante of 75
babuabe1 posts the ante of 75
Dealing down cards
didi93150 posts the small blind of 400
swisstard posts the big blind of 800
shmaf raises to 1,600.
SilkysNuts raises to 9,600.
babuabe1 raises to 37,839, and is all-in.
purpleDin0 folds.
veippa folds.
mkalcher2 folds.
gyposdog folds.
didi93150 folds.
swisstard folds.
shmaf folds.
SilkysNuts calls 4,228, and is all-in.
Dealing Flop [3d Kc 4s]
Dealing Turn [4c]
Dealing River [4d]
SilkysNuts shows [Th Ts]
SilkysNuts has Full House, Fours full of Tens
babuabe1 shows [Ad As]
babuabe1 has Full House, Fours full of Aces
babuabe1 wins 31,131



2 hands of Snowblood78

Hand #20734171664 begins at 2008/09/27
Dealing down cards
Vincenzo85 posts the small blind of 100
lokern posts the big blind of 200
kidlat88 folds.
FortuneKim raises to 600.
daaannn999 folds.
Aryamehr raises to 1,728.
SnowBlood78 raises to 4,801, and is all-in.
michaelt1024 folds.
Ice B folds.
Vincenzo85 folds.
lokern folds.
FortuneKim raises to 12,903, and is all-in.
Aryamehr folds.
Dealing Flop [6c Js Kd]
Dealing Turn [3c]
Dealing River [5h]
FortuneKim shows [Td Tc]
FortuneKim has One Pair, Tens
SnowBlood78 shows [Jh Ah]
SnowBlood78 has One Pair, Jacks
SnowBlood78 wins 11,630


Hand #20706833324 begins at 2008/09/26
Dealing down cards
MrPokerOne posts the small blind of 25
Harmen xyz posts the big blind of 50
Sanka147 raises to 150.
Red_Falke folds.
MBAdept folds.
Hansbert raises to 1,250.
coolsid_sg folds.
SnowBlood78 raises to 2,395, and is all-in.
jaceklw folds.
MrPokerOne folds.
Harmen xyz folds.
Sanka147 calls 1,350, and is all-in.
Hansbert calls 1,145.
Dealing Flop [4d 5c Qs]
Dealing Turn [Ts]
Dealing River [Kh]
Sanka147 shows [6s 6d]
Sanka147 has One Pair, Sixes
Hansbert shows [9d 9h]
Hansbert has One Pair, Nines
SnowBlood78 shows [Td Tc]
SnowBlood78 has Three of a Kind, Tens
SnowBlood78 wins 6,365


2 hands of gregc777

Hand #20704924534 begins at 2008/09/26
Dealing down cards
Aniston 10 posts the small blind of 15
stockstar posts the big blind of 30
elle89 folds.
adofpoker67 folds.
NickeS26 calls 30.
truegrunt raises to 60.
pok21KASS raises to 240.
didi93150 folds.
gregc777 raises to 705, and is all-in.
Aniston 10 folds.
stockstar raises to 2,090, and is all-in.
NickeS26 folds.
truegrunt folds.
pok21KASS calls 1,850.
Dealing Flop [8d 6h 7s]
Dealing Turn [3s]
Dealing River [4h]
stockstar shows [Qh Qc]
stockstar has One Pair, Queens
pok21KASS shows [Qd Ad]
pok21KASS has High Card, Ace
gregc777 shows [9h Jh]
gregc777 has High Card, Jack
stockstar wins 4,990


Hand #20705294938 begins at 2008/09/26
Dealing down cards
JeruD Damaja posts the small blind of 50
Iceman'sHere posts the big blind of 100
bommel1892 folds.
ynot110 raises to 340, and is all-in.
grosgras6666 folds.
tapout1111 raises to 600.
k102205 folds.
Riese99 folds.
gregc777 raises to 1,500, and is all-in.
JeruD Damaja folds.
Iceman'sHere folds.
tapout1111 calls 900.
Dealing Flop [3h 7c 6c]
Dealing Turn [Kh]
Dealing River [Qc]
ynot110 shows [Ah 4d]
ynot110 has High Card, Ace
tapout1111 shows [Th Tc]
tapout1111 has One Pair, Tens
gregc777 shows [Js Ks]
gregc777 has One Pair, Kings
gregc777 wins 3,490



two hands of mulle 1234

Hand #20946600400 begins at 2008/10/05
aaron d 79 posts the ante of 25
MyNameIsLuka posts the ante of 25
Thespian21 posts the ante of 25
CPGR posts the ante of 25
gses posts the ante of 25
Porvu_vseh posts the ante of 25
mulle1234 posts the ante of 25
tintinaw posts the ante of 25
binostar posts the ante of 25
Dealing down cards
tintinaw posts the small blind of 150
binostar posts the big blind of 300
aaron d 79 folds.
MyNameIsLuka folds.
Thespian21 raises to 900.
CPGR folds.
gses folds.
Porvu_vseh raises to 2,550, and is all-in.
mulle1234 raises to 4,647, and is all-in.
tintinaw folds.
binostar folds.
Thespian21 calls 3,747.
Dealing Flop [8h Jd 4c]
Dealing Turn [Js]
Dealing River [4s]
Thespian21 shows [Kd Ah]
Thespian21 has Two Pair, Jacks and Fours
Porvu_vseh shows [9d 9c]
Porvu_vseh has Two Pair, Jacks and Nines
mulle1234 shows [Jc Ad]
mulle1234 has Full House, Jacks full of Fours
mulle1234 wins 12,519


Dealing down cards
riceville333 posts the small blind of 150
Jack_Herer13 posts the big blind of 300
URMYLeNoR folds.
bainville raises to 600.
seoda raises to 1,500.
kosamm folds.
mulle1234 raises to 2,400.
boneko folds.
eXalt1 folds.
riceville333 folds.
Jack_Herer13 folds.
bainville folds.
seoda calls 900.
Dealing Flop [As 9s 6d]
seoda checks.
mulle1234 bets 9,236, and is all-in.
seoda calls 9,236.
Dealing Turn [2c]
Dealing River [3s]
seoda shows [Tc Ad]
seoda has One Pair, Aces
mulle1234 shows [Ac Qc]
mulle1234 has One Pair, Aces
mulle1234 wins 24,547

[kraada]

Well, you clearly could have called cold, you just decided to 4bet instead. I think that sounds right.

So we just need to edit your last stat to be:

sum( if[(tourney_holdem_hand_player_statistics.flg_p_3bet OR tourney_holdem_hand_player_statistics.flg_p_4bet) AND
tourney_holdem_hand_player_detail.amt_blind = 0 AND
tourney_holdem_hand_player_statistics.flg_p_limp = false AND
tourney_holdem_hand_player_statistics.flg_p_first_raise = false, 1 , 0 ] )

to capture any of those 4 bet spots. You still can't have raised here b/c flg_p_first_raise is false. So you'll have opened with a 4 bet.

[preparac]

Yeah, I also thought like this, but when I checked this still was not correct.
Whe have to add the checker flg_p_ccall=false to exclude the cases, where I first ccall and after I 4bet.

Now finally ...
cnt_p_raise_when_ccall_opp
sum( if[(tourney_holdem_hand_player_statistics.flg_p_3bet OR tourney_holdem_hand_player_statistics.flg_p_4bet) AND
tourney_holdem_hand_player_detail.amt_blind = 0 AND
tourney_holdem_hand_player_statistics.flg_p_limp = false AND
tourney_holdem_hand_player_statistics.flg_p_first_raise = false AND
tourney_holdem_hand_player_statistics.flg_p_ccall = false, 1 , 0 ] )

...gives me the right numbers. Thank you for your help!

[kraada]

Hooray! I'm glad we got it fixed :)

Glad to be of service, and if there's anything else I can help with please feel free to ask.