BB fold to SB not work + want to build 1

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

BB fold to SB not work + want to build 1

Postby battered » Wed Aug 05, 2009 4:28 pm

I really don't get this build stuff much, but I NEED a couple of stats!!

1:
existing touney stat BB fold to SB steal att (not sure if this is original or from rep)
anyway it doesn't work.

(from config . tourny stats . statistics)
fold BB to SB steal: (cnt_p_BB_fold_to_SB/cnt_p_BB_fold_to_SB_opp)*100

any reason why not working?? (I play 6max sng's)

2:
there is currently a push AI pf by M colour zone stat, but I want a push AI pf from button and another for SB.

current stat for M colour zone blue = (cnt_p_push_bz/cnt_hand_bz)*100

will this work for small blind if I change bz for SB

thanks for any help
battered
 
Posts: 67
Joined: Wed Sep 03, 2008 6:54 am

Re: BB fold to SB not work + want to build 1

Postby kraada » Wed Aug 05, 2009 4:31 pm

(1) It should be working, what is wrong with it?

(2) No, you'd need to create new columns for the SB, see the How To: Advanced HUD Configuration for more details on how to accomplish this sort of thing.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: BB fold to SB not work + want to build 1

Postby battered » Wed Aug 05, 2009 5:25 pm

1 - bb fold to sb steal att, i have on a pop up. it shows as a ' - ' , 0/0 total 0/0 this session
I have hundreds of hands on some players, this stat does not work for me.
battered
 
Posts: 67
Joined: Wed Sep 03, 2008 6:54 am

Re: BB fold to SB not work + want to build 1

Postby kraada » Thu Aug 06, 2009 8:49 am

Are you certain you've seen someone in the big blind fold to a small blind steal within those hands?

Your stats are always session-only, so you need to make sure an opponent has been in this spot.

If you have 207 hands on someone at full ring, that's 23 orbits. So 23 times for them to be in the big blind. Assume tight opponents for the moment: say they raise 5% in early position, 10% in middle position and 20% in late position.

There are 2 EP spots, so 2/23 times, there are raises to this guy in EP (so the SB has no chance to steal). There are 21 chances left. There are 2 MP spots, so 4/23 times there are raises to this guy in MP. There are 3 LP spots, so 15/23 times there are raises to this guy in LP. That's 21/23 times. So twice, on average it'll be folded to the SB.

Obviously this is a rough calculation, and table conditions vary, but the point is: even in 200 hands it's not lock to have much of a sample on this particular stat. If you've actually seen someone in a spot that should've registered, of course, that would be something else.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: BB fold to SB not work + want to build 1

Postby battered » Thu Aug 06, 2009 3:36 pm

the stat I have is for tourney not cash, and I play a lot of 6max sng's. so sb v bb hands happen frequently.
i also use the same stats for me as rest of table and have checked against my self. it doesnt work.
battered
 
Posts: 67
Joined: Wed Sep 03, 2008 6:54 am

Re: BB fold to SB not work + want to build 1

Postby kraada » Thu Aug 06, 2009 5:24 pm

That should have been fixed for Build 5.1. Could you please attach a hand that is not displaying properly that should be counted for this stat to a support ticket so that we can investigate further?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: BB fold to SB not work + want to build 1

Postby battered » Thu Aug 06, 2009 6:18 pm

yea, I will try to work it out tomorrow.

cheers
battered
 
Posts: 67
Joined: Wed Sep 03, 2008 6:54 am

Re: BB fold to SB not work + want to build 1

Postby nh4no3 » Fri Aug 07, 2009 4:37 am

It still doesn't work in build 5.1, I'm playing super turbo sngs and this situation comes a lot.
nh4no3
 
Posts: 2
Joined: Thu Nov 06, 2008 5:03 am

Re: BB fold to SB not work + want to build 1

Postby kraada » Fri Aug 07, 2009 8:53 am

Could you please create a ticket as well including some hands so that we can look into why those hands aren't being counted properly? It would be a big help.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: BB fold to SB not work + want to build 1

Postby nh4no3 » Mon Aug 10, 2009 5:22 am

I created a ticket and attached 5 sample hands.
nh4no3
 
Posts: 2
Joined: Thu Nov 06, 2008 5:03 am

Next

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

Who is online

Users browsing this forum: No registered users and 0 guests