new* cnt_bb_steal_call

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

new* cnt_bb_steal_call

Postby js2002 » Sun Oct 26, 2008 8:28 am

hi,

new column:

sum(if[ holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.cnt_p_call > 0, 1 , 0 ])


The Stat is:

100 * cnt_bb_steal_call / cnt_steal_def_opp_bb

Is this ok? It should express: How often did he call to a steal...
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: new* cnt_bb_steal_call

Postby WhiteRider » Sun Oct 26, 2008 8:50 am

That stat is close, but it will also include cases where the BB raises and then calls a reraise.
You would be better to check for cnt_p_raise=0 AND NOT flg_p_fold; or you could use the lookup_actions_p.action as described in this post:
viewtopic.php?f=45&t=8028#p63120

The naming convention for blind steal stats isn't that well defined, so I'll leave you to choose your own name for it.
Hopefully we'll add some more steal stats as built-in stats soon, so we'll try to sort the names out then.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: new* cnt_bb_steal_call

Postby js2002 » Sun Oct 26, 2008 9:06 am

understand the first part of ur explaination but dont get the lookup thing.
Why use this? what is it?
Yeah I understand that u can search a specific action on a street but I can check this with "your first part explainations".


now its:

sum(if[ holdem_hand_player_statistics.flg_blind_b AND holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.cnt_p_call > 0 AND
cnt_p_raise = 0 AND NOT flg_p_fold, 1 , 0 ])
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: new* cnt_bb_steal_call

Postby WhiteRider » Sun Oct 26, 2008 9:08 am

You don't need to worry about the 'action' thing for this case, but it's something you might be interested in for the future since you are building a lot of stats.

Have a read of the thread I linked.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: new* cnt_bb_steal_call

Postby js2002 » Sun Oct 26, 2008 9:16 am

read it an again, after 2nd read i got it ;) sry
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany


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

Who is online

Users browsing this forum: No registered users and 4 guests