Open Shove by Stack Size

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Open Shove by Stack Size

Postby Melkien » Sun Jan 13, 2013 8:10 am

Hello! I've been trying to make an open shove stat like in CoffeeHud divided by stack size.

For the general stat Open Shoved Preflop, this works:
Code: Select all
(cnt_p_os / cnt_p_open_opp ) * 100

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

cnt_p_open_opp = sum(if[tourney_hand_player_statistics.flg_p_open_opp, 1, 0])


Yet, when I try to do it for, for example, 12-15bb, it doesn't work:
Code: Select all
(cnt_p_os_12_15bb / cnt_p_open_opp_12_15bb ) * 100

cnt_p_os_12_15bb = sum(if[tourney_hand_player_statistics.flg_p_first_raise AND tourney_hand_player_statistics.flg_p_open_opp AND amt_p_raise_made>=amt_p_effective_stack AND amt_p_effective_stack<15 AND amt_p_effective_stack>=12, 1, 0])

cnt_p_open_opp_12_15bb = sum(if[tourney_hand_player_statistics.flg_p_open_opp AND amt_p_effective_stack>=12 AND amt_p_effective_stack<15, 1, 0])



Any help is appreciated! :)
Melkien
 
Posts: 27
Joined: Thu May 31, 2012 12:04 am

Re: Open Shove by Stack Size

Postby kraada » Sun Jan 13, 2013 10:31 am

You need to specify the tables with your fields - that is, instead of amt_p_effective_stack use tourney_hand_player_statistics.amt_p_effective_stack.

Basically all of your additions that don't have tourney_hand_player_statistics. in front of them need that :)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Open Shove by Stack Size

Postby Melkien » Sun Jan 13, 2013 6:20 pm

Thanks!!!
Melkien
 
Posts: 27
Joined: Thu May 31, 2012 12:04 am

Re: Open Shove by Stack Size

Postby Melkien » Mon Jan 14, 2013 10:36 am

I tried changing it but no result :(. I made it with all the Open Shoved stats and columns, for instance:

With Open Shoved Preflop 12-15bb:
Code: Select all
Stat -> Open Shoved Preflop 12-15bb: (cnt_p_os_12_15bb / cnt_p_open_opp_12_15bb ) * 100

Columns ->  cnt_p_os_12_15bb: 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_hand_player_statistics.amt_p_effective_stack AND tourney_hand_player_statistics.amt_p_effective_stack<15 AND tourney_hand_player_statistics.amt_p_effective_stack>=12, 1, 0])

cnt_p_open_opp_12_15bb: sum(if[tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.amt_p_effective_stack>=12 AND tourney_hand_player_statistics.amt_p_effective_stack<15, 1, 0])



Thanks!
Melkien
 
Posts: 27
Joined: Thu May 31, 2012 12:04 am

Re: Open Shove by Stack Size

Postby WhiteRider » Tue Jan 15, 2013 4:42 am

What exactly isn't working?
Do the columns not validate or are you getting bad data?

I wouldn't expect it to matter, but try putting spaces around your comparison operators - the >= and < for example.
That will help legibility even if it isn't actually required.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Open Shove by Stack Size

Postby aramalho » Tue Jan 15, 2013 8:26 am

Hi, it doesn't validate: ''you cannot use multiple aggregate funcions in a single column''


By, the way. is it possible for you guys to add me moderators to add me on skype? I want to make a hourly rate $ offer for PT4 personal explanation. my skype is Aramalho20, thank you very much.
aramalho
 
Posts: 85
Joined: Tue Jul 10, 2012 10:21 am

Re: Open Shove by Stack Size

Postby Melkien » Tue Jan 15, 2013 9:56 am

Actually, it is validating in my PT4, but when I try it with the hud it shows no data at all.
Melkien
 
Posts: 27
Joined: Thu May 31, 2012 12:04 am

Re: Open Shove by Stack Size

Postby kraada » Tue Jan 15, 2013 1:14 pm

armalho,

Are you creating two separate columns? That error implies you have multiple aggregates - like sum(), and given what you pasted here for the two separate columns each only has one sum().

melkien,

Are you seeing 0/0 constantly or are you not even seeing that populate?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Open Shove by Stack Size

Postby BillGatesIII » Tue Jan 15, 2013 1:41 pm

You will not see any results because tourney_hand_player_statistics.amt_p_effective_stack is the effective stack in chips, not in big blinds.

Will this stat be for HU only?
BillGatesIII
 
Posts: 740
Joined: Fri Dec 16, 2011 6:50 pm

Re: Open Shove by Stack Size

Postby kraada » Tue Jan 15, 2013 3:26 pm

Ah, good catch - divide tourney_hand_player_statistics.amt_p_effective_stack by tourney_blinds.amt_bb to convert it into big blinds.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: Amazonbot and 41 guests

cron