Format /%.2f

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

Format /%.2f

Postby BoFo » Thu Oct 16, 2008 3:26 pm

Hi!

I made my own stats (with your help!) and they seem to work. Almost.

Only trouble is: when I point to PT's own stat in the hud, it shows e. g.: (Vpip) Value: 19,44 (7/36). When I point to my homemade stats they come out: Value: 19,44 and no more. Format expression for both is the same: /%.2f.

Do you know what makes the difference?

Yours, Bo
BoFo
 
Posts: 31
Joined: Thu Aug 14, 2008 10:46 am

Re: Format /%.2f

Postby WhiteRider » Thu Oct 16, 2008 4:12 pm

I think this is to do with the way you construct the 'value expression' - the
(x/y) * 100
bit.

I did a bit of checking up about this a little while ago when someone else had the same issue, and Josh has fixed it by making it less sensitive to the exact structure of that statement.

What do you have in the Value Expression field?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Format /%.2f

Postby BoFo » Fri Oct 17, 2008 4:38 am

100 - (((cnt_f_check_call / cnt_f_check) * 100) + ((cnt_f_check_raise / cnt_f_check_raise_opp)* 100))
BoFo
 
Posts: 31
Joined: Thu Aug 14, 2008 10:46 am

Re: Format /%.2f

Postby WhiteRider » Fri Oct 17, 2008 4:43 am

I suspect it's because that isn't in the format it's expecting.
Try rearranging it so that you do
( (1 - (x/y)) * 100
and see if that helps.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Format /%.2f

Postby BoFo » Sun Oct 19, 2008 8:43 am

You are right again!
It took a lot af rearranging but now OK.

Just one more thing about it:
It now comes like:
Value on HUD: 56

"Hidden values":
Value: 56.25 (9/16)
This session: 66.67 (2/3)

I would prefer it reversed, showing value on HUD as this session, in this case: 67

Is that possible?
BoFo
 
Posts: 31
Joined: Thu Aug 14, 2008 10:46 am

Re: Format /%.2f

Postby WhiteRider » Sun Oct 19, 2008 11:20 am

No, that isn't yet an option.
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