Adding number of big blinds to the HUD

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

Adding number of big blinds to the HUD

Postby Mike_ » Tue Oct 06, 2009 4:59 pm

Kraade posted the formula for creating M here viewtopic.php?f=45&t=11188#p103842

I have imported the M formula - but I'm much comfortable measuring stacks in BBs.

I should add , I understand the limitations of BB compared to M

I've spoken to Kraada via pm about how to tweak this formula to create a field for the number of big blinds but without a successful result.

Here's what I've done

Kraada's formula for the size of blinds :

sum(if[ localtimestamp - interval '30 seconds' < tourney_holdem_hand_summary.date_imported, tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb, 0])


My formula for the size of the big blind which Ive called val_stack

(if[ localtimestamp - interval '30 seconds' < tourney_holdem_hand_summary.date_imported, tourney_holdem_blinds.amt_bb , 0])


Kraada's formula for the val_stack size :

sum(if[ localtimestamp - interval '30 seconds' < tourney_holdem_hand_summary.date_imported, tourney_holdem_hand_player_detail.amt_before + tourney_holdem_hand_player_statistics.amt_won, 0])


I can use this formula for my calculation.




And I created a new statistic called Big Blinds and calculate it by

(val_stack / (val_blinds ))


Everything seems to work fine until I try to add it to my HUD

Is there someone out there who can help me please?
Last edited by Mike_ on Tue Oct 06, 2009 5:17 pm, edited 1 time in total.
Mike_
 
Posts: 193
Joined: Tue Nov 04, 2008 1:58 pm

Re: Adding number of big blinds to the HUD

Postby kraada » Tue Oct 06, 2009 5:13 pm

I haven't been able to figure out why yours won't work in the HUD but mine will - did you create a support ticket for this issue?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Adding number of big blinds to the HUD

Postby Mike_ » Tue Oct 06, 2009 5:15 pm

No, I've not done a ticket. Does your formulae match my amateur workings *exactly* ?
Mike_
 
Posts: 193
Joined: Tue Nov 04, 2008 1:58 pm

Re: Adding number of big blinds to the HUD

Postby Mike_ » Tue Oct 06, 2009 5:23 pm

I've tried it once more :

In Statistics :

Number of Big Blinds = (val_stack_size / (BB))

In Columns :

val_stack_size = sum(if[ localtimestamp - interval '30 seconds' < tourney_holdem_hand_summary.date_imported, tourney_holdem_hand_player_detail.amt_before + tourney_holdem_hand_player_statistics.amt_won, 0]) (as per the M calculation)

BB = (if[ localtimestamp - interval '30 seconds' < tourney_holdem_hand_summary.date_imported, tourney_holdem_blinds.amt_bb , 0])


I'll run housekeeping and let you know.
Mike_
 
Posts: 193
Joined: Tue Nov 04, 2008 1:58 pm

Re: Adding number of big blinds to the HUD

Postby kraada » Tue Oct 06, 2009 5:40 pm

I've tried it and not managed to have the same problem that you do. Could you please export your statistic, zip it up and attach it to a support ticket and then reference this thread? We'll be able to investigate further then.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Adding number of big blinds to the HUD

Postby jackh69 » Wed Oct 07, 2009 1:54 pm

I use formula for creating M : (val_stack_size / (val_blinds)) :arrow: (val_stack_size / (val_blinds / 1.5))
jackh69
 
Posts: 14
Joined: Tue Sep 29, 2009 8:21 pm

Re: Adding number of big blinds to the HUD

Postby kraada » Wed Oct 07, 2009 2:11 pm

Heh, that would work also!
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Adding number of big blinds to the HUD

Postby Mike_ » Thu Oct 08, 2009 1:29 pm

Ok I've set myself up like jackh's above.

Sorry to be a pain but the HU is incorrect for players I've seen before.

Eg

I'm importing now blinds 15/30 . Player has a stack of 2160 My Hud is showing 107 BB . When I put my mouse over it it shows Value 106.75 This Session 72 (which is correct)

I have 59 hands on him so I musr have seen him before , the other players BB's are correct

The blinds havent gone up for a while btw
Mike_
 
Posts: 193
Joined: Tue Nov 04, 2008 1:58 pm

Re: Adding number of big blinds to the HUD

Postby WhiteRider » Thu Oct 08, 2009 1:36 pm

Mike_ wrote:Ok I've set myself up like jackh's above.

Sorry to be a pain but the HU is incorrect for players I've seen before.

Eg

I'm importing now blinds 15/30 . Player has a stack of 2160 My Hud is showing 107 BB . When I put my mouse over it it shows Value 106.75 This Session 72 (which is correct)

I have 59 hands on him so I musr have seen him before , the other players BB's are correct

The blinds havent gone up for a while btw

Exactly what is the problem - you say that both values are correct?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Adding number of big blinds to the HUD

Postby Mike_ » Thu Oct 08, 2009 1:43 pm

Mike_ wrote:blinds 15/30 . Player has a stack of 2160 My Hud is showing 107 BB .


2160/30 = 72
Mike_
 
Posts: 193
Joined: Tue Nov 04, 2008 1:58 pm

Next

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

Who is online

Users browsing this forum: No registered users and 0 guests