View Single Post
  #9  
Old 07-29-2005, 04:45 PM
Nicholasp27 Nicholasp27 is offline
Member
 
Join Date: Aug 2004
Posts: 93
Default Re: A New(?) Suggestion for tracking metric

ok, i just took a look at poker tracker, and it does a good job of bringing in the hand histories for you...and the table tourney_game_players gives us what we need: # of players left, etc...in fact, if u use poker tracker and have Access on your computer, open the ptrack.mdb and create a new query and go into sql mode and copy the following (replace fastrabbit05 with your screen name) and run it and it will tell you your average chip stack for each # of players over all of your imported tournaments:


SELECT tourney_game_players.number_of_players, Avg(tourney_game_players.chip_count) AS AvgOfchip_count
FROM players INNER JOIN tourney_game_players ON players.player_id = tourney_game_players.player_id
WHERE (((players.screen_name)="fastrabbit05"))
GROUP BY tourney_game_players.number_of_players;
Reply With Quote