wond at sd after river bet with size

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

wond at sd after river bet with size

hi, in my popup i have a stat called "won at sd after river bet"
is there a way to create the same stat but with a size range?
for example
wsd after river bet 10-40 40-60 60-85 85-100 100-135 135-165
ty
alessandrocorvi

Posts: 9
Joined: Thu Jul 05, 2012 5:09 pm

Re: wond at sd after river bet with size

You can specify a players bet size as a percentage of the pot on the river using cash_hand_player_statistics.val_r_bet_made_pct.
Flag_Hippo
Moderator

Posts: 12388
Joined: Tue Jan 31, 2012 7:50 am

Re: wond at sd after river bet with size

Flag_Hippo wrote:You can specify a players bet size as a percentage of the pot on the river using cash_hand_player_statistics.val_r_bet_made_pct.

how can i use that formula?
(cnt_wtsd_won_when_r_bet / cnt_r_bet_hands_SD) * 100
this is the expression for the stat

now i want to split that stat in a range of size for example won at sd when river bet a size between 20 and 40% of the pot.
what i have to do with your formula? can you show me an example? so i can use the same formula for all other ranges of size

ty
alessandrocorvi

Posts: 9
Joined: Thu Jul 05, 2012 5:09 pm

Re: wond at sd after river bet with size

See this post. The example there is for stack size but the principle is the same.
Flag_Hippo
Moderator

Posts: 12388
Joined: Tue Jan 31, 2012 7:50 am

Re: wond at sd after river bet with size

thank you!
alessandrocorvi

Posts: 9
Joined: Thu Jul 05, 2012 5:09 pm

Re: wond at sd after river bet with size

Flag_Hippo wrote:See this post. The example there is for stack size but the principle is the same.

i'm sorry but i think i did something wrong.
i duplicated the stat and added the code as you can see in the screenshot
using the filters on the first opponent i found 19 hands but the stat counts only 4 of them.
why? what i did wrong? how can i fix?
ty
Attachments
filters.PNG (5.94 KiB) Viewed 149 times
column2.PNG (11.11 KiB) Viewed 149 times
alessandrocorvi

Posts: 9
Joined: Thu Jul 05, 2012 5:09 pm

Re: wond at sd after river bet with size

1. After you make any changes to custom columns you should rebuild your custom database cache via 'Database -> Database Management -> Rebuild Cache -> Custom Cache Rebuild'.

2. You are filtering for the hand going to showdown (via 'Hand Details') and not the player (via 'Actions & Opportunities -> River').

3. You are filtering for 3-10 players but that isn't specified in your custom statistic.

4. Also if you are getting the data for the statistic from the HUD make sure you are not using any HUD filters.
Flag_Hippo
Moderator

Posts: 12388
Joined: Tue Jan 31, 2012 7:50 am

Re: wond at sd after river bet with size

Flag_Hippo wrote:1. After you make any changes to custom columns you should rebuild your custom database cache via 'Database -> Database Management -> Rebuild Cache -> Custom Cache Rebuild'.

2. You are filtering for the hand going to showdown (via 'Hand Details') and not the player (via 'Actions & Opportunities -> River').

3. You are filtering for 3-10 players but that isn't specified in your custom statistic.

4. Also if you are getting the data for the statistic from the HUD make sure you are not using any HUD filters.

u r right i had "last 4 weeks" in hud options.
the stats works properly
ty again
alessandrocorvi

Posts: 9
Joined: Thu Jul 05, 2012 5:09 pm