I need something like flg_f_2bet_opp (but it doesn't exist)

[Info Shove]

I'm looking for an expression to say the player got a 2bet opportunity on the flop.

Something like cash_hand_player_statistics.flg_f_3bet_opp for 2bets. What do I need to use for that?

[WhiteRider]

You can use "cash_hand_player_statistics.amt_f_bet_facing > 0", which says that the player faced exactly a "bet" (1-bet) on the flop.

For future reference, you can find out things like this by looking up how similar stats are made - I looked this up using the opportunities column for the stat "2Bet Flop" for example.

[Info Shove]

In my understanding, "cash_hand_player_statistics.amt_f_bet_facing > 0" is not a true 2bet opportunity flag as you can face an all-in bet (or be asked to all-in call) without having a 2bet opportunity.

That means the "2Bet Flop" stat is incorrect. Or am I seeing something wrong?

No matter whether that stat is incorrect or not: How can I exclude the above mentioned all-in situations and any other exceptional situations from "cash_hand_player_statistics.amt_f_bet_facing > 0" to create a pure 2bet opportunity flag?

[WhiteRider]

Sorry - I overlooked that when replying. You're quite right, and we have that in our system to be addressed.

This is indeed a tricky situation.
Currently to do this accurately you will need to test for the difference between the amount available and the amount bet preflop and the amount bet on the flop. For example using "(cash_hand_player_statistics.amt_f_effective_stack - cash_hand_player_statistics.amt_f_bet_facing) > 0", as well as testing that you did actually face a bet.

[Info Shove]

amt_f_effective_stack returns the amount of the smallest stack of all players who saw the flop right? That would mean if the flop is 3-way or more and the smallest stack is a 3rd player it will miss counting the 2bet opportunity.

How to get the amounts of the player's and the 1st flop aggressor's stack size?

[Info Shove]

I found live_cash_player.amt_stack but it returns stack sizes of the last hand and is not what I need right?

[WhiteRider]

amt_f_effective_stack is the amount of chips you could lose at the time of your first action. Therefore it is only the size of the shortest stack for the short-stack - for the other two players it is the second highest stack (which gives you what you want; although there will be some cases where the effective stack isn't actually still relevant at the time of facing the bet so it can't catch all cases with full accuracy).

[Info Shove]

amt_f_effective_stack is the amount of chips you could lose at the time of your first action. Therefore it is only the size of the shortest stack for the short-stack - for the other two players it is the second highest stack (which gives you what you want; although there will be some cases where the effective stack isn't actually still relevant at the time of facing the bet so it can't catch all cases with full accuracy).

Can you please explain in what kind of cases the effective stack isn't still relevant for 2bet opportunity?

[WhiteRider]

It is only for multiway pots - for example with 3 players if the big stack checks first , the short stack bets then the 2nd biggest stack folds, the big stack's effective stack will still be the size of the 2nd biggest stack at the start of the flop but only the short stack remains active.

If you prefer to use the actual stacks you could use "cash_hand_player_statistics.amt_before" and "cash_hand_player_statistics.amt_bet_p" - the amount the player started the hand with and the amount they bet preflop.

[Info Shove]

If you prefer to use the actual stacks you could use "cash_hand_player_statistics.amt_before" and "cash_hand_player_statistics.amt_bet_p" - the amount the player started the hand with and the amount they bet preflop.

That's a great way to exclude situations in which the player has to call all-in.

Code: Select all

(cash_hand_player_statistics.amt_before - cash_hand_player_statistics.amt_bet_p) > cash_hand_player_statistics.amt_f_bet_facing

Now all I need is to exclude situations in which he faces an all-in bet. How can I do that?