Facing multiple actions?

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

Facing multiple actions?

Postby Lakestone » Mon Mar 19, 2012 12:17 pm

Is it possible to filter out hands where following scenario took place: UTG jams 8 big blinds in a 9 handed SNG, HJ isos 15 big blinds and BTN overcalls his 10 big blinds. We're in the small blind with the effective stack of 15 big blinds.

I also wonder if it will be possible to use the effective blinds in PT4 using live_vars? I've tried it out a lot in PT3 but its very bugged :( .
Lakestone
 
Posts: 86
Joined: Tue Jan 31, 2012 2:29 pm

Re: Facing multiple actions?

Postby kraada » Mon Mar 19, 2012 12:38 pm

How large is the table size for this scenario?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Facing multiple actions?

Postby Lakestone » Mon Mar 19, 2012 12:41 pm

Table size, do you mean full ring 9 handed?
Or do you mean how many hands I've got to filter for? I got about a million hands in the 9 handed database.
Lakestone
 
Posts: 86
Joined: Tue Jan 31, 2012 2:29 pm

Re: Facing multiple actions?

Postby kraada » Mon Mar 19, 2012 1:47 pm

Yes, I meant full ring - I also just realized this thread is for PT3 not PT4.

In PT3 this kind of filtering is mostly not possible with the level of specificity you want.

In PT4 you can do a lot better - you can filter in the Hand Details -> Player Position section to filter for times UTG opens and there's a 3bet from the HJ. We don't have a filter for calling position, but you can filter in the Actions and Opportunities -> Preflop -> Actions Encountered With Sizes section for 3Bet Preflop of 15BB (just choose between 15 and 15 for it to be exactly 15). Then you can use the same section to specify that the 3bet you faced was 15 / 33 - or a little under 50% of the pot. This won't guarantee where the call came from but it will make it very likely that there is a call or other multiple players involved because that's the only way to get that raise to be such a small percentage of the pot.

The Live stats in PT4 should be working - please let us know if you experience any troubles with them.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Facing multiple actions?

Postby Lakestone » Mon Mar 19, 2012 1:58 pm

kraada wrote:The Live stats in PT4 should be working - please let us know if you experience any troubles with them.


Well, I don't have PT4, when will it be released for the public?
Perhaps you could supply me the beta in a PM, since I work with PT 5-8h a day, I could be of very good benefit for the community, contributing with a lot of input all the time.

Thanks
Lakestone
 
Posts: 86
Joined: Tue Jan 31, 2012 2:29 pm

Re: Facing multiple actions?

Postby kraada » Mon Mar 19, 2012 4:00 pm

The PT4 public beta went live last Friday. You can download it now here.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Facing multiple actions?

Postby Lakestone » Tue Mar 20, 2012 2:43 am

Nice! So how do I create a stat to display the effective stack size for hero on a full ring table?
Lakestone
 
Posts: 86
Joined: Tue Jan 31, 2012 2:29 pm

Re: Facing multiple actions?

Postby kraada » Tue Mar 20, 2012 5:37 pm

Stack size in big blinds is a default stat that is on the table in our new PT4 HUD layouts.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Facing multiple actions?

Postby Lakestone » Wed Mar 21, 2012 6:28 am

kraada wrote:Stack size in big blinds is a default stat that is on the table in our new PT4 HUD layouts.


I see, but I was asking about effective stack size :). For HU we get the minimum of the two, is it possible to do something like that in a 6-9 player environment?
Lakestone
 
Posts: 86
Joined: Tue Jan 31, 2012 2:29 pm

Re: Facing multiple actions?

Postby WhiteRider » Thu Mar 22, 2012 4:41 am

I don't think effective stack size is available as a live stat.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 0 guests