3Bet Preflop vs Hero

[WhiteRider]

To do that I think you would just omit the part before the "select" which specifies that the player had a 3bet-def-opp and made the first raise.

[ZeDawning]

Heh. I tried and it didn't work. Pretty sure that w/e the change I made was wrong.

Could you tell exactly how the code should look like. My trial and error method just didnt work.

Numerator: cnt_p_first_raise_hero_3bet_def_opp
sum(if[cash_hand_player_statistics.flg_p_3bet_def_opp and cash_hand_player_statistics.flg_p_first_raise and exists
(select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero
and hero.flg_p_3bet), 1, 0])

Denominator: cnt_p_first_raise_hero_3bet_opp
sum(if[cash_hand_player_statistics.flg_p_first_raise and exists
(select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero
and hero.flg_p_3bet_opp), 1, 0])

So here, the expression on the first line "cash_hand_player_statistics.flg_p_3bet_def_opp and cash_hand_player_statistics.flg_p_first_raise and exists" and "cash_hand_player_statistics.flg_p_first_raise and exists" is only villain-specific.
So for me to know how villain perceives my overall 3bet in his HUD, it should mean that he was dealt in the hand.

I couldn't find any expression (through browsing other stats) for this.

Help appreciated

[kraada]

Looking at your code I think you're a bit confused about what the stat is going to do. Right now your columns tell you how often a player faced a 3bet when hero made it, and the other tells you how often hero had a chance to 3bet. I think what you want is to change the former to how often hero actually 3bet -- we don't really care if we don't face the 3bet directly or not (as someone might 4bet in between but we'd still want it to count). If that's right, remove "cash_hand_player_statistics.flg_p_3bet_def_opp and" from the first one and you should be good. If that's really what you want though, that's what they do at this point.

[ZeDawning]

It wasnt what I was looking for kraada.

Basically it should be:
3bet by hero when villain and hero was dealt in / 3bet opp. by hero when villain and hero was dealt in

i.e. I dont care if villain made first raise or open folded etc. All that matters is that he was in the hand and saw me 3bet (either him or another).

I think I found a solution. When I tested a bit, it worked so it must be correct right? xD

I swapped the first line w "cash_hand_player_statistics.position>-1 and exists"

This is ok?

[4StarGen]

I'd like to create a stat when Hero folds to specific Villain 3bet, is it possible?

(I didn't read the thread but I will in a few moments)

[kraada]

ZeDawning: Yes, that will work; it guarantees that villain was dealt in and nothing more.

4StarGen: Yes, the techniques here will work for that.

[4StarGen]

^ gonna read the whole thread then, ty

[ZeDawning]

On the same vein as my last stat, I tried building a fold to 4bet stat which villain sees in his HUD vs me.

Numerator:
sum(if[cash_hand_player_statistics.position>-1 and exists
(select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero
and hero.enum_p_4bet_action = 'F'), 1, 0])

Denominator:
sum(if[cash_hand_player_statistics.position>-1 and exists
(select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero
and hero.flg_p_4bet_def_opp), 1, 0])

Does this look ok?
And in the column summary type should it be "sum" or "count"?

[kraada]

You want summary type Sum. That will work but remember that it presumes a player you are playing against uses a HUD and has always used a HUD and has his entire lifetime of hand histories to rely upon. These are far from guaranteed.

[4StarGen]

From a programming POV, is there a way to test this difficult stats, or any stat in general?