RFI by stacksize

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny

RFI by stacksize

Postby nherrego » Wed Mar 15, 2017 7:45 pm

I build a custom stat for Raise first in for 75 to 1000 bb deep and only includes opens 2x to 4x but it is not working:
it shows values bigger then 100

(cnt_p_raise_first_in_75 / cnt_p_open_opp_75 ) * 100

cnt_p_raise_first_in_75 :
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_raise_made / tourney_blinds.amt_bb)between 2 and 4)) and ((((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) >= 75 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 1000 ) and true) , 1, 0])

cnt_p_open_opp_75 :
sum(if[(tourney_hand_player_statistics.flg_p_open_opp ) and ((((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) >= 75 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 1000) and true)), 1, 0])
nherrego
 
Posts: 64
Joined: Wed May 04, 2011 7:46 am

Re: RFI by stacksize

Postby Flag_Hippo » Thu Mar 16, 2017 6:06 am

nherrego wrote:cnt_p_raise_first_in_75 :
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_raise_made / tourney_blinds.amt_bb)between 2 and 4)) and ((((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) >= 75 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 1000 ) and true) , 1, 0])

You have two mismatched brackets (highlighted in red) in the actions column so try removing those. FYI you can copy expressions into Notepad++ which highlights matching brackets automatically.
Flag_Hippo
Moderator
 
Posts: 9749
Joined: Tue Jan 31, 2012 7:50 am

Re: RFI by stacksize

Postby nherrego » Thu Mar 16, 2017 5:33 pm

it still shows a value that is bigger then 100 after deleting those
nherrego
 
Posts: 64
Joined: Wed May 04, 2011 7:46 am

Re: RFI by stacksize

Postby Flag_Hippo » Thu Mar 16, 2017 8:07 pm

Please attach your stat to a Support Ticket so we can take a look at that for you.
Flag_Hippo
Moderator
 
Posts: 9749
Joined: Tue Jan 31, 2012 7:50 am

Re: RFI by stacksize

Postby potamito » Fri Mar 17, 2017 4:50 pm

...custom stat for Raise first in for 75 to 1000 bb deep and only includes opens 2x to 4x...

I made this, try it....

Action Column
Code: Select all
sum(if[tourney_hand_player_statistics.flg_p_open_opp and  tourney_hand_player_statistics.flg_p_first_raise and (tourney_hand_player_statistics.amt_p_raise_made / tourney_limit.amt_bb) BETWEEN 2 and 4  and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 75 and 1000 , 1, 0])


Opportunity Column
Code: Select all
sum(if[tourney_hand_player_statistics.flg_p_open_opp and (tourney_hand_player_statistics.amt_p_raise_made / tourney_limit.amt_bb) BETWEEN 2 and 4  and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 75 and 1000 , 1, 0])
potamito
 
Posts: 802
Joined: Wed Apr 21, 2010 4:20 pm

Re: RFI by stacksize

Postby WhiteRider » Sat Mar 18, 2017 3:55 am

nherrego wrote:it still shows a value that is bigger then 100 after deleting those

Did you rebuild the custom cache after you made your change? If not, your cache will still have the old values.
To do that go to Database > Database Management and click Rebuild Cache > Custom Cache Rebuild.
WhiteRider
Moderator
 
Posts: 53447
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: RFI by stacksize

Postby nherrego » Sat Mar 18, 2017 3:56 pm

I did rebuild the cache. I will try potamito hes stat after the weekend. thnx
nherrego
 
Posts: 64
Joined: Wed May 04, 2011 7:46 am

Re: RFI by stacksize

Postby nherrego » Sat Mar 18, 2017 9:31 pm

The action stat from potamita shows invalid sql when i try to save it
nherrego
 
Posts: 64
Joined: Wed May 04, 2011 7:46 am

Re: RFI by stacksize

Postby WhiteRider » Sun Mar 19, 2017 4:30 am

There's a typo there. This:
(tourney_hand_player_statistics.amt_p_raise_made / tourney_limit.amt_bb)
..should be this:
(tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb)
..in both columns.
WhiteRider
Moderator
 
Posts: 53447
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 1 guest

cron
highfalutin