Saw flop stat and float bet stat question

[Suboptimal88]

sum(if[cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.flg_p_face_raise, 1, 0]) i use this column then i filter for 3bettor position to check how much i get 3bet from an individual position , is the column correct?

I want to create a column to check how much i get called but i cant find any similar to other pt4 stats , how can i modify the above column then filter for caller position to see how much i get called?

[kraada]

Is that what you meant to paste? As it is it's redundant - you specify flg_p_first_raise twice.

[Suboptimal88]

Is that what you meant to paste? As it is it's redundant - you specify flg_p_first_raise twice.

no the second is face raise not first raise , i tried to mimic this column from this one which is a built in column sum(if[cash_hand_player_statistics.flg_r_cbet AND cash_hand_player_statistics.flg_r_face_raise, 1, 0]) , this means how much i get raised when i cbet on river , isnt the same for preflop? , why am i wrong?

[kraada]

Ah, I'm blind. That would count any times you open raise and face a cold 4bet or higher though -- it doesn't restrict to exactly 3bets. That would be cash_hand_player_statistics.flg_p_3bet_def_opp.

[Suboptimal88]

i think i found what i wanted , will this count the times i get called? sum(if[cash_hand_player_statistics.flg_p_first_raise AND (lookup_actions_p.action SIMILAR TO '(C|XC)%'), 1, 0]) ? it got validated but im not sure , i need to add to this column AND (callers position=x) , how do i do this?

I think this will do but can you confirm it? AND substring(cash_hand_summary.str_actors_p from '.$')::int =1 , if i add this to the above will it count how much i get called from the co when i raise? also im not sure what to add at the *$* i mean i dont know what it means.

[kraada]

No, that won't work. lookup_actions_p.action is your personal action sequence - so '(C|XC)' will count times you just call or check call first then do other things, which it won't do ever if you made the first raise. If you are going to exclude 3bet pots you can just check the number of players on the flop - cash_hand_summary.cnt_players_f.

substring(cash_hand_summary.str_actors_p from '.$')::int gives you the value of the position of the last player to put money in the pot preflop.

[Suboptimal88]

i made this one sum(if[cash_hand_player_statistics.flg_p_first_raise AND cash_hand_summary.cnt_players_f = 2 AND substring(cash_hand_summary.str_actors_p from 2 for 1)::int = 0 , 1, 0]) , f = 2 means 2 players in the flop or 2 without the raiser? , also from 2 for 1 what does it mean? i see everyone use this on substring columns but i dont know what it means , lastly this column got validated , it gives me some values on the button too which is strange , does it tell you how much you get called outside of the button and the value on the button means how much you called a first in raise?

[kraada]

cnt_players_f is the number of players still in the hand at the start of the flop. It doesn't care how they got there, it's just a pure count.

substring(cash_hand_summary.str_actors_p from 2 for 1)::int = 0

means the second person who put money in the pot preflop was on the button.