PokerTracker

Let's say we are heads-up and BB is facing an all-in from SB. This could be a shove where SB has the smaller stack and would put him all-in as well as shoves where BB has the smaller stack as well as normal raises from SB that would put BB all-in if called. It seems to me by looking at specific hands on the database that at least on the last case enum_face_allin is set to 'N' so it won't detect this situation.

So this is what I'm thinking of using:
lookup_positions.flg_bb AND (tourney_hand_player_statistics.enum_face_allin = 'P' OR tourney_hand_player_statistics.amt_p_raise_facing >= (tourney_hand_player_statistics.amt_before - tourney_blinds.amt_bb)) AND tourney_hand_player_statistics.cnt_players < 3


Does that look like it would catch all the above mentioned situations or could there be some scenario that I'm missing?

That should work I think, but you could also use the effective stack database field. This will either be the player's entire stack if anyone with a larger stack remains in the hand, or the second highest stack if the player is deepest. For heads up it is always the shorter of the two stacks.

Here you can use:
tourney_hand_player_statistics.position = 8 AND tourney_hand_player_statistics.amt_p_raise_facing >= tourney_hand_player_statistics.amt_p_effective_stack

Hmm... How about the big blind amount? I mean, from looking at database values, amt_p_effective_stack looks to be the effective stack BEFORE posting blinds.

So, how does it react to this kind of setup:
- Blinds are 1000/2000
- SB has 10000 chips
- BB has 6000 chips -> amt_p_effective_stack is apparently 6000 here.

So SB and BB post blinds and now they have left:
- SB has 9000 chips
- BB has 4000 chips

Now SB raises to 5000 to put BB allin if called but it's less than amt_p_effective_stack -> What does your condition say about this?

Sorry, you're right - I was thinking that the raise-faced was the total amount. In that case you will still need to add the BB amount to the raise faced.