enum_face_allin

[husngforfood]

Does this mean that the raiser is all-in or that we are all-in once we call?

[kraada]

It depends on the case of the letter. A lowercase street letter means the raiser was all-in (but we might not be), and an uppercase letter means we would be if we were to call (but the raiser might not be).

So 'p' means we face a shove where we have the person covered preflop and 'P' means we faced a raise for more than our stack preflop. And the same for flop (f and F) turn (t and T) and river (r and R).

[rapmaster_c]

Hi,
I worked a bit with enum_face_allin and there are some things that irritates me.
1. If I check for enum_face_allin = 'P'(uppercase ), I get quite a lot of data(normal) but if i check for enum_face_allin = 'p' (lowercase), I only get a few data.
Shouldn*t both values be about the same amount of data?

2. If i check for:
tourney_hand_player_statistics.enum_face_allin = 'P'
AND lookup_actions_p.action = 'R'
I get some results(not a lot but still some).
So how is it possible that we are raising, when we are facing an allin that covers us?

[kraada]

(1) Let me try to be clearer - the lowercase is only if you face an all-in when we have chips back after we call and someone else who can win them. If we're heads up and facing a shove it doesn't matter if we have chips left or not - so we use upper case there.

(2) I'm not sure how this happens - please attach one of these hands to a support ticket and we'll look into it for you.

[rapmaster_c]

(1)a. Do you mean with heads-up being in a heads-up with only 1 Opponent left or does it include situations with more than one opponent left where you are the last and only one to act(maybe in BB and no opponents behind you to act)?

(1)b. As for the lowercase: Does a possible caller behind you need to have a higher stack than the shover too?

(1)c. I have checked tourney_hand_player_statistics.enum_face_allin = 'p' again with the filters:
- Players dealt into hand: 3-10 ( I excluded the HU-situation)
- position of active player position of selected: 0-7 (I excluded the blinds)
I ve checked for the count:
P(uppercase) returns: 1005 hands
p(lowercase) returns: 43 hands
If I evaluate it without the filters I get:
P(uppercase) returns: 2616 hands
p(lowercase) returns: 163 hands

The results for the lowercase p seem a bit too low in relation to the uppercases. So I'm wondering if those numbers are really too low or is the ratio normal and I am just being dense?

(2) done.

[kraada]

I've been told we found a few cases where multi-way situations are getting uppercase letters where they should be getting lower case letters and we are looking to investigate and fix this.

[rapmaster_c]

yo,
I ve checked out the new version of PT4 (4.05.3) and tested enum_face_allin very extensively.
It works perfectly now.
I am really amazed by how fast you fixed that problem(in one week). Nice work mates.

To all the other bros, who also had issues with enum_face_allin: you need to purge and re-import all of your hands(maybe its faster if you create a new database) after you ve updated PT4, otherwise the output will still be the same.

cheers

[kraada]

We do our best

[ibyoar]

I am a bit confused in relation with lower and uppercases,
let us suppose this query:
SELECT COUNT (DISTINCT stat.id_hand)
FROM public.tourney_hand_player_statistics stat
WHERE stat.enum_face_allin='P'
AND stat.position=0
AND stat.cnt_players>=4
AND stat.amt_p_2bet_facing <stat.amt_before
AND stat.amt_p_effective_stack=stat.amt_before

More than 3 players dealt(stat.cnt_players>=4), player in BTN(stat.position=0), face an allin when he covers the player who has pushed(stat.amt_p_2bet_facing <stat.amt_before) and he is covered behind(stat.amt_p_effective_stack=stat.amt_before)
I think this query is right,isnt?the result of this query is 980
Ok, using lowercases should cover the same situation("(1) Let me try to be clearer - the lowercase is only if you face an all-in when we have chips back after we call and someone else who can win them. If we're heads up and facing a shove it doesn't matter if we have chips left or not - so we use upper case there.")
SELECT COUNT (DISTINCT stat.id_hand)
FROM public.tourney_hand_player_statistics stat
WHERE stat.enum_face_allin='p'
AND stat.position=0
AND stat.cnt_players>=4
The result of this query is 34
Obviously i am missing something...

[ibyoar]

After importing some hands into a new database i get these results: