The new expression variables and semantic

[js2002]

this is fold to 5bet+

sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 5 AND cash_hand_player_statistics.position NOT BETWEEN substring(cash_hand_summary.str_aggressors_p from 4 for 1)::int and substring(cash_hand_summary.str_aggressors_p from 5 for 1)::int and cash_hand_player_statistics.enum_p_4bet_action = 'F', 1, 0])

Huh, u know how experienced I am. I dont understand the stats/columns anymore.
Can sb. explain every part of it?

I try:

cash_hand_summary.str_aggressors_p = ok the string gets +1 in length for every Raise, I guess
cash_hand_player_statistics.position NOT BETWEEN substring(cash_hand_summary.str_aggressors_p from 4 for 1)::int = ??? huh?
....???....

cash_hand_player_statistics.enum_p_4bet_action = 'F' = why 4bet defend action? thought it must be 5bet def action so: sth like
cash_hand_player_statistics.enum_p_5bet_action = 'F'

[kraada]

str_aggressors_x is a string composed of numbers. Each number in the string is, in order, the position of a player who was aggressive. Preflop is a special case and always starts with 8 - this way the position of the 2bet is the second number in the string and so on.

So if str_aggressors_p = 808 we know the open raise was from the button and the big blind 3bet and there was no 4bet.

In the case of this stat we first make sure the length of str_aggressors_p is greater than or equal to 5 - so we're only looking at hands that were 5 bet or greater.

Then we look at your position and make sure it isn't between the person who 4bet (which is what the substring gets) and the person who 5bet as we want to ignore cases where you actually folded to the 4bet in a 5bet or higher pot.

Then we check to make sure you folded to a 4bet or higher.

[js2002]

Still dont get the part:

NOT BETWEEN substring(cash_hand_summary.str_aggressors_p from 4 for 1)::int and substring(cash_hand_summary.str_aggressors_p from 5 for 1)::int

can u talk baby english please?
"it isn't" WHAT ? is not between...?

This would help: Why this exp and what are the @return values (format, plain text, the concret result) ?
I thought 4th pos returns the posi number of the 4bettor? so why u compare (between key word) 2 positions?


example:

BU 3 and 5 bets
HJ 2 and 4bets

String = "8XX20"

NOT BETWEEN 2 AND 0 ? So u ask for position 1? why?
Ok my position shall not be between, but why?

2.question: so the stat is not filtered to the person who made the 4bet?

[js2002]

3. "where you actually folded to the 4bet in a 5bet or higher pot." how can I fold to a 4bet in a 5bet+ pot?

[kraada]

NOT BETWEEN substring(cash_hand_summary.str_aggressors_p from 4 for 1)::int and substring(cash_hand_summary.str_aggressors_p from 5 for 1)::int

cash_hand_summary.str_aggressors_p from 4 for 1 is the position of the 4bettor.

So if the 4bet came from the HJ this value would be 2.

cash_hand_summary.str_aggressors_p from 5 for 1 is the position of the 5bettor.

So if the 5bet came from the BTN this value would be 0.

We want you to not be position 1 in this case because you faced the 4bet - we want to exclude cases where you face the 4bet. Anybody else folding to a 4bet+ in this hand folded to a 5bet or higher as this is the only person who faced the 4bet itself and might have folded to it.

2.question: so the stat is not filtered to the person who made the 4bet?

No, that would be a different stat.

[js2002]

NOT BETWEEN substring(cash_hand_summary.str_aggressors_p from 4 for 1)::int and substring(cash_hand_summary.str_aggressors_p from 5 for 1)::int

cash_hand_summary.str_aggressors_p from 4 for 1 is the position of the 4bettor.

So if the 4bet came from the HJ this value would be 2.

cash_hand_summary.str_aggressors_p from 5 for 1 is the position of the 5bettor.

So if the 5bet came from the BTN this value would be 0.

We want you to not be position 1 in this case because you faced the 4bet - we want to exclude cases where you face the 4bet.

Who is "you" ? the "Player" whose stat I am watching?!
I dont understand, why u do exclude the the case where the "Player" faces a 4bet.


Anybody else folding to a 4bet+ in this hand folded to a 5bet or higher as this is the only person who faced the 4bet itself and might have folded to it.

And what has this sentence to do with it?
I guess I need my new pm answered and 2 or 3 example cases where the exp matches and some where it does not match.
Sry I really dont get this expression, still.

2.question: so the stat is not filtered to the person who made the 4bet?

No, that would be a different stat.

thats ok, to be sure I say: this pt4 Fold to 5bet+ Stat counts also aggro action tables and hands wer u are f.e. in die CO and you didnt put money in the pot and so coldface :) a 5bet. (correct me if i talk bull)