Stats based only on hands played vs hero ?

General discussion of PokerTracker 3.

Moderator: Moderators

Stats based only on hands played vs hero ?

Postby joker » Mon Jun 29, 2009 3:37 am

Hi,

Is there some way how can I show stats on player based only on hands where I was involved with him ? For example "fold bb to sb steal" stat can be quite inaccurate I think in situation, when other ppl usually steal by raising 3-4bb preflop and we are opening only to 2-2,5bb. I can assume that than they will fold their big blind to this steal less often and someone will rarelly fold any two in this situation (and they still can have the basic "fold bb..." statistic very high). Using only my play and not datamined database should help, but still there will be other players who attemps to steal each other and the number still won´t be accurate.

Thank you.
joker
 
Posts: 67
Joined: Sat May 17, 2008 7:38 am

Re: Stats based only on hands played vs hero ?

Postby WhiteRider » Mon Jun 29, 2009 4:02 am

You can't do that in the HUD, but you can do it in a custom report - see this post.

You could build a custom stat to count how often a player folds to different sizes of steal raises if you like; and you could use that in the HUD.
Custom Statistics and Reports FAQ.
There are database fields like: holdem_hand_player_detail.amt_p_raise_facing which will help.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Stats based only on hands played vs hero ?

Postby joker » Mon Jun 29, 2009 4:12 am

Before I start to work on it, can you confirm that I understand correctly what you said - I will be able to make a HUD stats like "fold BB to 2bb SB steal" ?
joker
 
Posts: 67
Joined: Sat May 17, 2008 7:38 am

Re: Stats based only on hands played vs hero ?

Postby WhiteRider » Mon Jun 29, 2009 4:34 am

Yes, you can do that.
You'll probably want to check a range rather than a specific value, though.
If you have trouble building it please post back and tell us where you're stuck and we'll help.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Stats based only on hands played vs hero ?

Postby joker » Mon Nov 23, 2009 5:54 pm

Hi,

I returned to this idea after a while, but I am absolutelly lost and even dont know where to start. Can you pls give me little advice ? Thank you.
joker
 
Posts: 67
Joined: Sat May 17, 2008 7:38 am

Re: Stats based only on hands played vs hero ?

Postby WhiteRider » Mon Nov 23, 2009 6:10 pm

That sort of report isn't simple, and we've only really started playing with them ourselves.
The filter does work, but I can't explain exactly how.
I think Kraada has played around more with these kind of reports to he may be able to give you some further help when he comes on next, but it's not going to be absolutely straightforward even then.
An easier interface for this will be added at some point, but for now you'll need to use this complex query.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Stats based only on hands played vs hero ?

Postby kraada » Tue Nov 24, 2009 10:12 am

I believe this should do the trick for you, add it as a filter to your custom report (you'll want to add the Player stat, and the Fold SB/BB to steal stats):

holdem_hand_player_statistics.id_hand in (SELECT holdem_hand_player_statistics.id_hand from holdem_hand_player_statistics, holdem_hand_player_detail, player, holdem_limit, settings where player.id_player = holdem_hand_player_statistics.id_player and player.id_player = (SELECT setting_value::int from settings where setting_name = 'my_player_id') and holdem_hand_player_detail.id_player = holdem_hand_player_statistics.id_player and holdem_hand_player_detail.id_hand = holdem_hand_player_statistics.id_hand and holdem_limit.id_limit = holdem_hand_player_statistics.id_limit and holdem_hand_player_statistics.flg_steal_att and holdem_hand_player_detail.amt_p_raise_made <= 2.5 * holdem_limit.amt_bb)

It at least appears to work for me :)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Stats based only on hands played vs hero ?

Postby joker » Thu Dec 10, 2009 10:36 pm

Ok I think that I somehow configured the custom report to show players "fold BB to SB steal" stat only for less than 2.5 BB steal raise. But I have a few problems -

1) When I change the value to 1000 BB, report should show basically the same value as original "fold BB to SB steal stat" in general tab, right ? But report shows different value and only half of hands

2) I cant run the same report in my other datamined databases

3) How can I build the HUD stat from this report ?

Thank you
joker
 
Posts: 67
Joined: Sat May 17, 2008 7:38 am

Re: Stats based only on hands played vs hero ?

Postby WhiteRider » Fri Dec 11, 2009 4:54 am

1. This report/filter only shows hands against a specific player so it won't match any other reports as they are for all your hands.

2. Presumably your screen name isn't in your datamined databases, so this filter won't work there.

3. You can't - this kind of filter only works in custom reports at the moment.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Stats based only on hands played vs hero ?

Postby joker » Fri Dec 11, 2009 9:25 am

joker :

"Before I start to work on it, can you confirm that I understand correctly what you said - I will be able to make a HUD stats like "fold BB to 2bb SB steal" ?"

whiterider :

"Yes, you can do that."

Is there than any other way how to make it at the moment ?
joker
 
Posts: 67
Joined: Sat May 17, 2008 7:38 am

Next

Return to General [Read Only]

Who is online

Users browsing this forum: No registered users and 24 guests

cron
highfalutin