Custom HUD stats preflop raise size

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

Re: Custom HUD stats preflop raise size

Postby kraada » Fri Feb 03, 2012 3:06 pm

Changing from flg_p_fold to lookup_actions_p.action = 'F' (that is your only preflop action is fold) would do it - technically you could call one raise then fold to a second raise or something so you'd need to check against a few cases otherwise and this is probably simplest.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Custom HUD stats preflop raise size

Postby Lakestone » Sat Feb 04, 2012 11:23 am

Thanks,

Think I solved the next task I was about to ask about :D.

Later!
Lakestone
 
Posts: 86
Joined: Tue Jan 31, 2012 2:29 pm

Re: Custom HUD stats preflop raise size

Postby kraada » Sat Feb 04, 2012 2:05 pm

Sounds good to me! :D
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Custom HUD stats preflop raise size

Postby Lakestone » Sun Feb 05, 2012 11:18 am

I don't know if this is a huge bug in the program or not, perhaps its just a small issuse that is fixable, here goes...

I've created a lot of columns for Holdem Tournament Player Statistics lately, and every new Statistic I create now based on my own columns is displaying "0" in results and summary. I copy the exact same conditions and create a Holdem Tournament Hand filter instead, and voila, it works like intended. The only thing I change to make it a filter is removing the sum() and replacing 1,0 to true/false. I tried running housekeeping with Vacuum, Analyze, Update cache and Rebuild cache plus restarting the program - without any results. I recreated the columns and the statistics with different names - which makes it work about 20% of the times (I never changed any code!).

I don't know how many hours I've spent looking for mistakes in my conditions, and ended up just renaming/restarting multiple times to get it to show flawless numbers. This is extremely frustrating, 'cause you never know if its you or the program that messed up and no validator to help you sort it out. So is there a fix for this or maybe special way of approaching it that reduces the chance of this bug occuring?

I'm using the latest beta now.
Lakestone
 
Posts: 86
Joined: Tue Jan 31, 2012 2:29 pm

Re: Custom HUD stats preflop raise size

Postby kraada » Sun Feb 05, 2012 11:56 am

Can you give me an example of a version that doesn't work for you?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Custom HUD stats preflop raise size

Postby Lakestone » Sun Feb 05, 2012 1:08 pm

kraada wrote:Can you give me an example of a version that doesn't work for you?


How often we fold vs to 3bet after opening 2-2.5x, 9-11bb eff
3Bet
[ img ]

Situation occurs (Opp)
[ img ]

Stat
[ img ]

If I turn those two columns into filters to use in Holdem Tournament Hand, I get 340 & 1600 hands correctly displayed.
Even if I only try to return the first column alone without formatting, I still get 0.0000000.

Extra big hug for you if you can kill this one :lol:
Last edited by Lakestone on Sun Feb 05, 2012 1:18 pm, edited 1 time in total.
Lakestone
 
Posts: 86
Joined: Tue Jan 31, 2012 2:29 pm

Re: Custom HUD stats preflop raise size

Postby kraada » Sun Feb 05, 2012 1:14 pm

Try renaming them so they don't start with _ - we use that structure internally to mean something special and I want to make 100% sure that's not the problem before digging into things further for you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Custom HUD stats preflop raise size

Postby Lakestone » Sun Feb 05, 2012 1:20 pm

kraada wrote:Try renaming them so they don't start with _ - we use that structure internally to mean something special and I want to make 100% sure that's not the problem before digging into things further for you.


Forgot to mention that I did try this already for all columns/statistics.
Lakestone
 
Posts: 86
Joined: Tue Jan 31, 2012 2:29 pm

Re: Custom HUD stats preflop raise size

Postby kraada » Sun Feb 05, 2012 1:43 pm

I just tested that first column of yours and I see data on my side. What do you have on your format tab?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Custom HUD stats preflop raise size

Postby Lakestone » Sun Feb 05, 2012 2:09 pm

kraada wrote:I just tested that first column of yours and I see data on my side. What do you have on your format tab?


In the first example I got /%.2f and I tried no formatting on one of the columns as well as format_number(col, 0, false, false).

[b]EDIT: Problem solved.[/b]
Lakestone
 
Posts: 86
Joined: Tue Jan 31, 2012 2:29 pm

PreviousNext

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

Who is online

Users browsing this forum: No registered users and 1 guest