new stat request

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

new stat request

Postby orentha » Fri Aug 08, 2008 8:30 pm

I cannot program anything to save my life, so I'd mess this up for sure :roll:

I'd like to see a limp call stat

where someone limps in PF, then calls a PFR, position doesn't matter or anything

if anyone has the time to check this out, it'd be greatly appreciated. (doesn't seem like that hard of a stat to do, but what do I know...)

Thanks
orentha
 
Posts: 29
Joined: Thu Jan 24, 2008 7:39 pm

Re: new stat request

Postby WhiteRider » Sat Aug 09, 2008 4:19 am

Please have a look at this thread:
viewtopic.php?f=15&t=9500&p=44868&hilit=limp+fold+stat#p44868
..where I created a very similar stat.

If you import these stats and duplicate them, you should be able to work out how to change them to get what you want.
If you can't work it out, let me know where you have got stuck and I'll help, but if you learn to do it yourself then you'll be able to build others too.

(BTW, I'd suggest putting the name of your stat in the title of new threads - there are loads of 'new stat request' threads, and it makes it really hard to find which one you want when looking back through them...)
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: new stat request... limp call stat

Postby orentha » Sat Aug 09, 2008 12:17 pm

cool thanks
I think that stat will work just fine... it's pretty much the same thing, say if a guy limp folds 75% of the time, then 25% of the time he will limp call
(and yes, i'm discounting the % of time he limp raises cause usually that will be 1-2% maybe...)


quick question about the download in that link.

it had 4 "stats" in it:
hand_pf limp fold opp.pt3stat
Hand_pf Limp Fold.pt3stat
Hand_pf Limp opp.pt3stat
Hand_pf Limp.pt3stat

just curious what the limp fold opportunity stat is for? as compared to the limp fold stat?
orentha
 
Posts: 29
Joined: Thu Jan 24, 2008 7:39 pm

Re: new stat request

Postby WhiteRider » Sat Aug 09, 2008 1:43 pm

Limp fold opportunity is the number of times the player limps and then faces a raise, so we can see how often he folds in that situation as a percentage, rather than seeing it as a percentage of all hands.

Let's say players A and B both fold to raises after they've limped 50% of the time, and both have played 1000 hands.
A limps every chance he gets - he's limped 200 times and been raised 100 of those times, so if he folds 50% of those, that's 50 times out of 1000 = 5%.
B limps rarely - he's limped 40 times and been raised 20 of those times, so if he folds 50% of those that's 10 times out of 1000 = 1%.

If we don't count opportunities, they look really different, where actually in this situation they behave the same.

Actually, re-reading your post - the limp fold opp STAT was just for my testing... :geek:
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 2 guests