Page 1 of 1

Help with these PT3 custom stats, please !

PostPosted: Sun May 26, 2013 12:18 pm
by Costel
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.

Re: Help with these PT3 custom stats, please !

PostPosted: Mon May 27, 2013 6:40 am
by kraada
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

Re: Help with these PT3 custom stats, please !

PostPosted: Fri May 02, 2014 5:24 am
by Costel
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 !

Re: Help with these PT3 custom stats, please !

PostPosted: Fri May 02, 2014 5:29 am
by Costel
I need these for PT4, please help.

Forgot to say that I don't have those for PT3 anymore and neither PT3.

Re: Help with these PT3 custom stats, please !

PostPosted: Fri May 02, 2014 7:11 am
by kraada
Replace "holdem" with "cash" above in the column definition and they will then work for PT4.

highfalutin