Open shov - 15-20 bb's ; 10-15 bb's & 1-10bb's

[TRFelicio]

Hi Guys,

I found a state already requested for open Shoves. However, I would like to understand how can I split this state to give me the information depending on the amount of Big Blinds Vilan have.


My goal was to have something like:
- Open shove: 15-20 bb's
- Open shove: 10-15 bb's
- Open shove: 1-10 bb's


Can you please advise if this is something possible to the set?

Thanks,

[Flag_Hippo]

There is an example of that here.

[TRFelicio]

Thanks, the example make much sense of how to build custom stats.
Unfortunately following your guidance on step one (below), I could not find the expression for the open shove - "cnt_p_open_shove" - on the "search".

Is it due to be a statistic manually added?

"If you want to modify for example the Stat PFR, go to Statistics under the Configuration Window, Search for the Stat PFR (click on the Stat),
Now you see on the right side the Stat and "Value Expression": (cnt_pfr / cnt_pfr_opp) * 100

1st Step: copy "cnt_pfr". Now click on the top right on "Columns" and paste it into the "Search:" window on the bottom left.
Select the exact Column ("cnt_pfr"). Now you should see this Expression on the right side:
Code: Select all
sum(if[tourney_hand_player_statistics.cnt_p_raise > 0, 1, 0])"

I was able to do the example you show for PFR, but for this specific statistic I could not.

Please let me know your thoughts.

Thanks,

[Flag_Hippo]

Unfortunately following your guidance on step one (below), I could not find the expression for the open shove - "cnt_p_open_shove" - on the "search".

From your first post it sounds like you already have a custom statistic for 'Open Shove' so go to 'Configure -> Statistics -> Stats' and select your open shove custom statistic. Once it's selected you can see what the column names are for this stat on the 'Definition' tab under 'Value Expression:'.

[TRFelicio]

Either way, the expression is much complex than the PFR shown in the previous example.

Are you able to clarify what should be added to the standard expression for open shove below,

sum(if[tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack and tourney_hand_player_statistics.flg_p_first_raise and tourney_hand_player_statistics.flg_p_open_opp, 1, 0])

Your help will be much appreciated.

Thanks,

[Flag_Hippo]

sum(if[tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack and 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])

[TRFelicio]

Hi Hippo,

I added the expression in red you provide and it says "The statement is not valid SQL".


Are you able to verify on your side where is the error?

Thanks,

[Flag_Hippo]

The code I posted works:

Please attach your own screenshot here or in a Support Ticket.

[TRFelicio]

Hi,

I tried once again and it work out. Do not know why it gave error previously.

Thank you once again

[WhiteRider]

That's good to hear - thanks for confirming!