need some help with positional stat: Fold to 4B

[kydechuk01]

Hi!

I'm trying to build custom stat: BTN 3Bet vs CO Open & Fold to 4-Bet

Formula:
( cnt_p_BTN_v_CO_open_3Bet_fold_to_4Bet / cnt_p_BTN_v_CO_open_3Bet_face4B ) * 100

Columns:

cnt_p_BTN_v_CO_open_3Bet_face4B =
sum(if[cash_hand_player_statistics.position=0 AND lookup_actions_p.action LIKE 'R%' AND cash_hand_player_detail.val_p_raise_aggressor_pos=1 AND cash_hand_player_statistics.flg_p_4bet_def_opp, 1, 0])

cnt_p_BTN_v_CO_open_3Bet_fold_to_4Bet =
sum(if[cash_hand_player_statistics.position=0 AND lookup_actions_p.action LIKE 'RF' AND cash_hand_player_detail.val_p_raise_aggressor_pos=1 AND cash_hand_player_statistics.flg_p_4bet_def_opp, 1, 0])

But it only counts situations when the initial raiser (CO) 4-bets and does not count then Hero 3Bets and facing 4Bet from SB or BB (aggressor changes).

Can you help me - how to make this stat complete?

[kraada]

You don't want to use val_p_raise_aggressor_pos - we have better ways at picking out who made the first raise in PT4. Take a look at cnt_p_3bet_vs_co_open - you'll want to use some of the techniques we have there and that's pretty similar to where you want to be.

The string str_aggressors_p is a list of the position of all aggressive actors preflop - it always starts with 8 for the big blind, then the position of the 2bettor comes next, so if the 2bet came from the CO it would start 81. You can see the way we use this string in the aforementioned column, but I thought I would explain exactly what is going on here for you.

[kydechuk01]

Thank you!

Can you check the new version? Did I made it right?

cnt_p_BTN_v_CO_open_3Bet_fold_to_4Bet =
sum(if[cash_hand_player_statistics.position=0 AND lookup_actions_p.action LIKE 'RF' AND cash_hand_summary.str_aggressors_p LIKE '810%' AND cash_hand_summary.str_actors_p LIKE '1%' AND cash_hand_player_statistics.flg_p_4bet_def_opp, 1, 0])

cnt_p_BTN_v_CO_open_3Bet_face4B =
sum(if[cash_hand_player_statistics.position=0 AND lookup_actions_p.action LIKE 'R%' AND cash_hand_summary.str_aggressors_p LIKE '810%' AND cash_hand_summary.str_actors_p LIKE '1%' AND cash_hand_player_statistics.flg_p_4bet_def_opp, 1, 0])

For me it looks right but for my test sampe this stat still shows value 19/59 (face CO 4bet) and it must show 29/59 (facing all 4bets)

[WhiteRider]

Those expressions look good to me - I can't see why that wouldn't include times the player faces a 4-bet from one of the blinds instead of from the cutoff. (Is that what you mean?)
If you can find a hand which is incorrectly included (or not) by this stat please attach it to a Support Ticket and post your ticket number here so that we can see what is going on.

[kydechuk01]

Sorry, it was my mistake - I used a duplicate of old stat in the HUD and missed it. All works fine with new version!

If somebody is interested - I'm attaching working version of these stats:

Fold Resteal to 4-Bet.pt4stat - common for SB and BB
Fold Resteal to 4Bet (BTN).pt4stat - version for BTN vs CO Steal
BB vs SB Open - Fold to 4Bet.pt4stat - version for BB vs SB

[WhiteRider]

That's great - thanks for sharing!