Call vs minraise stat

[supaflyer]

Hi Guys,

I'm trying to write a HU stat, which shows in how many percentages calls the enemy call our minraises.

I've tried it with the following definition:

(cnt_p_mr_call / cnt_p_mr_call_opp) * 100

cnt_p_mr_call
sum(if[(tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb) <= 2.25 AND lookup_actions_p.action LIKE 'C', 1, 0])

cnt_p_mr_call_opp
sum(if[(tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb) <= 2.25 AND lookup_actions_p.action LIKE '_', 1, 0])

My stat is not working properly, could you please tell me where is the problem? :S It also counts the SB limp as an opportunity to call a min raise.

Where is the problem in my stat?

Thanks,
supaflyer

[kraada]

Because 0 is less than 2.25 -- if you always want this to be heads up and you always want it to be from the big blind's perspective, you can set that fraction to exactly 1 -- because the big blind when facing a minraise has 1bb to call.

Once you do that it should work properly I think.

[supaflyer]

I've modified it in the following way:

cnt_p_mr_call
sum(if[(tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb) <= 1 AND lookup_actions_p.action LIKE 'C', 1, 0])

cnt_p_mr_call_opp
sum(if[(tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb) <= 1 AND lookup_actions_p.action LIKE '_', 1, 0])

Now, after the BB limped the stat did show (100 %) 1/1, however he didn't face a min raise... I'm really confused...

[kraada]

= 1, not <= 1. When you have it as <= 1, 0 matches. It's 0 when he doesn't face a raise and you don't want that.

[supaflyer]

Thanks, it works now.

One more question. I've tried to adjust it to a non-HU version. How should I redefine the columns in that case? I would like to get a stat, which shows in how many percentage does the enemy call a raise between 2 and 2.25 bb.

Thank you in advance!

[kraada]

You need it to be = 1 when the player is in the BB, = 1.5 when the player is in the SB and = 2 otherwise.

[supaflyer]

Hi,

I know what you mean, but I would like to have a generic stat, which shows how many % calls the enemy vs min raises, regardless his position.

Now I've setted up the following:

(cnt_p_mr_call_generic / cnt_p_mr_call_opp_generic) * 100

cnt_p_mr_call_generic
sum(if[(tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb) <= 2.25 AND lookup_actions_p.action LIKE 'C', 1, 0])

cnt_p_mr_call_opp_generic
sum(if[(tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb) <= 2.25 AND lookup_actions_p.action LIKE '_', 1, 0])

I've defined the minraise as a raise between 2 and 2.25bbs. However this doesn't work for me. It shows as an opportunity, when somebody makes a 3x raise, and the player is on the bb, and he has 2 bb to call. Could you please help me how to create a generic stat?

thanks,
supaflyer

[WhiteRider]

You can add the amount of blind posted to make it more general. For example:

((tourney_hand_player_statistics.amt_p_raise_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) <= 2.25

However, if the player doesn't face a raise then amt_p_raise_facing is zero, so will be less than 2.25, so you should probably use "between", like:

((tourney_hand_player_statistics.amt_p_raise_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) BETWEEN 1.5 AND 2.25

[supaflyer]

Thanks,

It looks ok now.

Cheers,
supaflyer

[LosingPlayer]

Hey,

i copied the aforementioned definitions for the columns and the custom stat, but i get the "invalid" expression notification when i try to implement the statistic.
The columns :

cnt_p_mr_call :=
sum(if[(tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb) = 1 AND lookup_actions_p.action LIKE 'C', 1, 0])

cnt_p_mr_call_opp :=

sum(if[(tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb) = 1 AND lookup_actions_p.action LIKE '_', 1, 0])

seem to work, but when i try to tell PT4 to compute:

(cnt_p_mr_call / cnt_p_mr_call_opp) * 100,

it doesnt validate the expression.

I have imported the column names both by copy and paste and the built in selection function to ensure that there is no font/ spelling errors in the reference.

I just recently switched to PT and have not used SQL in quite a while so please bear with me if my question turns out rather redundant.