won money withouth showdown from Blinds

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

won money withouth showdown from Blinds

Postby shaiheart » Sat Feb 20, 2010 7:39 am

Hi,

Can a stat be made to show how much money a player lost or won from blinds without showdown?
I was thinking about something like putting together all of the WWoSD % When Bet or Raise from pre, flop, turn and river from blind positions..
but i don't know how to do that it will show the amount of money along with the precentage..
shaiheart
 
Posts: 27
Joined: Sun Sep 06, 2009 12:27 pm

Re: won money withouth showdown from Blinds

Postby kraada » Sat Feb 20, 2010 9:36 am

You'd need to create a separate statistic for the money won portion. To create a column which reports the money won when the player didn't get to showdown, use this expression:
sum( if[ holdem_hand_player_statistics.flg_won_hand and NOT(holdem_hand_player_statistics.flg_showdown), holdem_hand_player_statistics.amt_won, 0])

See the Tutorial: Using Custom Statistics and Reports for more on how to create custom statistics.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: won money withouth showdown from Blinds

Postby shaiheart » Sun Feb 21, 2010 3:32 am

that's all it is? is it also limited to the blinds?
shaiheart
 
Posts: 27
Joined: Sun Sep 06, 2009 12:27 pm

Re: won money withouth showdown from Blinds

Postby shaiheart » Sun Feb 21, 2010 4:26 am

just tried it and its not working correctly..
i think its a problem with the first part of the expression, since its not only when the player had won, sometimes he loses and that should be accounted too...
so the expression should show: how much money does a player win or lose from the blinds without showdown..
i'm lost :/
shaiheart
 
Posts: 27
Joined: Sun Sep 06, 2009 12:27 pm

Re: won money withouth showdown from Blinds

Postby kraada » Sun Feb 21, 2010 9:45 am

Then use this expression:
sum( if[ NOT(holdem_hand_player_statistics.flg_showdown), holdem_hand_player_statistics.amt_won, 0])

If you set it in the HUD to Blinds in the Statistics Properties box it will show only data from the blinds. If you want to see it in a report for all positions, you can add it to the Positions tab by clicking the little wrench at the top right.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: won money withouth showdown from Blinds

Postby shaiheart » Sun Feb 21, 2010 12:07 pm

but if the player lost money without showdown, will it the amount decrease, or will it just ignore it?
shaiheart
 
Posts: 27
Joined: Sun Sep 06, 2009 12:27 pm

Re: won money withouth showdown from Blinds

Postby kraada » Sun Feb 21, 2010 12:11 pm

amt_won can be positive or negative so if they lost money that would be accounted for as well.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: won money withouth showdown from Blinds

Postby shaiheart » Wed Feb 24, 2010 12:15 pm

hey, i checked the new expression and its still not working properly..
I have entered a table, won some money while betting the flop and it showed me a much greater amount...
could you try it out and see how it works out for you?

Just a reminder: I wanted to see how much money does a player win or lose (balance) from the blinds, when there was no showdown.

thanks in advance
shaiheart
 
Posts: 27
Joined: Sun Sep 06, 2009 12:27 pm

Re: won money withouth showdown from Blinds

Postby kraada » Wed Feb 24, 2010 1:12 pm

Could you please export, zip up and attach the stat you are using to a support ticket? We'll investigate from there.
kraada
Moderator
 
Posts: 54430
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 0 guests