Page 1 of 6

Stats based only on hands played vs hero ?

PostPosted: Mon Jun 29, 2009 3:37 am
by joker
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.

Re: Stats based only on hands played vs hero ?

PostPosted: Mon Jun 29, 2009 4:02 am
by WhiteRider
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.

Re: Stats based only on hands played vs hero ?

PostPosted: Mon Jun 29, 2009 4:12 am
by 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" ?

Re: Stats based only on hands played vs hero ?

PostPosted: Mon Jun 29, 2009 4:34 am
by WhiteRider
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.

Re: Stats based only on hands played vs hero ?

PostPosted: Mon Nov 23, 2009 5:54 pm
by joker
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.

Re: Stats based only on hands played vs hero ?

PostPosted: Mon Nov 23, 2009 6:10 pm
by WhiteRider
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.

Re: Stats based only on hands played vs hero ?

PostPosted: Tue Nov 24, 2009 10:12 am
by kraada
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 :)

Re: Stats based only on hands played vs hero ?

PostPosted: Thu Dec 10, 2009 10:36 pm
by joker
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

Re: Stats based only on hands played vs hero ?

PostPosted: Fri Dec 11, 2009 4:54 am
by WhiteRider
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.

Re: Stats based only on hands played vs hero ?

PostPosted: Fri Dec 11, 2009 9:25 am
by joker
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 ?

highfalutin