Program to view Open Raise % by position?
 

Is there a program that can view the Open Raise % by position? Or is it possible to somehow get the information out from PokerTracker with some SQL queries?

In poker tracker you can only see the PFR by position. It gives the correct open raise % UTG but not for the other positions since sometimes the pot is raised before the player get to act.

Att. To Steal Blinds in Poker Tracker gives this number for CO, BTN and SB combined (I think). But I want it for each position.

Re: Program to view Open Raise % by position?
 

This would indeed be very interesting!

Re: Program to view Open Raise % by position?
 

I will add this to poker buddy for you.

So let me be sure that I understand what you want.

You want the % of times the person is the first raiser from that position correct?

If there is anything else you would like to see let me know.

Re: Program to view Open Raise % by position?
 

First, get your player_id, or the player_id of the screen name you wish to study:

<font class="small">Code:</font><hr /><pre>
SELECT player_id FROM players WHERE screen_name = 'marand';
</pre><hr />

Because inclusion of your own stats will skew averages, since you of course have many more hands in the DB than you do on others.

say your player_id = 432 (substitute with your own result in the query below)

Then:

<font class="small">Code:</font><hr /><pre>
SELECT off_the_button, ROUND(AVG(raised_first_pf)*100,2)
FROM game_players
WHERE player_id != 432 AND number_of_players = 6
GROUP BY off_the_button
ORDER BY off_the_button ASC;
</pre><hr />

Should return a nice little table [img]/images/graemlins/smile.gif[/img]

note that this is raised FIRST IN - raising 1+ limper is not counted, this is purely open-raising.

If you wanted to check out a particular player, get their player id via their screen name and the first query, then switch the != to an = sign in the second query using their player_id.

dave.

Re: Program to view Open Raise % by position?
 

[ QUOTE ]
I will add this to poker buddy for you.

So let me be sure that I understand what you want.

You want the % of times the person is the first raiser from that position correct?

If there is anything else you would like to see let me know.

[/ QUOTE ]


I want to know the % of his hands the player open raises with from each position. For example 'marand' might open raise with the following in a 6-handed game:

UTG 13% - 22 AJ KQ A8s KTs QTs JTs
MP 17% - 22 AT KJ A2s KTs QTs JTs
CO 24% - 22 A9 KT QT JT A2s J9s-75s T9s-65s
BTN 29% - 22 A8 K9 Q9 J9 T9 A2s J9s-75s T9s-65s
SB 36% - 22 A2 KT QT JT T9 K5s Q6s J6s T6s 96s 86s 75s 65s

Other interesting things would be:
1) The % of hands he raises a limper with.
2) The % of hands he calls a open raise (by position on the open raiser).
3) The % of hands he calls _my_ openraises with depending on _my_ position.
4) The % of hands he raises _my_ openraises with depending on _my_ position.
5) The % of hands the average player in my database openraises with from each position.
6) The % of hands the average player reraises my open raises with depening on _my_ position.
7) The % of hands the average player calls my open raises with depending on _my_ position.

Re: Program to view Open Raise % by position?
 

[ QUOTE ]
[ QUOTE ]
I will add this to poker buddy for you.

So let me be sure that I understand what you want.

You want the % of times the person is the first raiser from that position correct?

If there is anything else you would like to see let me know.

[/ QUOTE ]


I want to know the % of his hands the player open raises with from each position. For example 'marand' might open raise with the following in a 6-handed game:

UTG 13% - 22 AJ KQ A8s KTs QTs JTs
MP 17% - 22 AT KJ A2s KTs QTs JTs
CO 24% - 22 A9 KT QT JT A2s J9s-75s T9s-65s
BTN 29% - 22 A8 K9 Q9 J9 T9 A2s J9s-75s T9s-65s
SB 36% - 22 A2 KT QT JT T9 K5s Q6s J6s T6s 96s 86s 75s 65s

Other interesting things would be:
1) The % of hands he raises a limper with.
2) The % of hands he calls a open raise (by position on the open raiser).
3) The % of hands he calls _my_ openraises with depending on _my_ position.
4) The % of hands he raises _my_ openraises with depending on _my_ position.
5) The % of hands the average player in my database openraises with from each position.
6) The % of hands the average player reraises my open raises with depening on _my_ position.
7) The % of hands the average player calls my open raises with depending on _my_ position.

[/ QUOTE ]
Nice idea, but I think the problem with this is that you will need tens of thousands of hands on a player before you get any sensible per-position stats.

Juk [img]/images/graemlins/smile.gif[/img]

Re: Program to view Open Raise % by position?
 

[ QUOTE ]
[ QUOTE ]
[ QUOTE ]
I will add this to poker buddy for you.

So let me be sure that I understand what you want.

You want the % of times the person is the first raiser from that position correct?

If there is anything else you would like to see let me know.

[/ QUOTE ]


I want to know the % of his hands the player open raises with from each position. For example 'marand' might open raise with the following in a 6-handed game:

UTG 13% - 22 AJ KQ A8s KTs QTs JTs
MP 17% - 22 AT KJ A2s KTs QTs JTs
CO 24% - 22 A9 KT QT JT A2s J9s-75s T9s-65s
BTN 29% - 22 A8 K9 Q9 J9 T9 A2s J9s-75s T9s-65s
SB 36% - 22 A2 KT QT JT T9 K5s Q6s J6s T6s 96s 86s 75s 65s

Other interesting things would be:
1) The % of hands he raises a limper with.
2) The % of hands he calls a open raise (by position on the open raiser).
3) The % of hands he calls _my_ openraises with depending on _my_ position.
4) The % of hands he raises _my_ openraises with depending on _my_ position.
5) The % of hands the average player in my database openraises with from each position.
6) The % of hands the average player reraises my open raises with depening on _my_ position.
7) The % of hands the average player calls my open raises with depending on _my_ position.

[/ QUOTE ]
Nice idea, but I think the problem with this is that you will need tens of thousands of hands on a player before you get any sensible per-position stats.

Juk [img]/images/graemlins/smile.gif[/img]

[/ QUOTE ]

Since all this stats are for preflop play you don't really don't need tens of thousands of hands. 2000 should give a fairly good idea. (I think)

Also all stats for 'average player' should give you a huge sample size.

Re: Program to view Open Raise % by position?
 

Thanks, I have no experience with SQL but will try what you suggested and see what happens [img]/images/graemlins/smile.gif[/img]

Re: Program to view Open Raise % by position?
 

Few weeks/months ago i have written a very similar application.
Some kind of advanced Preflop queries.
For example:
1) "Which hands (and how often) does a player raise from a particular position".
For example a player might raise AK only 50% of the time from UTG.

2) Which hands does a player coldcall with?
Does he coldcall AK instead of raising it?
Or does he coldcall only pockets and suited connectors?

3) Whats hands does a player limp reraise with?
Monster or junk?

4) With which hands does a player go all in?

You might want to take a look:
www.spadeit.com/sql.zip
Just unzip and run the executable.

Before you can use it you have to configure your
Pokertracker PostgreSQL database as described here:
http://www.spadeit.com/guide.php#1a
Currently only PT PostgreSQL databases are supported...

Once the database(s) is/are configured one can begin to search the db for a playername...

Edit: I put up some example screenshots for an easier understanding:
http://www.spadeit.com/sample1.png
http://www.spadeit.com/sample2.png
http://www.spadeit.com/sample3.png

Re: Program to view Open Raise % by position?
 

Looks great Mr Snood,

but I can't test it before Spadeit becomes compatible with Postgres 8.2

Any progress here?