A New(?) Suggestion for tracking metric

[Nicholasp27]

forgive me if this is already in some of the tracking programs/spreadsheets or if this is already known, but i was wondering about the usefulness of grabbing your chip stack at each level (and # of players left at table) in each tourney and graphing that trend...knowing that you are shortstack when down to 4 players 80% of the time could be useful information...seems like knowing how u trend in varying levels and players left would tell u more about how passive/aggressive you are being on the bubble and with stealing than just itm% or 1/2/3 distribution...

[mlagoo]

Seems like a good idea. I don't know of any programs that currently do this, and I don't see any reason that it isn't implementable (no way is that a word).

Hopefully one of our computer geniuses can add something like this.

[bluewilde]

Yeah, J_Chap suggested the same thing but it sorta faded away (as far as I know).

linky

[Nicholasp27]

oh, looks like i saw that already before and was the only responder...guess people aren't so interested in it

but i bet if i made that program, people would be interested then

[bluewilde]

[ QUOTE ]
oh, looks like i saw that already before and was the only responder

[/ QUOTE ]

pehraps I should have included a smilie after "faded away," the humor seems to have been lost [img]/images/graemlins/smile.gif[/img]

[ QUOTE ]
but i bet if i made that program, people would be interested then

[/ QUOTE ]

Absolutely; it could be earth-shattering or inconsequential (probably in-between), but I for one would be very interested to toy around with it if someone could develop it

[Nicholasp27]

ok, so this wouldn't be too difficult from a coding pov...the hh file on your hdd tells you level:x and Total Number of players:x and then your chip stack

so the question is what data to get and display

a) average your stack on each level for each tourney and just display your average stack per level

b) do same with # of players

c) put each hand's stack/level/#players into a database and then put all tournies together hand by hand to show a hand-by-hand graph of where you stand (maybe also broken out by # of players)

[maddog2030]

[ QUOTE ]
but i bet if i made that program, people would be interested then

[/ QUOTE ]

I've thought about doing it, but I've been too busy with other things. If you don't, I probably will once school starts back up.

[tigerite]

Getting the data from the HH isn't very tough, no. I've done it in AutoHotKey even.

[Nicholasp27]

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;