Help with these PT3 custom stats, please !

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

Help with these PT3 custom stats, please !

Postby Costel » Sun May 26, 2013 12:18 pm

First one is Net Winning Percentage (NWP):
Code: Select all
Net Winning Percentage (NWP) = ((number of hands won WITHOUT showdown)/(number of hands played)) x 100


Second one is Showdown winning percentage (SWP):
Code: Select all
Showdown winning percentage (SWP) = ((number of hands won at showdown) / (number of hands played)) x 100


I want the code formula please but I want also the stats themselves in order to import them into my PT3 because I don't know how to create them.

Thank you in advance !

PS: Be aware everywhere is "number of hands" and not bigblinds or something else.
Costel
 
Posts: 139
Joined: Wed Apr 18, 2012 10:05 am

Re: Help with these PT3 custom stats, please !

Postby kraada » Mon May 27, 2013 6:40 am

Most of this data already exists and you don't need new columns. You just need to recombine columns that already exist in your new stat.

The one new column you would need is:
cnt_wwosd: sum(if[holdem_hand_player_statistics.flg_won_hand and not(holdem_hand_player_statistics.flg_showdown), 1, 0])

The stats would be defined as follows:

NWP: (cnt_wwosd / cnt_hands) * 100
SWP: (cnt_wtsd_won / cnt_hands) * 100
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Help with these PT3 custom stats, please !

Postby Costel » Fri May 02, 2014 5:24 am

kraada wrote:Most of this data already exists and you don't need new columns. You just need to recombine columns that already exist in your new stat.

The one new column you would need is:
cnt_wwosd: sum(if[holdem_hand_player_statistics.flg_won_hand and not(holdem_hand_player_statistics.flg_showdown), 1, 0])

The stats would be defined as follows:

NWP: (cnt_wwosd / cnt_hands) * 100
SWP: (cnt_wtsd_won / cnt_hands) * 100

Help, please, I'm trying to create these stats into PT4 but it shows to me invalid sql expression when creating the column. Please help !

Thank you a lot !
Costel
 
Posts: 139
Joined: Wed Apr 18, 2012 10:05 am

Re: Help with these PT3 custom stats, please !

Postby Costel » Fri May 02, 2014 5:29 am

I need these for PT4, please help.

Forgot to say that I don't have those for PT3 anymore and neither PT3.
Costel
 
Posts: 139
Joined: Wed Apr 18, 2012 10:05 am

Re: Help with these PT3 custom stats, please !

Postby kraada » Fri May 02, 2014 7:11 am

Replace "holdem" with "cash" above in the column definition and they will then work for PT4.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 9 guests

cron