3bet by position vs position

[Lans86]

Hello. I'm trying to make a stat which is showing the Villain's 3bet at BU vs CO, when CO raises first in (none opens before, so it's actually a steal)

Code: Select all

(cnt_p_3bet_BUvsCO / cnt_p_3bet_opp_BUvsCO) * 100

cnt_p_3bet_BUvsCO

Code: Select all

sum(if[cash_hand_player_statistics.flg_p_3bet AND
cash_hand_player_statistics.position = 0 AND
cash_hand_player_statistics.cnt_p_face_limpers = 0 AND
cash_hand_player_detail.val_p_raise_aggressor_pos = 1, 1, 0])

cnt_p_3bet_opp_BUvsCO

Code: Select all

sum(if[cash_hand_player_statistics.flg_p_3bet_opp AND
cash_hand_player_statistics.position = 0 AND
cash_hand_player_statistics.cnt_p_face_limpers = 0 AND
cash_hand_player_detail.val_p_raise_aggressor_pos = 1, 1, 0])

Is it gonna work? I'm asking cuz found the old thread on PT3 forums and it was said, this is not gonna work due to PT3 database sctructure. If it works, so I can do it for every position, right?
Does detail.val_p_raise_aggressor_pos work properly? Want to make 3bets IP/OOP vs every position open raise (couldn't find this one in defaults)
Regards.

[Lans86]

One more thing please, what the difference between following stats: 3bet vs MP 2bet and 3bet vs MP Open? Guess one of those includes limper preflop. If so, which one?

Regards.

[WhiteRider]

One more thing please, what the difference between following stats: 3bet vs MP 2bet and 3bet vs MP Open? Guess one of those includes limper preflop. If so, which one?

The "2Bet" stat includes limpers - this is any 2Bet, whereas "open" implies a "raise first in" - i.e. the player opened the action with a raise.

Firstly, you don't need to make stats specifically for each position because you can set any stat to display by position using the HUD "position" property.

cash_hand_player_detail.val_p_raise_aggressor_pos suffers from the same issue in PT4 as it did in PT3 - it is the position of the last player other than the active player to make a raise preflop.
However, in PT4 we have a new mechanism which stores the position of each raiser. This is "cash_hand_summary.str_aggressors_p".
I'm afraid I don't have time now to go into detail about this, but if you search the forums for it I think you'll find some explanations, and have a look at the columns used for stats like "3Bet vs BTN 2Bet" (or vs BTN Open, which I think is what you're wanting to create versions of) which utilize this. If you compare the stats for different vs positions I think you'll see how it works.

[Lans86]

WhiteRider Thank you for response. I spent some time learning how this stat works and guess I had to find out. Could you please take a look at the stats I did?
Here is a part of popup I made which shows the Villains play on the BB vs certain position of steal. (same stats I did for an SB play vs CO and BU, and there is same discrepancy as here)


I dont get it - why the sum of the actions doesn't give me 100%? (70.27+13.51+13.51 = 97.29 which is missing 2.71%) The sample size isn't huge but still something like 40 attempts to steal the blind.
Here is how I do calculate this:

Code: Select all

(cnt_steal_def_action_fold_BBvsBU / cnt_steal_def_opp_BBvsBU) * 100

cnt_steal_def_action_fold_BBvsBU =
sum(if[cash_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action = 'F' AND
cash_hand_player_statistics.position = 8 AND
cash_hand_summary.str_aggressors_p LIKE '80%' AND
cash_hand_summary.str_actors_p LIKE '0%', 1, 0])

cnt_steal_def_opp_BBvsBU =
sum(if[cash_hand_player_statistics.flg_blind_def_opp AND
cash_hand_player_statistics.position = 8 AND
cash_hand_summary.str_aggressors_p LIKE '80%' AND
cash_hand_summary.str_actors_p LIKE '0%', 1, 0])

The same way I calculated other actions, like "call" and "3bet" vs certain position, just changing the lookup_actions_p.action = 'F' to either 'C' or 'R and aggressors/actors position. The rest kept the same.

[Lans86]

Probably I did a mistake somewhere in 3bet or call situations. Would you mind checking this please?
A call situation
cnt_steal_def_action_call_BBvsBU =
sum(if[cash_hand_player_statistics.flg_blind_def_opp AND
lookup_actions_p.action = 'C' AND
cash_hand_player_statistics.position = 8 AND
cash_hand_summary.str_aggressors_p LIKE '80' AND
cash_hand_summary.str_actors_p LIKE '0%', 1, 0])

3bet:
cnt_steal_def_action_3bet_BBvsBU =
sum(if[cash_hand_player_statistics.flg_blind_def_opp AND
lookup_actions_p.action = 'R' AND
cash_hand_player_statistics.position = 8 AND
cash_hand_summary.str_aggressors_p LIKE '808%' AND
cash_hand_summary.str_actors_p LIKE '0%', 1, 0])

[Lans86]

Ahaha, I've found it! Should have type it like that:
lookup_actions_p.action LIKE 'R%' with LIKE 'R%' for either 3bet and call situation xDD

P.S. but I still don't get why does p.action need to include those situations, where there were more actions exept one raise...(is it what the '%' means, isnt it?)

[WhiteRider]

Yes – that's right.
If the BB 3Bets and the stealer re-raises then the BB has to make another action so their actions won't just be 'R', so your original expression won't count those.
'R%' includes raise then any other actions (including no further actions).

[szenna12]

Hello. I'm trying to make a stat which is showing the Villain's 3bet at BU vs CO, when CO raises first in (none opens before, so it's actually a steal)

You can use 3Bet vs CO Open


Change the Position (Button)

[Lans86]

WhiteRider heya thank you!, gotta ask one more thing while you're here
I have certain popups for every stat of HUD. When I try opening them by clicking a stat, sometimes I get something like this:

Can I somehow turn it off? I want my custom popups to be opening quick without getting these ones.
Also, if I click between stats to a background area, I get the black and ugly one pop (a default one, lol). Wanted to know if I can turn it off as well.
Spent days making my own popups with stats, so now it would be really great having them working perfect



Regards.

[kraada]

Those tooltips are displayed when your mouse is not moving over a stat - they are not configurable at this point but if you keep yourself from hovering over a stat for any period of time they should not appear.

If you want to get rid of the default popup, remove the popups linked to the Table Group on the Table Groups tab and then nothing will happen if you click in the general background area.