Call vs minraise stat

[Flag_Hippo]

That's working OK for me so try importing the attached stat instead. If you have any further trouble please open a Support Ticket and report your problem so we can investigate further.

[F.A.Hayek]

Hi!! I´m totally new making custom stats.

I was trying to make the same stat, But only for BB calling SB minraise (2bb only). I have this, from this post:

Stat: BB calls SB MR
(cnt_p_mr_call / cnt_p_mr_call_opp) * 100

Column 1: 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])

Column 2: 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])

And it´s working fine for Heads Up. But i want the same stat for 3 players hand i have to specify the agressor is SB. I red in anotaher i have to introduce this text:
char_length(cash_hand_summary.str_aggressors_p) >= 2 AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int = 9

But i don´t know where or how introduce it. (and i suposse i have to change "cash" for "tourney").

Thanks
char_length(cash_hand_summary.str_aggressors_p) >= 2 AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int = 9

[Flag_Hippo]

Stat: BB calls SB MR

I recommend adding tourney_hand_player_statistics.position = 8 if you don't want to count instances where the SB calls a minraise e.g. SB limps, BB minraises.

Column 2: 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])

Looking again at this thread lookup_actions_p.action LIKE '_' should be changed to lookup_actions_p.action LIKE '_%' otherwise if the SB minraises, BB 3Bets & SB 4Bets then that isn't going to be counted as an opportunity to call a minraise 2Bet for the BB.

Stat: BB calls SB MR

If you want to ensure that the SB was first to act you can add this:

Code: Select all

tourney_hand_summary.str_actors_p LIKE '9%'

See this post for more information on how the actors and aggressors strings work.

[F.A.Hayek]

Sorry but i don´t know how to do this.
Where have i to add this lines??

tourney_hand_player_statistics.position = 8

tourney_hand_summary.str_actors_p LIKE '9%'

I´ve tried adding first in the stat and second one in the column 1: cnt_p_mr_call, like this:

sum(if[tourney_hand_summary.str_actors_p LIKE '9%' AND tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb) = 1 AND lookup_actions_p.action LIKE 'C', 1, 0])

but is wrong, i received the message: "The statement is not valid SQL"

i saw this in the post you recommended:
sum(if[cash_hand_player_statistics.position=9 and cash_hand_player_statistics.flg_p_3bet and cash_hand_summary.str_aggressors_p LIKE '80%' and cash_hand_summary.str_actors_p LIKE '09%', 1, 0])

[F.A.Hayek]

Hi again, i´m seeing this line too, in another posts:

substring(tourney_hand_summary.str_actors_p from 1 for 1)::int = 9, 1, 0

but i don´t know how to add in my previous text...

Thanks

[F.A.Hayek]

All rigth, i think it´s working now. I think it must to be a sintasix mistake. What i have now is:

Stat: BB call SB ORx2
(cnt_p_bb_call_sb_mr / cnt_p_mr_call_opp) * 100

Column 1: cnt_p_bb_call_sb_mr
sum(if[tourney_hand_player_statistics.position = 8 and (tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb) = 1 and tourney_hand_summary.str_actors_p LIKE '9%' AND lookup_actions_p.action LIKE 'C', 1, 0])

Column 2: 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])

I think everything is working now. Thank you so much

[Flag_Hippo]

Yes all you did was accidentally remove one of a pair of brackets from the original code which will invalidate it. Also for complete accuracy you should add tourney_hand_player_statistics.position = 8 to the other column as well and rename it if your using cnt_p_mr_call_opp in other statistics.

[F.A.Hayek]

Great! I just did, thanks for the improve.

[F.A.Hayek]

Hi again.
I have an issue with the stat i´ve created. The thing is when i put the mouse over the stat, is not showing the number of cases, only the final value. It´s happening with some stats but not all of them and i don´t know why.
Before we make the improvments, when i put the cursor of the mouse over the box of the stat i can see if a value of 50 is 2/4 cases or 12/24.

[Flag_Hippo]

The 'Value Expression' expression for your custom statistic needs to be in the following format for times/opportunities to show in the tooltip:

(a / b) * 100