WWoSD %

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

WWoSD %

Postby yserman » Thu Nov 10, 2011 12:44 pm

Hello guys!I wanna know if it impossible to make non showdown win % stat for HuD?
Now we have separate stats of WWoSD-won without showdown for preflop,for flop,turn and river.
Another words -is it possible to combine this stats and make it one stat?
yserman
 
Posts: 14
Joined: Thu Nov 10, 2011 12:22 pm

Re: WWoSD %

Postby kraada » Thu Nov 10, 2011 5:38 pm

Certainly - you can do this via the columns that already exist as a custom statistic. Please see our Tutorial: Using Custom Statistics and Reports for help in creating custom statistics.

One note though: given that a player has many more chances to win hands without showdown preflop and on the flop, combining the chances directly will result in a very heavily weighted number - you may want to keep that in mind when assessing how you would intend to use this statistic.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: WWoSD %

Postby yserman » Mon Nov 14, 2011 9:19 am

Please help me to do this stat(Total win without showdown)!!!What's the formula(value exression) for it?
In advice thanks!!
yserman
 
Posts: 14
Joined: Thu Nov 10, 2011 12:22 pm

Re: WWoSD %

Postby yserman » Mon Nov 14, 2011 9:56 am

yserman wrote:Please help me to do this stat(Quantity of winnings without showdown)!!!What's the formula(value exression) for it?
In advice thanks!!
yserman
 
Posts: 14
Joined: Thu Nov 10, 2011 12:22 pm

Re: WWoSD %

Postby kraada » Mon Nov 14, 2011 9:59 am

It does depend slightly on how you want to count opportunities. If you want to count any flop seen, for flop it'd be ((cnt_wwosd_f_bet_raise + cnt_wwosd_f_call) / cnt_f_saw) * 100 . If you want to count only times you didn't fold on the flop (that is times you bet/raised/called) it'd be ((cnt_wwosd_f_bet_raise + cnt_wwosd_f_call) / (cnt_f_bet_raise_hands + cnt_f_call_hands)) * 100

To make turn and river versions change _f_ to _t_ or _r_ respectively.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: WWoSD %

Postby yserman » Mon Nov 14, 2011 12:30 pm

How can i make a stat to be displayed not like a percent but like a number.
For example, if we take a W$wsd- in the HuD after some hands played we will see something like this- 50%=1/2.(1 hand won from 2 )
I want only the number of won instead of percent was displayed (the amount of hands won, not a percent of winnings).How can i do this??
Thanks!
yserman
 
Posts: 14
Joined: Thu Nov 10, 2011 12:22 pm

Re: WWoSD %

Postby WhiteRider » Mon Nov 14, 2011 6:12 pm

Duplicate the existing stat (or build a new one similar) and remove, or do not include, the division and multiplication by 100 in the Value Expression. The Format Expression can then be:
/%.0f
..since you do not need decimal places.

e.g. If the Value Expression of the normal percentage stat is:
(cnt_actions / cnt_opportunites) * 100
..your "count" stat's expression would just be:
cnt_actions
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: WWoSD %

Postby yserman » Tue Nov 15, 2011 7:37 am

Thanks!But there's one problem yet-In the HuD the indicators of "value" are shown,not the indicators of "This session"
How to solve it?
Sorry for my english!
yserman
 
Posts: 14
Joined: Thu Nov 10, 2011 12:22 pm

Re: WWoSD %

Postby kraada » Tue Nov 15, 2011 9:42 am

There isn't anything special that should need to be done to see the "this session" value as long as you are showing it for all stats - the setting to show it for all stats is on the Hud Options tab in the Hud Configuration window.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: WWoSD %

Postby yserman » Tue Jan 10, 2012 5:52 pm

Hi again.I know that the topic is old but anyway i think that it will be much better to write here and not to create new one.Especially because the subject of a problem is the same.
The problem is that I've reinstalled my computer os and poker tracker with it..Thats why all of custom stats made by me were gone.I tried to make new ones but It has turned out nothing...Please,can you explain once again to me what i'm doing wrong.

I'm trying to make won without showdown stat. I made 2 columns: first is - cnt_won_wo_sd: sum(if[not(holdem_hand_player_statistics.flg_showdown) and holdem_hand_player_statistics.flg_won_hand, 1, 0])
and the second one is - cnt_hands_wo_sd: sum(if[not(holdem_hand_player_statistics.flg_showdown) and holdem_hand_player_statistics.flg_vpip, 1, 0])
Then i made a tournament player stat by the formula- cnt_won_wo_sd / cnt_hands_wo_sd (i need only value not percentage that's why i do the formula is like this) and the format expression is /%.0f. But while the game is running poker tracker doesn't calculate that stat...0 value and nothing more.Please help me!
yserman
 
Posts: 14
Joined: Thu Nov 10, 2011 12:22 pm

Next

Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 11 guests

cron