Request help for custom stat to save hud space

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

Request help for custom stat to save hud space

Postby kelso101 » Sat Mar 26, 2011 3:33 pm

I know we have the ability to display in hud vpip stats based on position.
I would like to use less space on my HUD for my VPIP stats.
Instead of displaying the vpip for each position I like to do is to display ONLY the VPIP based on the players current position in the hand

In other words

If current position is the button (position 0) then I want to display the vpip for the button only
If the current position is co (position 1) then I want to only display the vpip for the co only.
Same for the remaining positions.

IF THIS IS POSSIBLE I KNOW THAT I MUST NEST EXPRESSIONS FOR EACH POSITION BUT I AM HAVING A PROBLEM WITH THE FORMAT.
I am trying to add this as a variable



If(holdem_hand_player_statistics.position = 0), ((VPIP_button_numerator / VPIP_button_denominator) * 100), if(holdem_hand_player_statistics.position = 1), ((VPIP_CO_numerator / VPIP_from_CO_demoninator) * 100),if(holdem_hand_player_statistics.position = 2),((VPIP_Hijack_Numerator / VPIP_Hijack_Denominator) * 100), If(holdem_hand_player_statistics.position = 3), ((VPIP_Button_Plus3_Numerator_scm / VPIP_Button_Plus3_Denominator_scm) * 100), If(holdem_hand_player_statistics.position = 4), ((VPIP_Button_Plus4_Numerator_scm / VPIP_Button_Plus4_Denominator_scm) * 100),If(holdem_hand_player_statistics.position = 5), ((VPIP_Button_Plus5_Numerator_scm / VPIP_Button_Plus5_Denominator_scm) * 100), If(holdem_hand_player_statistics.position = 6), ((VPIP_Button_Plus6_Numerator_scm / VPIP_Button_Plus6_Denominator_scm) * 100), 1

If possible I believe the format can be used for other position based stats too.

please ..what have i done wrong??
kelso101
 
Posts: 10
Joined: Tue Apr 15, 2008 8:31 am

Re: Request help for custom stat to save hud space

Postby WhiteRider » Sat Mar 26, 2011 4:27 pm

We don't know the current position of the player because we do not have any information about the current hand - all information is read from the hand history file and is imported after the hand completes.
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 1 guest