One for the geeks
As the Maltese hedge fund trader told me, it’s easy to spend too much time working out the P+L when you‘re working for yourself. Too easy. So I found a harder, more time-consuming way to do it. Winrates at limit poker are usually measured in big bets per 100 hands and the standard statistics program, PokerTracker, does just that, without any effort. No effort? No wasted time. How about profit/turnover instead of BB/100?
Not so easy since PokerTracker doesn’t tell you how much you’ve bet. The statistics are buried deep in the database, so you’re going to need to do some programming - specifically, an SQL query - to get them out. Don’t worry if you don’t know what SQL is, just use the instructions here to set-up a query.
Then use this:
SELECT
sum(iif(isnull(g.exrate), gp.total_bet, (gp.total_bet)/g.exrate)) as TURNOVER,
sum(iif(isnull(g.exrate), gp.total_won - gp.total_bet, (gp.total_won - gp.total_bet)/g.exrate)) as PROFIT,
(PROFIT/TURNOVER)*100 as MARGIN
FROM game_players AS gp INNER JOIN game AS g ON gp.game_id = g.game_id
WHERE gp.player_id = (select pref_value from prefs where pref_key = 'RP')
and g.date_played between #2006-01-01 00:00:00# AND #2006-08-07 23:59:59#
I’ve figured out that I wagered $611,426 and won $8,211 at a rate of 1.34% from the beginning of the year until mid-July, when I started a new database. Since then I’ve wagered $69,603 and won $1,384 at a rate of 1.99%.
I’ve also paid $23,851 in rake. God doesn’t play dice, but she did invent rakeback.