Tourney -Stats filtered by a players stack size

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

Tourney -Stats filtered by a players stack size

Postby TheZebra » Thu Sep 02, 2010 3:17 pm

Just moving back to PT again, lots to catch up with since i last used it =)

Have seached some on this and as i understand it is not possible to make any custom made HUD stats for tournaments that is filtered by Stacksize. What im looking for is being able to
see players att. to steal from diff pos filtered by diff stack sizes, like for instance when a player has <=12bbs in the CO. This isnt possible right, just wanted to double check. If its not, is there any hope it may be in the future or is such a filter way to complicated?
TheZebra
 
Posts: 10
Joined: Sat Aug 28, 2010 11:33 am

Re: Tourney -Stats filtered by a players stack size

Postby kraada » Thu Sep 02, 2010 4:32 pm

You could build statistics like these with a bit of time and effort. At the moment my cache is updating but once it's finished I'll attach a popup group for you here which should be instructive for you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Tourney -Stats filtered by a players stack size

Postby TheZebra » Thu Sep 02, 2010 4:39 pm

kraada wrote:You could build statistics like these with a bit of time and effort. At the moment my cache is updating but once it's finished I'll attach a popup group for you here which should be instructive for you.


Great, thanks alot.
TheZebra
 
Posts: 10
Joined: Sat Aug 28, 2010 11:33 am

Re: Tourney -Stats filtered by a players stack size

Postby TheZebra » Thu Sep 02, 2010 5:07 pm

Would this be correct?, kinda familar with SQL (althoug far from a star :D) so wanted to try now i knew it was possibleto see if i could make it out.

So the stat i attemted to create is: How often the player attempted to steal the blinds from the cutoff when his stack is below 12BB

In tourney_holdem_hand_player_statistics i created the column: stack_bb with the expression tourney_holdem_hand_player_detail.amt_before/tourney_holdem_blinds.amt_bb

Than in statistics i created a new statistic Att To Steal:CO:BB<12 with the value expression ((cnt_steal_att_cutoff / cnt_steal_opp_cutoff) * 100) AND stack_bb <12
TheZebra
 
Posts: 10
Joined: Sat Aug 28, 2010 11:33 am

Re: Tourney -Stats filtered by a players stack size

Postby kraada » Thu Sep 02, 2010 5:33 pm

No, what you'd want to do is create two new columns, one for times and one for opportunities and include something that filters for times his big blind is a given size, in this case something like "AND(tourney_holdem_hand_player_detail.amt_before / tourney_holdem_blinds.amt_bb) <= 12".

See this tutorial for more details (though it lacks screenshots at this point which will be added hopefully tomorrow.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Tourney -Stats filtered by a players stack size

Postby TheZebra » Thu Sep 02, 2010 6:55 pm

kraada wrote:No, what you'd want to do is create two new columns, one for times and one for opportunities and include something that filters for times his big blind is a given size, in this case something like "AND(tourney_holdem_hand_player_detail.amt_before / tourney_holdem_blinds.amt_bb) <= 12".

See this tutorial for more details (though it lacks screenshots at this point which will be added hopefully tomorrow.


ty i looked it through, created 2 new columns,

1)steal opp

sum(if[tourney_holdem_hand_player_statistics.flg_steal_opp AND (tourney_holdem_hand_player_statistics.position) =1 AND (tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb )) <12, 1, 0])

and 2) steal attempts

sum(if[tourney_holdem_hand_player_statistics.flg_steal_att AND (tourney_holdem_hand_player_statistics.position)=1 AND (tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb )) <12 , 1, 0])


Maybe im doing it wrong again :), not getting it to be a valid value expression in statistics (obv guess i might be screwing it again but thought i ask since it how i interpret what it was that i should do in the creating the columns and maybe now just screwing up a bit in creating the statistic from the columns)

Thanks very much for the help so far
TheZebra
 
Posts: 10
Joined: Sat Aug 28, 2010 11:33 am

Re: Tourney -Stats filtered by a players stack size

Postby TheZebra » Thu Sep 02, 2010 7:45 pm

got in the statistic, usually screw the () it seem like, anyways the statistic looks ike this with the above columns

((ZStealATTCO)/(ZStealOPPCO))

Awaiting verdict :mrgreen:
TheZebra
 
Posts: 10
Joined: Sat Aug 28, 2010 11:33 am

Re: Tourney -Stats filtered by a players stack size

Postby kraada » Fri Sep 03, 2010 8:39 am

You probably want to multiply by 100 so that it's a percentage - but otherwise yes that looks like it should work just fine.
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