Stats sens

[raph156]

Hi,
i would like, % time player win when there is a 10 25 bb pot. Thise column ar right to create thise stat? The first count final pot 10 25bb, and the other final pot 10 25bb and win? That count at showdown and when other player fold, so any case to win?
sum(if[holdem_hand_summary.amt_pot BETWEEN ( 10*holdem_limit.amt_bb) AND ( 25*holdem_limit.amt_bb) , 1, 0])
sum(if[holdem_hand_summary.amt_pot BETWEEN ( 10*holdem_limit.amt_bb) AND ( 25*holdem_limit.amt_bb) and holdem_hand_player_statistics.flg_won_hand, 1, 0])
Thanks for help.

[raph156]

The solution to have the pot on a street if no one bet is may be, have the total bet for the street befor and that no one has fold. So the total bet on the flop and no one fold = total pot on the turn.
What the expression could be?
I know that but dont find the right expression
sum(if[holdem_hand_player_detail.amt_bet_f
holdem_hand_player_statistics.flg_f_fold
(lookup_actions_f.action SIMILAR TO '(F|XF)%')
thanks for help

[kraada]

That would work, though you might want to look at hands where the player in question at least saw the flop (or put money in) - otherwise if a player folds UTG and other players build a pot of the appropriate size it would count against him.

I've tried to build the pot sizes that way previously and taking account of all cases is quite difficult. These database fields will be available in PT4 so if you are looking to build stats that use pot sizes per street you are probably better off waiting a little while until PT4 is available.

[raph156]

thats only for HU for moment. So, what you said is pot size on a particular street when there is no bet is hard cause many case to be count? And any events when win and pot size 10 25 is right?

[kraada]

If there's a bet on a flop you can calculate for flop pot size. If there's no flop bet but there's a turn bet then you can calculate flop pot size based on the turn bet. If there's no flop and no turn bet but there's a river bet the same thing holds. Then if there's no betting, it's the total pot size.

[raph156]

I come back on thise stats, i have modified it but there is always no resulte, whats wrong?
( ffbf_opp49 ) * 100 / ( fbf_opp49 )
ffbf_opp49
sum( if[holdem_hand_player_detail.val_f_bet_facing_pct>50 and holdem_hand_player_detail.amt_f_bet_facing BETWEEN ( 4*holdem_limit.amt_bb) AND ( 9*holdem_limit.amt_bb) AND (lookup_actions_p.action SIMILAR TO '(F|XF)%'), 1, 0])
fbf_opp49
sum( if[holdem_hand_player_detail.val_f_bet_facing_pct>50 and holdem_hand_player_detail.amt_f_bet_facing BETWEEN ( 4*holdem_limit.amt_bb) AND ( 9*holdem_limit.amt_bb) , 1, 0])

Im always searching thise expression but look difficult.
sum( if[ holdem_hand_player_detail.flg_f_open_opp and holdem_hand_player_detail.amt_f_bet_made<0 « when pot flop is BETWEEN ( 10*holdem_limit.amt_bb) AND ( 25*holdem_limit.amt_bb) »
I have to found it based on turn bet or river bet or final pot but dont works.

Thanks for help

[raph156]

there is thise misstake : lookup_actions_p.action SIMILAR TO '(F|XF)%'
the right expression is : lookup_actions_f.action SIMILAR TO '(F|XF)%'
But amways no unmbers in my summary tab.

[WhiteRider]

Did you fill in the Format tab of your new stat? If that isn't filled in then the stat won't work in reports.

[raph156]

Tab format was alright. I have numbers now, but not enough and they have no sens.
So i tryed with thise stats,( without holdem_hand_player_detail.val_f_bet_facing_pct>50), the numbers are correct but not really what i want.
( ffbf_opp49 ) * 100 / ( fbf_opp49 )
ffbf_opp49
sum( if[ holdem_hand_player_detail.amt_f_bet_facing BETWEEN ( 4*holdem_limit.amt_bb) AND ( 9*holdem_limit.amt_bb) AND (lookup_actions_f.action SIMILAR TO '(F|XF)%'), 1, 0])
fbf_opp49
sum( if[holdem_hand_player_detail.val_f_bet_facing_pct>50 and holdem_hand_player_detail.amt_f_bet_facing BETWEEN ( 4*holdem_limit.amt_bb) AND ( 9*holdem_limit.amt_bb) , 1, 0])
The same stats for a "raise" so...
sum( if[ holdem_hand_player_detail.amt_f_bet_facing BETWEEN ( 4*holdem_limit.amt_bb) AND ( 9*holdem_limit.amt_bb) AND (lookup_actions_f.action SIMILAR TO '(r|Xr)%'), 1, 0])
fbf_opp49
sum( if[holdem_hand_player_detail.val_f_bet_facing_pct>50 and holdem_hand_player_detail.amt_f_bet_facing BETWEEN ( 4*holdem_limit.amt_bb) AND ( 9*holdem_limit.amt_bb) , 1, 0])
have really not enough number with or without holdem_hand_player_detail.val_f_bet_facing_pct>50 ( 4 number on 100 player and there is 5 stats in thise case)
Thanks for help

[WhiteRider]

For one thing all of the action characters need to be uppercase - ie. 'R' not 'r'.
If you still have problems with the values your stats are giving you please export them and attach them to a Support ticket and explain exactly what they are supposed to be counting and we'll check them out for you. Please include a link to this thread as a reference.