3Bet Preflop vs Hero

[barabu]

Hi.

I have done everything but I have a doubt, I want to know the 3bet BB vs SBHero, a personal stats. But I don't know how to do it.

The original stat that you wrote in the first post is done, and I have added this:


But I need to put in the stats or columns or wahtever my open raise in SB, but I have no idea.

Any sugerence?

[kraada]

You can add in "and hero.position = 9" in the columns to restrict it to times the hero was in the SB.

[barabu]

""and hero.position = 9" this is ok for filters but for stas in HUD I can't see anything like that.


In wich column?



If there is the option A, how would it be?



Or something similar?

[kraada]

You put that inside the subquery in the column you're going to build.

[barabu]

In this column:




Y put this:



But it doesn't work because I have more cases vs me than vs rest.

Edi: Now I have add "and hero.position = 9" in " cnt_p_3bet_opp_vshero" and I have the same problem.

[kraada]

That should limit those columns to times someone 3bet vs hero when hero was in the SB and made the first raise. I'm not certain exactly what you're seeing that's incorrect; could you elaborate for me please?

[barabu]

Nah, thank you so much.

Finally I have restarted the PT4 and everything goes right.

[potamito]

If you want to specify the position of hero, you'll have to do that in the stat expression. If you want to specify the position of the opponent, you can use the Position property.

So if i create this fold vs hero 3bet stat and i go to item properties to change the position it would be for villains position and not from where HERO is actually 3betting?

[kraada]

That's correct.

[potamito]

Hi,

thanks, I changed it to tourney and add an (effective stack < 20BB) condition and it seems good.

I made the resteal stat too:
Hero is SB, villain is BB, effective stack < 20BB and nobody is comitted (if the raising is lower than the half of the eff stack)

cnt_resteal_att_bb_vs_hero:

sum(if[tourney_hand_player_statistics.amt_p_raise_facing < (tourney_hand_player_statistics.amt_p_effective_stack * 0.5) and tourney_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action LIKE 'R%' and ((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 20) and exists
(select 1
from tourney_hand_player_statistics hero
where hero.id_hand = tourney_hand_player_statistics.id_hand
and hero.flg_hero
and hero.position = 9), 1, 0])

cnt_resteal_opp_bb_vs_hero:

sum(if[tourney_hand_player_statistics.amt_p_raise_facing < (tourney_hand_player_statistics.amt_p_effective_stack * 0.5) and tourney_hand_player_statistics.flg_blind_def_opp and ((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 20) and exists
(select 1
from tourney_hand_player_statistics hero
where hero.id_hand = tourney_hand_player_statistics.id_hand
and hero.flg_hero
and hero.position = 9), 1, 0])

Is it good?
(sry, with wich tag can i copy to code form?)

emano85

Trying to figure it out using this to create a re-steal vs HERO stat when hero RFI from the SB, BTN, CO and HJ