Sponsor Ad: SpadeEye is powered by PokerStrategy.com

PokerStrategy is the world's biggest poker school!
They offer you an entire poker education for free (videos, coachings, articles and more).
You will get $50 starting capital plus $100 bonus to start your poker career. That means you do not have to deposit your own money.
This offer is absolutely free and without any obligation. You are not agreeing to any sort of financial or legal duties, neither a bank account nor a credit card is needed!
Register now

Table of contents

First steps:
Configuration of PokerTracker 3 databases.
Configuration of Pokertracker PostgreSQL databases.
Configuration of Pokertracker Access databases.
Configuration of Pokeroffice mySQL databases.
Configuration of Pokermanager Firebird databases.
Configuration of Holdem Manager databases.
The Mainwindow
Deeper look into the Options:
General
Limit
Open tables
Close tables
Profiles
How to use CSV files
Remarks:
Pokertracker PostgreSQL installation
Mine more than the allowed number of tables

New: A french guide can be found at www.pokercollectif.com
New: German guide

Configuration of Pokertracker 3 databases

Open the "Databases"-tab from the options dialog.
- Set "Type" to "PokerTracker 3"
- Set "Host" to "localhost"
- Set "Port" to "5432"
- Set "Database" to "PT3 DB"
- Set "Username" to "postgres"
- Set "Password" to "dbpass"

The above are the default PokerTracker 3 settings.
Maybe you set a different "Database"-name.
Then you need to take a closer look at "database->database management" in PokerTracker 3.
There you can see all your databases.
Important: You need to use the name from the most right column "database info".

Configuration of Pokertracker PostgreSQL databases


  • Open the "Databases"-tab from the options dialog.
  • Select "Pokertracker (PostgreSQL)" from the listbox.
  • Insert "localhost" for "Host".
  • Default port is "5432". So insert "5432" as "Port" unless you installed PostgreSQL on another port.
  • Put the name of the database you wish to add in the field "Database".
    One can get this name by starting Pokertracker and going to "File"->"Maintain Database Names", as shown in the picture:

    Be careful: One have to use the Value from the column "DB File/DB Name/DSN" which is casesensitive!
  • Put your username and password for the database in the fields "Username" and "Password".
  • Now press "Add Database".
  • If everything went right, the Database will be added to the list.
    If a failure occurs a messagebox will show extended information about the error.

    Note: Don't forget to check the last column (active) to activate the added database.
    Otherwise the database will not be used.

    A small video on how to configure a Pokertracker PostgreSQL database with SpadeEye can be seen here

    Configuration of Pokertracker Access databases


  • Open the "Databases"-tab from the options dialog.
  • Select "Pokertracker (Access)" from the listbox.
  • Put the name and fullpath of the Accessdatabase you wish to add in the field "Database" (for example "C:/Programme/Poker Tracker V2/ptrack.mdb").
  • Now press "Add Database".
  • If everything went right, the Database will be added to the list.
    If a failure occurs a messagebox will show extended information about the error.

    Note: Don't forget to check the last column (active) to activate the added database.
    Otherwise the database will not be used.

    A small video on how to configure a Pokertracker Access database with SpadeEye can be seen here

    Configuration of PokerOffice mySQL databases


  • Open the "Databases"-tab from the options dialog.
  • Select "PokerOffice (mySQL)" from the listbox.
  • Insert "localhost" for "Host".
  • Put the name of the database you wish to add in the field "Database" ("PokerOffice" in most cases).
  • Put your username and password for the database in the fields "Username" and "Password" (in most cases username:"root" and leave password empty).
  • Now press "Add Database".
  • If everything went right, the Database will be added to the list.
    If a failure occurs a messagebox will show extended information about the error.

    Note :To add other databases than the default database "pokeroffice" is a bit tricky,
    because there is a difference between the real databasename and the name that Pokeroffice displays.
    If the Pokerofficename of your database is for example "Nov2006" then the real databasename is always extended by "_podb".
    So you would have to add a database called "Nov2006_podb" in SpadeEye.

    Note: Don't forget to check the last column (active) to activate the added database.
    Otherwise the database will not be used.

    Configuration of Pokermanager Firebird databases


  • Open the "Databases"-tab from the options dialog.
  • Select "Pokermanager (Firebird)" from the listbox.
  • Insert "localhost" for "Host".
  • Put the full path to your database file (*.fdb) into the fiel "Database".
    One can get this path by starting Pokermanager and going to "Tools"->"Advanced"->"Database Connection..." as shown in the picture:

    In the examples case we would have to put "C:\Programme\PokerManager\PokerManager.fdb" into "Database".
  • Put your username and password for the database in the fields "Username" and "Password".
    In most cases username is "sysdba" and password is "masterkey".
  • Now press "Add Database".

  • Note: Don't forget to check the last column (active) to activate the added database.
    Otherwise the database will not be used.

    Configuration of Holdem Manager databases

  • Open the "Databases"-tab from the options dialog.
  • Select "Holdem Manager" from the listbox.
  • Insert "localhost" for "Host".
  • Default port is "5432". So insert "5432" as "Port" unless you installed PostgreSQL on another port.
  • Put "HoldemManager" in the field "Database".
  • Put your username and password for the database in the fields "Username" and "Password".
  • Now press "Add Database".

  • Note: Don't forget to check the last column (active) to activate the added database.
    Otherwise the database will not be used.

    The mainwindow



    The Mainwindow is split into 3 parts.
    The upper part is the list of available tables.
    The middle part are the players which are sitting at a selected table from the upper part.
    The lower part is a list of all players at all tables.
    So the lower part gives you an overview of for example:
    - "where are the 'worst' players playing"
    - "how much tables do a player play"
    and so on...

  • Get Table List: Retrieves the list of tables from the currently selected limit in the Pokerclient software.
  • Scan This Table: If a table from the list is selected the playerstatistics are computed from the databases.
  • Scan All Tables: Refreshs the tablelist and computes the playerstatistics.
  • Open: Opens the selected table.
  • Join: Joins the waitinglist of the table, if the table is full, otherwise the table gets opened.
  • Minimize: If checked, all Pokertables gets automatically minimized while datamining.

  • Deeper look into the Options: General


  • Destination Directory: Choose a directory where to put the handhistories from datamining.
  • Extension: Specify which extension the files should have (for example "txt" or "hhf").
  • Datamine observed only: If this option is checked tables you are playing at will not get mined.
  • Add 6-max tag: If this option is checked a 6-max tag will be added to every Hand no matter if it is 6-max or not!
  • Delay between passes: If one have a slow machine one can try to raise this value, but be careful it may result in loss of data while datamining.

  • Note: I suggest you to use the following settings for datamining PartyPoker:
  • "Destination directory" should be set to "[...]PartyGaming\PartyPoker\HandHistory".
  • Extension should be set to "txt".
  • With this setting the Pokertracker autoimport should be able to find the correct files.

    Deeper look into the Options: Limit


  • Tables: Displays the tables available in the pokerclient software.
    Watch out: If the pokerclient software is not opened an errormessage will be displayed, because the available tables can not the retrieved and therefore not be shown in the list!
  • Add table: If a table from the list of tables is selected and "Add table" is beeing pressed, then this table will be added to the list of limits to datamine.
  • Remove table: Removes a limit from the list of limits to datamine.
  • Remark : If the list of limits to datamine is empty then always the currently selected limit within the pokerclient software will be datamined!.
    If the list of limits to datamine is not empty then datamining begins with the first limit from the list and switches to the next limit if no tables meet the specifications for datamining and so on.

    Deeper look into the Options: Open Tables


  • Open tables automatically: If checked, then tables get opened automatically for datamining.
  • Open 6-max tables only: If checked only 6-max tables get datamined otherwise only fullring tables get datamined.
  • Minimum number of player: A table will not get opened if the playercount is lower than specified.
  • Deeper look into the Options: Close Tables


  • Close table if number of player below : If the number of player at a table drop under this threshold a table get closed and replaced by a new one, which meets the conditions.
  • Close table if Avr. Pot below: If checked, tables with the specified minimum average potsize will get datamined.
  • Close table if more than X player with Y hands on it: Here one can define what an "unknown" player is and when to close a table, because too many known player are there sitting at.
    With this option a more efficient datamining is possible, because only the tables with unknown players get opened automatically and in addition, if the count of known player arise a table gets closed and replaced by a new one!
  • Deeper look into the Options: Profiles


    In order to identify "good" and "bad" tables with one look, it is possible to specify his own colorprofiles for VPIP, PFR, AF and number of hands.
    A profile only gets activated if more then the specified value of hands of a player are available from the database.
    This will help to prevent the distortion of the tablestatistics if only very few hands of a player are available.

    How to use CSV files

    You can search your Pokertracker database for buddies and import them via CSV-file into SpadeEye.
    - Open Pokertracker and go to "File"->"Ring game player statistics".
    - Go to the "Preferences" tab as shown in image 1.

    Image 1: Pokertracker preferences
    - Activate the filter and specify the statistics the buddies should have.
    - Go to the "Summary" tab and press the small "e" for "Export" (image 2).

    Image 2: Pokertracker summary
    - Uncheck all rows except "Player" (image 3).

    Note:This list is scrollable.
    - Select "Comma seperated" as file type.
    - Uncheck "Include Headers".
    - Insert a filename and press "Export".

    Pokertracker PostgreSQL installation

    Please visit the Pokertracker guide here:
    Guide

    Mine more than the allowed number of tables

    It is possible to mine more than 12 tables at once. The trick is to create useraccounts under Windows XP, and datamine at the same time with all of them.
    What you have to do in Windows:
    1. Press "Start"->"Settings" and open the "Control Panel".
    2. Doubleclick "Users" in the control panel. 3. Press "Create a new account" as seen in the following picture:

    4. Insert a username and press "next".
    5. Choose "Computeradministrator" in the following screen and create the XP-account.

    Next step is to configure SpadeEye:
    1. Copy your SpadeEye directory to a new directory (for example "SpadeEye2").
    2. Run your copy of SpadeEye and set the "number of tables to open" to 4.
    It is not possible to mine more than 4 tables, because we can not log in to the pokerclient twice with 1 Account.

    Thats all.
    Now you have to:
    1. Run the pokerclient software under the first user.
    2. Run SpadeEye under the first user and start datamining.
    3. Switch to the second XP-account ("Start"->"Log off").
    4. Log into your second XP-account.
    5. Run the pokerclient software under the second user.
    6. Run SpadeEye under the second user and start datamining.

    Remark:
    There is one small issue. If both copies of SpadeEye are setup to datamine the same limit, one can get the same hands twice, because the current version of SpadeEye is not able to know which tables the other instance is mining at.
    The best trick to avoid this problem is to specify different limits to mine. For example instance 1 could datamine $2/$4 SH and instance 2 could datamine $3/$6 SH (Just specify the limits under "Options"->"Limit"-tab).