Win% while all in

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

Win% while all in

Postby delucks » Mon Aug 25, 2008 2:51 pm

is there a way to run a report that shows win% while all in pre or at any other point for that matter?
delucks
 
Posts: 2
Joined: Thu Jul 24, 2008 9:30 am

Re: Win% while all in

Postby kraada » Mon Aug 25, 2008 4:33 pm

You should be able to create this as a custom statistic using the holdem_hand_summary.amt_f_effective_stack and amt_t_effective_stack and amt_r_effective_stack as well as holdem_hand_player_detail.amt_bet_r.

Just create a custom stat that is true when amt_f_effective_stack = 0 or amt_t_effective_stack = 0 or amt_r_effective_stack = 0 -- if the effective stacks are 0, you are all in. Then just check to see if the amount bet on the river (amt_bet_r) = the effective river stacks (amt_r_effective_stack) -- which means that you went all in on the river. This stat will then be true if there was an all-in.

Then increment for hands you won that were all in as another stat (all-in wins) and divide that by the total number of all-ins and multiply by 100.

I'll try and create this stat later today, but I'm currently doing some alpha testing and unable to work on it right now.

When I've put it together I'll submit it to the repository and post it in this thread as well.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Win% while all in

Postby delucks » Tue Aug 26, 2008 4:41 pm

that would be awesome.
delucks
 
Posts: 2
Joined: Thu Jul 24, 2008 9:30 am


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

Who is online

Users browsing this forum: No registered users and 1 guest