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?

Re: Program to view Open Raise % by position?
 

mehh [img]/images/graemlins/frown.gif[/img] Maybe i should convert to MYSQL, standard PT format wont let me run these cool appz huh?

Re: Program to view Open Raise % by position?
 

You mean you have installed PostgreSQL 8.2. on a different port than "5432"?

Are you unable to change back to 5432,
or do you need a guide how to do that?

Re: Program to view Open Raise % by position?
 

I double-click the SQL.exe, but nothing happens, not even error message?

Re: Program to view Open Raise % by position?
 

[ QUOTE ]
You mean you have installed PostgreSQL 8.2. on a different port than "5432"?

Are you unable to change back to 5432,
or do you need a guide how to do that?

[/ QUOTE ]

I have postgre8.2 on port 5433 since I followed the guide at PT when I upgraded to the new SQL version. I have now uninstalled my old postgresql version so only using 8.2.

How do I change it to use port 5432 for all my databases?

Re: Program to view Open Raise % by position?
 

The top % of hands is always debatable, which is why a graphical hand range will never be 100% accurate.

Re: Program to view Open Raise % by position?
 

Here are soe quote's on how to change the port:
[ QUOTE ]
Our House,

The postgresql.conf file is just a plain old text file. Open it in notepad, wordpad, etc then look for this section near the top...

[ QUOTE ]
#---------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#---------------------------------------------------------------------------

# - Connection Settings -

listen_addresses = '192.168.100.90' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
port = 5432
max_connections = 100
....


[/ QUOTE ]

Then change the port from 5433 to 5432 and restart the PSQL service.

[/ QUOTE ]

You can find the postgresql.conf (and all other things) by going to "Start"-&gt;"All Programs"-&gt;"PostgreSQL"-&gt;"Configuration Files" ....

[ QUOTE ]
That worked, Perc. Thank you! I needed to take some of the other steps from my earlier post.

A few things to note (for others who need to do this):

- Stop the PostgreSQL service
- Change the port# to 5432 in the postgresql.conf file
- Remove the PostgreSQL settings in PokerTracker and add them again under port# 5432
- Go to the ODBC datasources (System DSN tab) and edit all of the unicode databases and the unicode test port so that they are also at port# 5432
- Enter the PGAdminIII tool from the start menu (under PostgreSQL) and change the properties of the 8.1/8.2 Database Server so it works from port# 5432
- Restart the PostgreSQL service

** If PokerAceHUD doesn't update stats correctly (mine didn't), then just close BOTH PAHUD and PokerTracker, run the registry editor from my above post, and reopen them.

That should do it.

[/ QUOTE ]

Re: Program to view Open Raise % by position?
 

Hmmmmm. Hard to say.

The SQL.exe need to access the internet,
because the trial period is saved online...
As I said i have written this tool few weeks/months ago
and was not sure wether it will advance to a real project or not...

Back to your problem:
Is maybe the firewall blocking it?

Re: Program to view Open Raise % by position?
 

This information is something I've wanted for a long time so I was happy to read about your app. So I downloaded, unzipped, and ran SQL.exe. It started ok, and I went to options and added a couple of my PT SQL db's. They did seem to be added OK (BTW am I supposed to check the box under active? I tried it both ways, in any case). However when I type in my own username in the box at the upper left and click Add there is no data in the table that appears. I am getting data though on other users.

Any ideas, suggestions?

Re: Program to view Open Raise % by position?
 

Hm weird.

You can query your DB(s) for other player but not for yourself?
Sounds as if you search for the wrong playername,
but i guess you know your own screenname [img]/images/graemlins/smile.gif[/img].

Im not familiar with all those PT "alias" stuff.
Did you recently changed your screenname or use the alias stuff?

Usually the name which is displayed under "ring gameplayer stats" in PT is what you have to enter in the SQL-App.

Edit: Oh and "yes" you have to check the box under "active" otherwise the database will not be used.
It is only in there to ease the switch between databases...

Re: Program to view Open Raise % by position?
 

Snood, what's CR if CT?

(very nice btw)

(and I have the same problem - none of my screennames show up, everyone else is fine. Weird.)

Re: Program to view Open Raise % by position?
 

I'm not quite sure but i think "CR if CT" is "Call River if Call Turn".

Re: Program to view Open Raise % by position?
 

[ QUOTE ]
Here are soe quote's on how to change the port:
[ QUOTE ]
Our House,

The postgresql.conf file is just a plain old text file. Open it in notepad, wordpad, etc then look for this section near the top...

[ QUOTE ]
#---------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#---------------------------------------------------------------------------

# - Connection Settings -

listen_addresses = '192.168.100.90' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost', '*' = all
port = 5432
max_connections = 100
....


[/ QUOTE ]

Then change the port from 5433 to 5432 and restart the PSQL service.

[/ QUOTE ]

You can find the postgresql.conf (and all other things) by going to "Start"-&gt;"All Programs"-&gt;"PostgreSQL"-&gt;"Configuration Files" ....

[ QUOTE ]
That worked, Perc. Thank you! I needed to take some of the other steps from my earlier post.

A few things to note (for others who need to do this):

- Stop the PostgreSQL service
- Change the port# to 5432 in the postgresql.conf file
- Remove the PostgreSQL settings in PokerTracker and add them again under port# 5432
- Go to the ODBC datasources (System DSN tab) and edit all of the unicode databases and the unicode test port so that they are also at port# 5432
- Enter the PGAdminIII tool from the start menu (under PostgreSQL) and change the properties of the 8.1/8.2 Database Server so it works from port# 5432
- Restart the PostgreSQL service

** If PokerAceHUD doesn't update stats correctly (mine didn't), then just close BOTH PAHUD and PokerTracker, run the registry editor from my above post, and reopen them.

That should do it.

[/ QUOTE ]

[/ QUOTE ]




i would like to try this out but not sure how to switch my 8.2 pokertracker databases, which are port5433, over to port 5432

i am unsure on what to do regarding some of the steps above - i need more specific directions (i am a database noob).

is there no way to get the program to see the databases in port 5433 ?


how ?- Stop the PostgreSQL service
- Change the port# to 5432 in the postgresql.conf file
- Remove the PostgreSQL settings in PokerTracker and add them again under port# 5432
how ? - Go to the ODBC datasources (System DSN tab) and edit all of the unicode databases and the unicode test port so that they are also at port# 5432
how ? - Enter the PGAdminIII tool from the start menu (under PostgreSQL) and change the properties of the 8.1/8.2 Database Server so it works from port# 5432
how ? - Restart the PostgreSQL service


cheers,
sean

Re: Program to view Open Raise % by position?
 

I worked on the databaseconnection of my applications.
One can now configure on which port the database(s) are running.
For this purpose a new field ("Port") has been introduced under "Main"-&gt;"Options"-&gt;"Databases".

The new version 1.5 can be downloaded here:
www.spadeit.com/sql.zip

Can anyone with the database on Port 5433 reply that it's working, so i can continue upading my other applications, too. Thanks

Re: Program to view Open Raise % by position?
 

The latest version won't unzip - says invalid archive or some such.

Also - any chance you would share the SQL statements you used to generate the tables for preflop raise, cold call, allin range, etc?

Re: Program to view Open Raise % by position?
 

Can you please retry to download?
Download and unzip is working for me :/.
Maybe got to clear the browser cache, or my provider had some problems...

I can't share the SQL statements simply because there are no statements to share.

I just go through every hand of a player and do the analysis on my own...

Re: Program to view Open Raise % by position?
 

i am downloading...will report back regarding port recognition functionality.

thanks for the fix.
sean

Re: Program to view Open Raise % by position?
 

[ QUOTE ]
I worked on the databaseconnection of my applications.
One can now configure on which port the database(s) are running.
For this purpose a new field ("Port") has been introduced under "Main"-&gt;"Options"-&gt;"Databases".

The new version 1.5 can be downloaded here:
www.spadeit.com/sql.zip

Can anyone with the database on Port 5433 reply that it's working, so i can continue upading my other applications, too. Thanks

[/ QUOTE ]



it is now working with port 5433.

haven't had a chance to really try the sql app out yet but i can confirm that your upgrade allows it to see my 8.2 databases.

thanks,
sean

Re: Program to view Open Raise % by position?
 

RE: Mr. Snood's SQL appliation - initial feedback


hello mr. snood,

i gave your application a quick perusal. my initial impression is quite positive as i believe it could have some utility.

one question -- when i use the "search for player" option the program seems to load all the tables i had open -- is there any way to limit the tables it searches for players?

basically, SQL took a long time to load all the tables i had open thus limiting the tables might allow one to start using the program much quicker (there was quite a long delay before it was functional).

especially given i was really only interested in the players at 4-5 tables at a time, not the other 7-8 i had open in the background.

for example, it would be useful to have the option to have it search for players ONLY from the tables at which you were seated, as these are essentially the main players of interest during a session.

&lt;if the above was not doable&gt; a couple more similar ideas might be to add an option to search for players ONLY from the tables active on the screen (meaning NOT the minimized tables in the background) or search for players ONLY from the highlighted table (the one with the focus).

Note - the long delay in SQL loading may be a problem at my end--perhaps caused by my somewhat aging computer and all the other essential poker apps i was running at the same time.

finally, is there anyway to clear the player list without having to remove one player at a time?

anyway thanks for creating this cool little tool.

cheers,
sean


ps. the default/buddy list looks like a great idea

Re: Program to view Open Raise % by position?
 

Works like a charm on port 5433.

Looks very nice!

Some request/bug reports:

1) I can't show my own stats. I think this is because I have linked different sreennames togheter with the alias option in PT.

2) Would be nice to tell which suit a players card is, so you could see if he was on a draw when going all inn. (now it just says JTs or JTo).

3) Could you also add limping hands and reraise PF hands?

4) Could you also add blind defence hands? (just like the cold call stat only for the blinds.

5) Is it possible to fix the cold call % error? This is also a problem in PT. Could call % is currently CC/all hands, while it should be CC/possible CC situation.

6)This is probably not possible, but: it would be nice to see how many other people had called a raise before the player CC/reraise. Or how many people had limped before the player limps.

7) Probably also hard: Is it possible to retrive the actuall handhistoried directly from the program. Much like you can do from PT, only it's much faster to find a hand similar to one your playing with this program.

Great program!

Re: Program to view Open Raise % by position?
 

-one other addition-

sven,

sort the all-in hands by hand rankings--the ace-x hands then the k-x hands and so on (i.e., AA, AK, AQ...down to..A2, KK, KQ, KJ.......)

currently i cannot tell how it is sorted down the list which makes it hard to view multiple instances of the same or similar starting hands and how they were played.

cheers and thanks again,
sean

Re: Program to view Open Raise % by position?
 

Phew quite a lot requests and feedback [img]/images/graemlins/smile.gif[/img]

- Instead of retrieving players from all tables i could indeed change it to retrieve only players from tables we are sitting at.

- I can add a button to clear the complete playerlist...

Re: Program to view Open Raise % by position?
 

1) Yes the alias seem to be the reason for not being able to get the own stats. I got to see what the "alias" is causing in the database to fix it...

2) To the all-in chart it would be the best i think to evaluate the players hand.
So leave the chart as it is, but put an additional column with the handrank.
For example "Toppair","Flushdraw","Highcard"....

3) Adding limping hands should not be a problem.
"Reraise" hands would be a mixture of 3-bet and 4-bet hands i guess. Is this wanted?

4) Nice idea. I would think of two charts for blind defense.
One for the hands he calls against a blindsteal.
One chart for the hands he reraises against a blindsteal.

5) This would be too much work for me and the cpu/harddisk i think, as it would be needed to reparse the handhistories to get the necessary information.

6) Hm it's not exactly possible. I can add the number of "possible" caller, instead of the exact number of previous caller.

7) I didn't understand this point.
The "actual handhistory"?
Hmmm. Or do you think of somthing like this:
When watching for example the limp/reraise chart of a player, an ability to get the handhistories where the player limp/reraised?


All this points sounds very nice and would improve the app quite a lot i think, but it will be hard for me to find the time to work on all of them :/

Re: Program to view Open Raise % by position?
 

[ QUOTE ]
Phew quite a lot requests and feedback [img]/images/graemlins/smile.gif[/img]

- Instead of retrieving players from all tables i could indeed change it to retrieve only players from tables we are sitting at.

- I can add a button to clear the complete playerlist...

[/ QUOTE ]



any improvements you can make would be most excellent!

thanks,
sean

Re: Program to view Open Raise % by position?
 

[ QUOTE ]

2) To the all-in chart it would be the best i think to evaluate the players hand.
So leave the chart as it is, but put an additional column with the handrank.
For example "Toppair","Flushdraw","Highcard"....


[/ QUOTE ]


sven,
this idea sounds great.

currently it is difficult to look through the all-in list and easily figure out what kinds of hands the player is going all-in with.

a column with hand rank sounds great---perhaps sort the list by this hand-rank column from strongest to weakest, which would make it much easier to obtain meaningful information quickly from the list for each player.

thanks again for whatever improvements you can make.

sean
vancouver, canada

Re: Program to view Open Raise % by position?
 

2) sounds great!

3) This would be very very usefull. Even better if you could differentiate the 3 and 4 bets.

4) The chances you suggested sounds very good.

5) Thats just what PAHUD Josh said on the matter. Guess it's just not possible.

6) Not sure how usefull this would be.

7) Sorry about being a bit blury. In the last sentance you examplify just what I ment.

One more thng: Would be great to see with what hands the player calls a 3 bet PF.