val_r_bet_size not defined for a river probe bet?

[Waingro13]

Hello,
I would like to compare how player defense rates adapts against under- vs oversized river probe bets.
Tried to adapt cnt_r_probe_def_action_call column as below:

Code: Select all

sum(if[cash_hand_player_statistics.amt_r_bet_facing > 0 and
       cash_hand_player_statistics.flg_t_cbet_opp and
       lookup_actions_t.action = 'X' and
       not(cash_hand_player_statistics.flg_r_open_opp) and
       lookup_actions_r.action LIKE 'C%' and
       val_r_bet_size < 6, 1, 0])


The same adaptation worked well with cnt_r_float_def_action_call and cnt_r_donk_def_action call but not here. Could you explain please?

BTW which is the difference here between val_r_bet_size and val_r_2bet_size, I mean in a river probe bet situation?

May be this might be replaced by

cash_hand_player_statistics.val_r_bet_made_pct

which is defined as

Percentage of pot this player bet on river

but this is not clear in my mind.
Let's say pot is 100 and player A probe bets 50, hence player B has 50 to put in a 150 pot.
So here which is the value of cash_hand_player_statistics.val_r_bet_made_pct for player B?

[Ventilatorrr]

Hello,

I'm not sure if val_r_bet_size is appropriate to be used in your example, but you can use val_r_bet_facing_pct instead.

BTW which is the difference here between val_r_bet_size and val_r_2bet_size, I mean in a river probe bet situation?

val_r_bet_size is about river bets, and val_r_2bet_size is about river raises, they aren't about facing bets/raises and so don't reflect the situation you are trying to capture.

So here which is the value of cash_hand_player_statistics.val_r_bet_made_pct for player B?

I don't think val_r_bet_made_pct would apply for player B as they didn't make a bet, they are facing it. You'd need to use cash_hand_player_statistics.val_r_bet_facing_pct instead, and it's value would be (50 / 150) * 100 = 33%.

[Waingro13]

Thx for your help.
BTW I have written it differently because, even for the 2 other cases (donk and float), actually the variable does not contain what I expected.

Code: Select all

sum(if[cash_hand_player_statistics.amt_r_bet_facing > 0 and
       cash_hand_player_statistics.flg_t_cbet_opp and
       lookup_actions_t.action = 'X' and
       not(cash_hand_player_statistics.flg_r_open_opp) and
       lookup_actions_r.action LIKE 'C%' and
       cash_hand_player_statistics.val_r_bet_facing_pct > 100, 1, 0])