Effective Blinds Stat

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

Effective Blinds Stat

Postby jrkimbel » Tue Apr 20, 2010 9:26 pm

Is there a stat showing your current effective blinds? For example 9 players 400/800 +100 ante so effectively the blinds are 700/1400
If my stack is 14,000 then I have 10 BB effectively.
Sorry if the answer is already out there!
Thanks!
jrkimbel
 
Posts: 9
Joined: Sun Mar 01, 2009 1:56 pm

Re: Effective Blinds Stat

Postby WhiteRider » Wed Apr 21, 2010 2:52 am

Where do you want to see this?
We had a workaround for the HUD but that no longer works due to the improved incremental cache updates.
The request for stats like this for the HUD is in our system, but I don't know when they will be added.

You can build a custom stat to display this in the PT3 reports for individual hands.
The stat would be in the Holdem Tournament Hands section.
The column you need is:
amt_m =
tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb + (tourney_holdem_hand_summary.cnt_players * tourney_holdem_hand_player_detail.amt_ante) )
Then a stat to display that value.

Tutorial - Custom Reports and Statistics
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Effective Blinds Stat

Postby jrkimbel » Wed Apr 21, 2010 6:49 pm

WhiteRider wrote:Where do you want to see this?


I would ideally like to see it on my hud like I see any other stat, updated every hand...I'm not very quick at figuring i out on the fly, so to speak.
jrkimbel
 
Posts: 9
Joined: Sun Mar 01, 2009 1:56 pm

Re: Effective Blinds Stat

Postby WhiteRider » Thu Apr 22, 2010 3:01 am

This isn't currently possible in the HUD, but the request is in our system.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Effective Blinds Stat

Postby js2002 » Sat Sep 22, 2012 5:19 am

possible now?
which columns/expression can we use?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Effective Blinds Stat

Postby kraada » Sat Sep 22, 2012 9:19 am

No, this is not possible - and likely never will be - in PT3.

In PT4 we have new effective stack size filters in the main application but since your effective stack size in this hand depends on players' actions before your turn to act and we don't know that until the hand is over, we can't how you this data their either.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Effective Blinds Stat

Postby js2002 » Sat Sep 22, 2012 11:53 am

Huh?
A HU player just now reports that he has gotten such stats. How do the others do it? fake?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Effective Blinds Stat

Postby kraada » Sat Sep 22, 2012 12:35 pm

For PT3 it is still not available. For heads up only it can be done using live_cash_table.amt_min_stack since the effective stack heads up can only be the smaller of the two stacks.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Effective Blinds Stat

Postby js2002 » Sat Sep 22, 2012 12:54 pm

oh, thought this was pt4 (found by google)

then how is it 4 pt4 ;)
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Effective Blinds Stat

Postby kraada » Sat Sep 22, 2012 2:06 pm

In PT4 you can do it as a live stat using live_cash_table.amt_min_stack.
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