VP$IP per position on the pop-up

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

VP$IP per position on the pop-up

Postby danndann » Sun Aug 17, 2008 4:31 am

How can I add this stats to my pop-up hud?
I consider them very important to know the player ranges, skills and tendecies...
Tx v much!
danndann
 
Posts: 4
Joined: Thu Jul 24, 2008 8:11 am

Re: VP$IP per position on the pop-up

Postby WhiteRider » Sun Aug 17, 2008 4:48 am

You will need to create these as Custom Statistics (or get them from the Repository, someone has already built some) and then you can add them to your pop up group just like any other stats.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: VP$IP per position on the pop-up

Postby danndann » Sun Aug 17, 2008 5:17 am

ok, so i found only vpip from co who looks like this:

(VPIP_CO_numerator / VPIP_from_CO_demoninator) * 100

where:
VPIP_CO_numerator is:
sum(if[holdem_hand_player_statistics.flg_vpip AND holdem_hand_player_statistics.position = 1,1,0])

and

VPIP_from_CO_demoninator is:
SUM(if[holdem_hand_player_statistics.position = 1,1,0])

so what I should change to fit all other 5 positions?
tx again!
danndann
 
Posts: 4
Joined: Thu Jul 24, 2008 8:11 am

Re: VP$IP per position on the pop-up

Postby WhiteRider » Sun Aug 17, 2008 5:34 am

holdem_hand_player_statistics.position = 1
says that the player is 1 seat from the button.
The button is position zero, cutoff=1, etc, but BB=8 and SB=9 regardless of table size.
So at a 6max table, "holdem_hand_player_statistics.position = 3" is UTG.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: VP$IP per position on the pop-up

Postby danndann » Sun Aug 17, 2008 7:09 am

great, tx a lot!
danndann
 
Posts: 4
Joined: Thu Jul 24, 2008 8:11 am

Re: VP$IP per position on the pop-up

Postby sooraw » Sat Aug 23, 2008 6:32 pm

I could use some help with this also,
If i wanna get someones vpip from the button should it be like this then

Name:
cnt_vpip_btn

Expression:

( sum(if[holdem_hand_player_statistics.flg_vpip AND holdem_hand_player_statistics.position = 0,1,0]) / SUM(if[holdem_hand_player_statistics.position = 0,1,0]) ) * 100

Is that right?
sooraw
 
Posts: 4
Joined: Mon May 19, 2008 5:42 pm

Re: VP$IP per position on the pop-up

Postby WhiteRider » Tue Aug 26, 2008 4:43 am

Yes, you're heading in the right direction, but you need two Columns:
cnt_vpip_btn = sum(if[holdem_hand_player_statistics.flg_vpip AND holdem_hand_player_statistics.position = 0,1,0])
cnt_btn = SUM(if[holdem_hand_player_statistics.position = 0,1,0])

Then your Statistic is:
100 * cnt_vpip_btn / cnt_btn
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 3 guests