3Bet Preflop vs Hero

[pt4pt4pt4]

What was different tho, was that your OPP only calculated the present session opps of Villains 3 bet while the orig 3 bet opp stat counted all the previous SNG games hands.

Could you please explain this more in detail? Because it should count all the opportunities this opponent had to make a 3bet against hero. Not only from this session (assuming you are displaying lifetime stats and not session stats).

Sorry, my Test HUD was all messed up.
Works perfect.

So if i want Steal BB / SB vs BTN / CO HERO stats:

I need 4 separate stats with each blind having having it's item properties as position SB and BB.

For designating HERO position, how do I include this tourney_hand_player_statistics.position = 0

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_3bet 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.flg_p_first_raise), 1, 0])

into your column expression? I get invalid SQL when I throw it inside.

[kraada]

sum(if[tourney_hand_player_statistics.flg_p_3bet 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.flg_p_first_raise and hero.position = 0), 1, 0])

[pt4pt4pt4]

Any thoughts on this?

I just wanted to try to test HERO stats steal from SB and BTN in opps.

The position is set as any position for the HUD stat. What happens is everyone at the table is summed properly except the players in the blinds (s).

Everyone except the SB sum is incremented.

cnt_steal_att_sb_HERO

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_open_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.flg_p_first_raise and hero.position = 9), 1, 0])

Everyone except the SB & BB sum is incremented.

cnt_steal_opp_HERO_BTN

Code: Select all

sum(if[tourney_hand_player_statistics.flg_steal_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.flg_p_first_raise and hero.position = 0), 1, 0])

[kraada]

I'm confused by what you've put together now - you'll never have a steal opportunity from the SB when the button (who is hero) already opened.

[pt4pt4pt4]

I'm confused by what you've put together now - you'll never have a steal opportunity from the SB when the button (who is hero) already opened.

Those are two separate stats.

When both are included in the HUD, Villains sum up the steal OPPs from HERO properly. The only problem with both stats is that Villains in the blinds will not sum up HEROs steal opps.

If a player is not in the blinds then the stat works.

[pt4pt4pt4]

Maybe I didn't make it clear.

Players do not increment their HERO stat values while in the blinds. Any player outside the blinds will increment their HERO stats properly and displayed in the HUD.

Blind players do not have the stat enabled. I have ANY Position in the item properties.

[kraada]

I'm still not following what you're doing with these columns.

Let's look at: sum(if[tourney_hand_player_statistics.flg_p_open_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.flg_p_first_raise and hero.position = 9), 1, 0])

This column adds up how many times a player has a chance to open and the hero did in fact open from the SB. This will never trigger for the BB (hero in the SB already opened, so flg_p_open_opp is false) and will trigger for everyone before the SB, but in that case they will always have folded. So what good is this column?

[pt4pt4pt4]

I'm still not following what you're doing with these columns.

These would be vs Hero stats for the SB steal. I checked them and they seem to work w/o any problem. I set it up that it only sums the value if they are 3 or more players.

The first part of the column are players facing a raise, which is for the players in the blinds. The second part of the column is for players before Hero who have the option of opening the pot.

If you have any thoughts let me know.


cnt_steal_opp_sb_vs_HERO

Code: Select all

(
sum(

case when (if[tourney_hand_player_statistics.flg_p_face_raise AND tourney_hand_player_statistics.cnt_players > 2 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.flg_p_open_opp
   and hero.flg_p_first_raise and hero.position = 9)])

or

(if[tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.cnt_players > 2 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.flg_p_open_opp
and hero.position = 9)])

then 1 else 0 end
)
)


cnt_steal_att_sb_vs_HERO

Code: Select all

(
sum(

case when (if[tourney_hand_player_statistics.flg_p_face_raise AND tourney_hand_player_statistics.cnt_players > 2 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.flg_p_open_opp
   and hero.flg_p_first_raise and hero.position = 9)])

or

(if[tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.cnt_players > 2 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.flg_p_open_opp
and hero.flg_p_first_raise and hero.position = 9)])

then 1 else 0 end
)
)



[pt4pt4pt4]

This is the correct column for

cnt_steal_opp_sb_vs_HERO

Code: Select all

(
sum(

case when (if[tourney_hand_player_statistics.flg_p_face_raise AND tourney_hand_player_statistics.cnt_players > 2 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.flg_p_open_opp
   and hero.flg_p_first_raise and hero.position = 9)])

or

(if[tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.cnt_players > 2 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.flg_p_open_opp
and hero.position = 9)])

or

(if[NOT tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.cnt_players > 2 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.flg_p_open_opp
and hero.flg_p_limp
and hero.position = 9)])

or

(if[NOT tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.cnt_players > 2 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.flg_p_open_opp
and hero.flg_p_fold
and hero.position = 9)])

then 1 else 0 end
)
)


[kraada]

Your column seems confused to me. Let's look at the last one:

case when (if[tourney_hand_player_statistics.flg_p_face_raise AND tourney_hand_player_statistics.cnt_players > 2 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.flg_p_open_opp
and hero.flg_p_first_raise and hero.position = 9)])

This piece adds up times we face a raise when the hero opened when he was in the SB. Since he opened, we must be in the big blind facing a SB raise.

(if[tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.cnt_players > 2 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.flg_p_open_opp
and hero.position = 9)])

Here we had a chance to open when hero was in the SB and had a chance to open. This will return 1 for all hands where we folded in earlier position and it was folded to the SB. I suspect this part is not what you want.

(if[NOT tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.cnt_players > 2 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.flg_p_open_opp
and hero.flg_p_limp
and hero.position = 9)])

Here the hero open limped the SB and we didn't have a chance to open, so we must have been in the BB with the ability to raise.

(if[NOT tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.cnt_players > 2 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.flg_p_open_opp
and hero.flg_p_fold
and hero.position = 9)])

Here the hero open folded in the SB. And this will count all hands we open folded in earlier position. I also don't think you want this situation.

Can you explain the two that have bolded comments after? Because I see them as only giving you bad data here.