Raise First In non all-in by stack size

[Dfebras]

Hello need some help please! I have been researching the forum here for the past few hours but couldn't figure it out the right Value Expression to put in my new stat, i wanted to make a stat for RFI (not all-in) for specifics stacks sizes.
This is what i have so far for 15-20bb range:

Column 1 : cnt_p_rfi_between_15_and_20
sum(if[tourney_hand_player_statistics.flg_p_first_raise AND tourney_hand_player_statistics.flg_p_open_opp and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 15 and 20, 1, 0])

Column 2 : cnt_p_open_opp_between_15_and_20
sum(if[tourney_hand_player_statistics.flg_p_open_opp and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 15 and 20, 1, 0])

Column 3 : rfi_nallin
tourney_hand_player_statistics.amt_p_raise_made < (tourney_hand_player_statistics.amt_before * 0.8)

Then on the Value Expression for the new stat i have no idea on how to write all the 3 Columns togheter, could someone please tell me exactly how it would look like? what i have is ((cnt_p_rfi_between_15_and_20 - cnt_p_open_opp_between_15_and_20) / (rfi_nallin)), but it doesn't work

Thank you

[Flag_Hippo]

Code: Select all

(cnt_p_rfi_between_15_and_20 - cnt_p_open_opp_between_15_and_20)

This is going to give you a negative number since the number of opportunities will be greater than the actions. Assuming you want the percentage of times a player raised non-allin with stack sizes in this range you can use two columns in this format:

Code: Select all

(a / b) * 100

Put the information from your first and third columns in a single column:

cnt_p_rfi_between_15_and_20_NAI

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_first_raise AND (tourney_hand_player_statistics.amt_p_raise_made < (tourney_hand_player_statistics.amt_before * 0.8)) and tourney_hand_player_statistics.flg_p_open_opp and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 15 and 20, 1, 0])

and then you can use:

Code: Select all

(cnt_p_rfi_between_15_and_20_NAI / cnt_p_open_opp_between_15_and_20) * 100

[Dfebras]

Nice it works, thank you! ill check on the report now if it is catching the spots accurately

[Dfebras]

didn't work, i rfi from the small blind with 17bb and my stat remained with the "-" sign as if no opportunity had arised or no raise made, and someone with 85bb at the table had his stat with the number "0" and said 0/1 when mouse rover over it but he never had less that that stack

[Dfebras]

this is how my tracker looks like:

cnt 1.png

first column

(27.66 KiB) Downloaded 3240 times

cnt 2.png

2nd column

(23.81 KiB) Downloaded 3254 times

rfistat.png

Stats expression

(30.26 KiB) Downloaded 3228 times

[Dfebras]

Filtered 15 to 20bb on the bottom left, and 3 hands came up where i RFI with that stack size as shown on the 2 hands on top and the replayer on the right, and when i rover my mouse over the stat on the far right in the picture (the stat is next to the red stat which is number of hands) it says 0 0/1, what could be wrong? thank you! sry about the 4 posts in a row

report1.png

(406.35 KiB) Downloaded 3258 times

[Flag_Hippo]

didn't work, i rfi from the small blind with 17bb and my stat remained with the "-" sign as if no opportunity had arised or no raise made

Your custom stat uses tourney_hand_player_statistics.amt_p_effective_stack. What was the stack of the big blind? If they had less then 15bb then your effective stack will be the same. The effective stack for each player is determined at their first action in the hand and it's the amount a player could lose in a pot as of their first action in the hand.

and someone with 85bb at the table had his stat with the number "0" and said 0/1 when mouse rover over it but he never had less that that stack

A players effective stack can be lower depending on who was left to act when they made their first action and you might also have data from a different tournament. Finally if you haven't already done so you should rebuild your custom database cache via 'Database -> Database Management -> Rebuild Cache -> Custom Cache Rebuild'.

Filtered 15 to 20bb on the bottom left

You are filtering for actual stack and not effective stack.

and when i rover my mouse over the stat on the far right in the picture (the stat is next to the red stat which is number of hands) it says 0 0/1

Click the 'Options' button in the replayer and make sure 'HUD Stat Values at Time of Hand' is turned off otherwise the data will not include the hand you are looking at.

[Dfebras]

Oh, how can I do it by the actual stack size of the raiser? Instead of the effective. What columns or expressions I need to change please?

[Flag_Hippo]

how can I do it by the actual stack size of the raiser?

You are already using that elsewhere in your custom statistic:

Code: Select all

tourney_hand_player_statistics.amt_before

[Dfebras]

i don't get it, which column should be changed and where?