positional 3bet oop called

[Alexkidd103]

i created this column (positional 3bet opp for each position in this case hijack)
sum(if[holdem_hand_player_statistics.flg_p_3bet_opp AND holdem_hand_player_statistics.position = 2 , 1, 0])

But i don't understand how to create a colum for times the player called the 3bet opp any help?
there is a colum that with the name cnt_p_pfr_call and the description Number of times player called a preflop raise.
But it doesn't seem clear to me what constitutes a raise for this colum, for example maybe a player had the 3bet opp, did the 3bet, faced a 4bet, and called, that could constitute a raise that was called?
if that doesn't count as a raise, would this work?

sum(if[holdem_hand_player_statistics.flg_p_3bet_opp AND holdem_hand_player_statistics.flg_p_fold = false AND holdem_hand_player_statistics.cnt_p_raise=0 AND holdem_hand_player_statistics.position = 2, 1, 0])

it doesn't seem to wrk because the holdem_hand_player_Statistics.flg_p_fold , can be true anyway, for example a player called a 3bet opp, face a squeeze, and then fold, then it would be true, but for the porpouses of my statics, HE DID CALL.

[Alexkidd103]

I also don't understand the Flag first raise in. It does count if there was a limper? it works if you are in the BB or SB?
also about the cold call, it's possible to cold call in the sb and bb?
what's EXACTLY counts as cold call preflop?

I want to make a raise % that counts when there is a limper behind, but don't count the times you 3bet, etc.

[WhiteRider]

"Raise First In" means that you were the first to enter the pot and you raised. (holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp = true)
If there was a limper before you, then you didn't raise first in, although you could still make the first raise (holdem_hand_player_statistics.flg_p_first_raise = true, but holdem_hand_player_statistics.flg_p_open_opp = false). If you want a stat to count how often you make the first raise after there's a limper in the pot - this is the way.

Cold Call means to call a raise when you don't yet have any money in the pot - so you can't cold call from the blinds.
This will give you your stat from the first post ("how to create a colum for times the player called the 3bet opp") but not when you're in the blinds.

[Alexkidd103]

Thanks a lot
Then the solution to make the 3bet oop called on the blinds is?

[Alexkidd103]

and if i use the 3bet opp columdn and the cold called colum, there would be a problem. sometimes you can have 3bet opp an cold call and don't fit what i would like to count.

6max
UTG raises
CO(Hero) CALL
SB 3bet
BB 4bet
UTG CALL
CO (HERO) CALL

Now hero had a 3bet op and also Cold called. But of course i don't want to count this hand as positive.
there is a filter in the pt3 that is 3bet opp called, but don't know how to reproduce that.

***********
What means the cnt_p_call?
it says number of times player called a bet preflop
What constitutes a bet? a 3bet? 4bet? only raises?

[Alexkidd103]

sorry my example was bad, that was not what i meant, i will give the example right this time, i would edit but you don't seem to be able to after certain time.

here it goes
UTG Raises
CO (hero) 3bet
BUtton 4bet
Utg 5bet
CO (hero) call

in this case the player did have a 3bet opp and also cold called, and don't fit what i want.

Maybe putting a condition of 3bet and 4bet false?

[Alexkidd103]

sum(if[ holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_p_3bet = false AND flg_p_3bet_opp AND holdem_hand_player_statistics.flg_p_fold = false, 1 , 0 ])

would this work to count the number fo times a player cold called on the BB when facing a Steal?

this wouldn't work too?
sum(if[ holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_p_3bet = false AND flg_p_3bet_opp AND flg_vpip = false, 1 , 0 ])

[WhiteRider]

Working out that 'calling a single raise (2-bet) from the blinds' thing is quite difficult. This is NOT a cold call because you already have money in the pot.
You can find out your first action using this:
substring(lookup_actions_p.action from 1 for 1)='C'
(see the Custom Statistics and Reports FAQ for info on this)
..so you could check for a 3-bet opportunity and calling as your first action - that should do it.

[Alexkidd103]

how does the filter that says "3 bet opp called" works, i would like to have that as a stat or colum, and i don't see how , if there is a filter, it should be easy to reproduce, doesn't it?

[Alexkidd103]

I just figured out how to do it with your idea using the substring, hope it works

uhu i don't get why i should do 2 from 1 instead of 1 from 1 :S