Page 1 of 3

opp. 3bet jam range report?

PostPosted: Thu Jan 26, 2012 5:58 pm
by olistr
Hi, is possible to run report or anyhow to see situation
This is hyper HU SNG and spot 20-25 bb effective
I min raise and facing 3bet allin and I call
and I like to see opp. ranges in one place , like how many times I faced A3 or 55 and so on
hope you get it what I looking for:)
I wanna find out what is avg. range of population tendecies for random 3b jam 20-25bb effective

Re: opp. 3bet jam range report?

PostPosted: Thu Jan 26, 2012 6:53 pm
by kraada
This can certainly be done but you'll need an incredibly large database to get any meaningful data out of it.

The easiest way to do this will be to create a custom report in the Holdem Tournament Player Statistics section - add the Hole Card and Hands statistics to the report. Click on the blue Filters link, uncheck Filter on active player and add:

player.player_name != 'Your Screen Name'

Note you need the single quotes - this will filter out your data. Click Save to save that filter. Then use the Simple Filters area to create the rest of the filters that you need.

Re: opp. 3bet jam range report?

PostPosted: Fri Jan 27, 2012 3:53 am
by olistr
what u mean by this 'add the Hole Card and Hands statistics to the report' I added stats 3bet preflop and did rest u said but when I run report dont get any result

Re: opp. 3bet jam range report?

PostPosted: Fri Jan 27, 2012 4:22 am
by WhiteRider
See this tutorial for more information on working with custom reports.

Re: opp. 3bet jam range report?

PostPosted: Fri Jan 27, 2012 6:03 am
by olistr
I did everything mentioned here with this player.player_name != 'Your Screen Name' added to filters
but have result hands in columm and dont see how many times etc. 44 was dealth and not sure that is is displaying only opponents hole cards

Re: opp. 3bet jam range report?

PostPosted: Fri Jan 27, 2012 9:26 am
by kraada
There is a statistic named "HoleCards" in the list - that breaks the report down into one row per hole card. You need to add it to your report - see WhiteRider's tutorial for more on how to add stats to reports if it is not clear how to do so.

Re: opp. 3bet jam range report?

PostPosted: Fri Jan 27, 2012 5:02 pm
by olistr
Sorry I read tutorial 5 times and only result I can get is here in sreen shot , there is hands but no how many times the crads were dealth
etc like I am sure 33 were dealth 2 times and can I be sure that this is oppnent hole card only?




[url][URL=http://imageshack.us/photo/my-images/694/26717324.jpg/]Image[/url]

Uploaded with ImageShack.us[/url]

[url][URL=http://imageshack.us/photo/my-images/840/93165664.jpg/]Image[/url]

Uploaded with ImageShack.us[/url]

Re: opp. 3bet jam range report?

PostPosted: Fri Jan 27, 2012 6:02 pm
by kraada
Add another stat: Hands.

Re: opp. 3bet jam range report?

PostPosted: Fri Jan 27, 2012 7:49 pm
by olistr
Ok,i I appreciate that u helping me with this and I am close to right result but I think there is something wrong with this line
player.player_name != 'Your Screen Name'
cos when I use exactly same filter for report(without that line) and for tournament tab, I can see same hands that was played by me (so my hole cards) under tuornament tab and when I run report
but when I add that line u write for me, hand from report disapear and I can not see any hands when I run report
but I am sure that filter is set right and that spots are in my database

thanks a for your help

Re: opp. 3bet jam range report?

PostPosted: Sat Jan 28, 2012 7:13 am
by WhiteRider
I think there is a problem using != with the player name field.
Try using this filter instead:

holdem_hand_player_statistics.id_hand in (SELECT holdem_hand_player_statistics.id_hand from holdem_hand_player_statistics WHERE id_player != (select setting_value::int from settings where setting_name = 'my_player_id'))

Note: Use the filter exactly as written. Do NOT replace my_player_id with your name. It needs to be written exactly like that.

highfalutin