VPIPBB Help Please

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

VPIPBB Help Please

Postby i3bet4fun » Sat Aug 28, 2010 4:44 am

Hello i did post this on the PT3 2+2 thread earlier today, Im trying to create a VPIP for just the BB for HUSNG's and Kraada tried to help me out with the advice below,

'In this case, you'll want to duplicate and change the cnt_vpip_sb column in the Player Statistics section and change it to cnt_vpip_bb and change the definition to refer to BB hands, not SB hands. Do the same for cnt_hands_sb (into cnt_hands_bb) then create your stat.'

The thing is i have gone into the section he said and found the cnt_vpip_sb duplicated it and changed it to cnt_vpip_bb, Kraada then says 'change the definition to refer to BB hands, not SB hands.' does this just mean change the name and description because there is no definition tab in the columns part but only in the statistics does it have a definition tab.
Does he mean i need to change any part of this expression:

sum( if[tourney_holdem_hand_player_statistics.flg_blind_b = false AND tourney_holdem_hand_player_statistics.flg_blind_s AND tourney_holdem_hand_player_statistics.flg_vpip, 1, 0] )

or not? :?

I also went to do the same for cnt_hands_sb but there was only a cnt_sb stat in the columns list, im presuming this is just the same?

So once i duplicated these two stats Kraada pointed out i then went to the statistics tab and created a new stat and in the expressions box i entered

(cnt_vpip_bb / cnt_bb) * 100

for my VPIPBB stat.

It was a valid expression but will this give me what i am looking for?, i wanted a stat that just shows me the VPIP for just the big blind in a HUSNG match.

Im asking if i have done this correct because after i had created this stat and updated the cache, when it was showing in the HUD the VPIPBB & VPIPSB seemed to be the same, ie when he folded from the big blind both the stats % reduced the same amount where as i would expect just the VPIPBB to reduce and the VPIPSB to stay as what it was.

sorry for hassle as i understand this is probaly a fairly simple stat to create, its just im not really too good at this sort of stuff and i would really apprieciate more help on this one if possible.

Thanks :!:
i3bet4fun
 
Posts: 6
Joined: Tue Oct 27, 2009 7:12 am

Re: VPIPBB Help Please

Postby WhiteRider » Sat Aug 28, 2010 7:25 am

i3bet4fun wrote:The thing is i have gone into the section he said and found the cnt_vpip_sb duplicated it and changed it to cnt_vpip_bb, Kraada then says 'change the definition to refer to BB hands, not SB hands.' does this just mean change the name and description because there is no definition tab in the columns part but only in the statistics does it have a definition tab.
Does he mean i need to change any part of this expression:

sum( if[tourney_holdem_hand_player_statistics.flg_blind_b = false AND tourney_holdem_hand_player_statistics.flg_blind_s AND tourney_holdem_hand_player_statistics.flg_vpip, 1, 0] )


Yes - you need to change this expression. This currently checks whether the player is in the small or big blind, so you need to change it to just check for one blind or the other.
e.g. for the big blind, use this:

sum( if[tourney_holdem_hand_player_statistics.flg_blind_b = false AND tourney_holdem_hand_player_statistics.flg_vpip, 1, 0] )

..with the small blind check removed.
For the small blind column switch flg_blind_b for flg_blind_s.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: VPIPBB Help Please

Postby Blacktor » Sat Aug 28, 2010 7:28 am

For HUSNGs it's not really necessary to know VPIP for just the BB. What can you do with that info? If you're trying to get some useful stats for the hud, start with 3bet percentage and how often BB folds to your button raise (Fold BB to Steal).
Blacktor
 
Posts: 13
Joined: Tue May 13, 2008 11:19 am


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

Who is online

Users browsing this forum: No registered users and 0 guests