3Bet Preflop vs Hero

[potamito]

Nah i cant go through all that, i understand PC stuff above average and defend myselff creating custom stats modifying existing one but this is too much for me, i think i´ll pay someone to do it

[bruzi]

You can try this general fold to hero's 3bet preflop. Made it from the top of my head and didn't test it so don't know if it's any good.

cnt_p_face_3bet_fold_vs_hero

Code: Select all

sum(if[cash_hand_player_statistics.enum_p_3bet_action = 'F' 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_vs_hero

Code: Select all

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

Is there anyone willing to send me if have or help me to make these two stats for cash game: 3Bet vs Hero and Fold to 3Bet v Hero
Thank you...

[fnopeaw]

I tried the code of the first post but PT4 is telling me the column cannot be cached.

[kraada]

That's true, it cannot be cached. So it will be a bit slower in practice, but it will work.

[potamito]

Trying to creat a BB re-steal vs HERO SB RFI 00bb-11bb effective stack stat but im having problems with the columns expressions, here´s what i got thus far..

cnt_resteal_att_bb_vs_hero_00_11

Code: Select all

sum(if[tourney_hand_player_statistics.amt_p_raise_facing < ((tourney_hand_player_statistics.amt_p_effective_stack/ tourney_blinds.amt_bb) between 0 and 11) and tourney_hand_player_statistics.flg_blind_def_opp 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_00_11

Code: Select all

sum(if[tourney_hand_player_statistics.amt_p_raise_facing < ((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 0 and 11)  and tourney_hand_player_statistics.flg_blind_def_opp 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])


Anybody?

[kraada]

I think what might work better is shifting the raise size into the hero portion and testing hero.amt_p_raise_made to be between the size you want.

[potamito]

So if i wanted to created a Re-Steal vs HERO BTN/CO/HJ Open i just have to make a Re-Steal vs HERO stat and just config the 3bettor position on the item properties tab, right?

[kraada]

No, you'd need to set the hero's position in the subquery.

[ZeDawning]

Hello,

Is there a stat where it shows how much villain has gotten 3bet by Hero?

[ZeDawning]

Any help to create the stat (or has it been made?) would be really appreciated