In ,out possision

[martijn01]

how do i make in or out position stats now?
example 3bet in pos? or out? i dont see anymore _opp_opp in collms

[kraada]

You can't actually be perfect with these stats because if someone 4bets cold they're going to get the hand to be recognized the other way.

That said: if (holdem_hand_player_statistics.position < holdem_hand_player_detail.val_p_raise_aggressor_pos) then you have position on the other player who was the last non-you aggressor preflop. So if someone raises and you 3-bet, val_p_raise_aggressor_pos is set to his position. The problem here is that if someone 4-bets cold from the SB and the original raiser folds, val_p_raise_aggressor_pos is set to 9, which obviously is going to cause problems for your stat. We are already looking at several ways to fix this issue going forward, but I don't know when they'll be available.

[Beck]

So far I've been operating with 2 different 3-bet stats:
Raising a steal attempt from the blind
3bet preflop not vs blind steal.

But as far as I can see that leaves out when CO is raising and BTN reraises, correct?
Raising 1 pos from the btn is always considered a steal attempt, right? So in a 4-handed game an UTG raise is a steal attempt?
Since the CO raise is a steal attempt, and BTN is not raising from a blind position.

I understand the difficulty about cold 4-betting, but think an in/out position stat will be close enough.

However, I'm not quite sure how to construct it. How do I incorporate the "if-line" you wrote in to the 3 bet-stat? I put it in as an additional condition, and thats it? And for the out of position stat, I just turn around the "<" ??

[WhiteRider]

But as far as I can see that leaves out when CO is raising and BTN reraises, correct?

This is not a blind steal by the button, and the blinds do not face a steal.
It is a blind steal [attempt] by the cutoff, though.

Raising 1 pos from the btn is always considered a steal attempt, right? So in a 4-handed game an UTG raise is a steal attempt?

Correct.

However, I'm not quite sure how to construct it. How do I incorporate the "if-line" you wrote in to the 3 bet-stat? I put it in as an additional condition, and thats it? And for the out of position stat, I just turn around the "<" ??

You include the expression part of the IF statement inside the existing IF statement.
So take "holdem_hand_player_statistics.position < holdem_hand_player_detail.val_p_raise_aggressor_pos" from kraada's expression and insert it into the expression of the stat you're editting (with an AND).
So you will end up with something like:
SUM ( if [ existingExpression AND holdem_hand_player_statistics.position < holdem_hand_player_detail.val_p_raise_aggressor_pos, 1, 0 ] )

Have a look at the Custom Statistics and Reports FAQ which explains the construction of stats.

[Beck]

But as far as I can see that leaves out when CO is raising and BTN reraises, correct?

This is not a blind steal by the button, and the blinds do not face a steal.
It is a blind steal [attempt] by the cutoff, though.

No, I get that. But in what stat is buttons 3-bet then included?

You include the expression part of the IF statement inside the existing IF statement.
So take "holdem_hand_player_statistics.position < holdem_hand_player_detail.val_p_raise_aggressor_pos" from kraada's expression and insert it into the expression of the stat you're editting (with an AND).
So you will end up with something like:
SUM ( if [ existingExpression AND holdem_hand_player_statistics.position < holdem_hand_player_detail.val_p_raise_aggressor_pos, 1, 0 ] )

Have a look at the Custom Statistics and Reports FAQ which explains the construction of stats.

Ok, I'll take a stab at it.

[kraada]

No, I get that. But in what stat is buttons 3-bet then included?

It's included in 3Bet Preflop.

[Beck]

OK, so I made a column with this expression
sum(if[holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.position < holdem_hand_player_detail.val_p_raise_aggressor_pos, 1, 0])

Which should be 3 betting in position? Does that also include if SB raise and BB 3-bets? Not sure where the "s" and "b" position tags fit in regarding to the numbers.

I also want 3betting out of position but not a limp-reraise.
Effectively that can only happen in blind position, I guess, but I am very uncertain how to make the expression then.
If I do
sum(if[holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_blind_s OR holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_detail.val_p_raise_aggressor_pos != 9 ,1,0])

Trying to say, 3betting from SmallBlind or 3betting from bigblind if PFR wasnt SB. The expression seems to be valid, but still unsure. Is Small Blind still called position 9, even if playing 6-handed?

[kraada]

The SB is always position 9 and the BB is always position 8 regardless of how many players are at the table.

Your first column will be times that you 3-bet in position unless someone 4-bets cold out of position and the original raiser does not 5-bet. In that case the hand won't show up because val_p_raise_aggressor_pos will be set to the position of the 4-bettor.

With your second column I'd clean it up slightly as such:

sum(if[(holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_blind_s) OR (holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_blind_b AND NOT (holdem_hand_player_detail.val_p_raise_aggressor_pos = 9)),1,0])

The extra parentheses are to make sure that the logical progression is treated properly, and NOT(x) I find much easier to see quickly than !=, though I don't think that should actually make much of a difference in terms of actual results for you.

[Beck]

OK, that makes sense, thanks.

I messed around with "Folding to 3bet preflop, when in/out of position", and think I managed it.
I'll post the codes, so hopefully, you can check if I'll get the desired result (all the statements are valid), and maybe somebody else can use it.

Fold to Preflop 3Bet when in position

Code: Select all

(cnt_p_3bet_def_action_fold_ip / cnt_p_3bet_def_opp_ip) * 100

and the 2 columns used

Code: Select all

sum(if[holdem_hand_player_statistics.enum_p_3bet_action='F'
 AND holdem_hand_player_statistics.position < holdem_hand_player_detail.val_p_raise_aggressor_pos, 1, 0])

Code: Select all

sum(if[holdem_hand_player_statistics.flg_p_3bet_def_opp
AND holdem_hand_player_statistics.position < holdem_hand_player_detail.val_p_raise_aggressor_pos
, 1, 0])

Fold to Preflop 3bet when out of position

Code: Select all

(cnt_p_3bet_def_action_fold_op / cnt_p_3bet_def_opp_op) * 100

Code: Select all

sum(if[holdem_hand_player_statistics.enum_p_3bet_action='F'
 AND holdem_hand_player_statistics.position > holdem_hand_player_detail.val_p_raise_aggressor_pos, 1, 0])

Code: Select all

sum(if[holdem_hand_player_statistics.flg_p_3bet_def_opp
AND holdem_hand_player_statistics.position > holdem_hand_player_detail.val_p_raise_aggressor_pos
, 1, 0])

For the fold stats I only defined whether Players position was bigger or smaller than aggressor. So if facing a limp-reraise and you fold, it would appear as if you folded to a 3bet when in position.

I assume that the "facing a 3 bet" columns indicate only the preflop aggressor?
What if Player A raise, Player B calls, and player C reraises, is Player B then facing a 3 bet? Or if Player A raise, player B reraise, is player C then facing a 3-bet?
I tried to find the definition for these stats, but no luck (maybe just looked in the wrong place?)

[WhiteRider]

I assume that the "facing a 3 bet" columns indicate only the preflop aggressor?
What if Player A raise, Player B calls, and player C reraises, is Player B then facing a 3 bet? Or if Player A raise, player B reraise, is player C then facing a 3-bet?
I tried to find the definition for these stats, but no luck (maybe just looked in the wrong place?)

Preflop, the BB is the 1-bet, Player A's raise is a 2-bet.
So in the first case, Player A faces a 3-bet; in the second case (when Player B reraises, i.e. 3-bets) Player C faces a 3-bet.
A player can face a 3-bet whether they already made any action or not.