Effectve BB condition

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

Effectve BB condition

Postby Th0rgal » Tue Jul 13, 2010 10:03 pm

Hi There,

Is there a way of finding of what the fold to steal stat is when the effective number of big blinds is between 5 and 6 for example?

I would like that stat to show up in the HUD

Thank you
Th0rgal
 
Posts: 90
Joined: Sat Apr 19, 2008 7:45 am

Re: Effectve BB condition

Postby kraada » Wed Jul 14, 2010 8:49 am

Unfortunately that's not really going to be possible unless you are happy to count players who have previously folded as part of the effective stack. At the moment amt_p_effective_stack is for the entire hand - so a player with 3BB in MP, if he's the lowest stack, will set that value - even if he open folds.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Effectve BB condition

Postby Th0rgal » Sun Jul 18, 2010 8:33 am

Hi Kaarda,

I am happy with with the entire hand condition as I am looking at push fold options only, rarely someone open and folds in hyper turbo's

I would like to know how often someone calls a steal from the SB based on effective stacks smaler then 5BB'S

I am using this stat as a base to star
BB v SB Steal - Call
( cnt_p_BB_v_SB_steal_call / (cnt_p_BB_v_SB_steal_fold+cnt_p_BB_v_SB_steal_call+cnt_p_BB_v_SB_steal_raise) ) * 100

however when I try to incorporate the condition I get not valid SQL statment errors

cnt_p_BB_v_SB_steal_call
sum(if[tourney_holdem_hand_player_statistics.position = 8 AND tourney_holdem_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action='C' AND
tourney_holdem_hand_player_statistics.amt_p_effective_stack < 3
AND
tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 9, 1, 0])

but I cant get this validated. Any obvious issues with this?
Th0rgal
 
Posts: 90
Joined: Sat Apr 19, 2008 7:45 am

Re: Effectve BB condition

Postby WhiteRider » Sun Jul 18, 2010 10:21 am

You're using the wrong table for the effective stack field.
It is not tourney_holdem_hand_player_statistics.amt_p_effective_stack, it is:

tourney_holdem_hand_summary.amt_p_effective_stack

The effective stack is not specific to a player, so it is in the hand summary table.
This validates:

sum(if[tourney_holdem_hand_player_statistics.position = 8 AND tourney_holdem_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action='C' AND tourney_holdem_hand_summary.amt_p_effective_stack < 3 AND tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos = 9, 1, 0])
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Effectve BB condition

Postby Th0rgal » Sun Jul 18, 2010 1:40 pm

Thanks for clarifying.
Th0rgal
 
Posts: 90
Joined: Sat Apr 19, 2008 7:45 am

Re: Effectve BB condition

Postby preparac » Mon Jul 19, 2010 7:42 am

Unfortunately that's not really going to be possible unless you are happy to count players who have previously folded as part of the effective stack.

...
I am happy with with the entire hand condition as I am looking at push fold options only, rarely someone open and folds in hyper turbo's



Sorry, but this makes no sense. If Btn folds his 1BB stack and SB shoves his 100 BB stack into your BB 200 BB stack where you call with AA, PT3 will interpretate this as a call at 1 BB effektive ...
preparac
 
Posts: 323
Joined: Thu May 15, 2008 6:23 am


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

Who is online

Users browsing this forum: No registered users and 0 guests