Pokertracker and R.O.I.

Return On Investment (R.O.I) is the ratio of money gained or lost  on an investment relative to the amount of money invested. i.e.

A thousand dollar investment and a profit of a hundred will result in a R.O.I. of  ten percent.

When I calculated my R.O.I. in pokertracker I found that the percentage was very low and I realized for the first time how marginal my edge is at the poker table. Pokertracker does not show R.O.I. but you can get it if question the database directly with Structured Query Language (SQL) .

 

This is how to do it:

  • I assume that you use a postgres database server instead of MsAccess!
  • I assume that you filled your screen name in the “preferences tab” in pokertracker. If this is not the case then the SQL statement below will not work!
  • The SQL statement will return the value of your R.O.I. from the player you used in the “preferences tab” AND all the aliases which are connected to it in the “general info tab”.
  • I advise you to run this query when you are not playing! Although I think it is unlikely that any problems will occur, even when you have a lot of hands in your database, why take the risk?


Open the start menu -> postgres -> pgAdminIII

  • Double click on the database server where your database is stored. By default there is only one server available.
  • Enter your postgres password if asked for it.
  • Double click on the pokertracker database you want to use.
  • Then click on the SQL button in the toolbar at the top of the screen.
  • Copy paste the bold text below into the SQL screen and then push the button with the green triangle on it. At the bottom of the screen you have to see the text “query running” or if you database is very small you might see an “instant” result”


SELECT ( SUM(total_won - total_bet) / SUM (total_bet)) * 100 AS ROI
FROM "players" P JOIN "game_players" GP ON
            P.player_id = GP.player_id
WHERE P.player_id IN (SELECT pref_value
                                   FROM "prefs"
                                   WHERE pref_key = 'RP')
                                   OR
                                   alias_id IN (SELECT pref_value
                                   FROM "prefs"
                                   WHERE pref_key = 'RP')

 

The value you get is your R.O.I.  in percent!