3Bet Preflop vs Hero

[kraada]

The comment bruzi quotes above on this page gives you the columns you need to build the stat you want.

[ZeDawning]

Could you please have a look at this?

cnt_p_face_3bet_vs_hero / cnt_p_face_3bet_opp_vs_hero * 100

cnt_p_face_3bet_vs_hero
sum(if[cash_hand_player_statistics.flg_p_3bet_def 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])

cnt_p_face_3bet_opp_vs_hero
sum(if[cash_hand_player_statistics.flg_p_3bet_def_opp 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])

[kraada]

Your naming is a little odd - to make it how often someone folds when hero 3bets you want to replace cash_hand_player_statistics.flg_p_3bet_def in the first column with cash_hand_player_statistics.enum_p_3bet_action = 'F' - the column names don't really matter they just threw me for a moment.

[ZeDawning]

Im kinda confused. I want to know how much each villain has been 3bet by me.

So it should be something like:
No. of times Hero 3bets villain / No. of times Hero had opportunity to 3bet villain
right?

So the 'fold' action you suggested isnt needed right?

Though when i tried out the code I entered, it says not valid SQL func.

Thoughts?

[kraada]

That's not what you've built (and not what I thought you were asking for). What you've built is how often someone folds when hero 3bets them. Before I go into it further: Do you want to restrict it to times the villain made the first raise, or not?

[ZeDawning]

Yep, when the villain made first raise.

[kraada]

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])

[ZeDawning]

Ty Kraada <3

Btw, is there some kind of PT4 guide towards coding?

[WhiteRider]

We don't include vs Hero stats in our guides because we don't recommend them, but the Tutorial: Custom Reports and Statistics has quite a few examples of how to make stats. It was written for PT3 but the principals still apply in PT4.

[ZeDawning]

Not sure if this is possible, but can I build a stat to my hud to see how much villain perceives my overall 3bet in his HUD (not only vs him)?