garion888
03-04-2005, 01:10 PM
Hey all,
I've been using pokertracker for a while and i've noticed the lack of graphs. So I went searching and figured out a way to make them.
For this to work you need.
1. Pokertracker
2. Microsoft Access
3. Microsoft Excel
Here's some instructions and my graphs.
1. Start by turning off Pokertracker so it doesn't interfere with any of your databases while you're doing this.
3. Make a copy of the database you want to make graphs for.
2. Start up Microsoft Access and open your copied database.
3. There should be a window that opens inside access with a menu on the left. Click Queries.
4. Double Click "Create query in Design view"
5. In the upper left hand corner just below the file menu there will be a button with "SQL" on it. Click this button.
6. Now you will have a window with the text "SELECT;" in it. Delete this text and paste in the following text.
[ QUOTE ]
SELECT
game.date_played, game_players.total_bet,
game_players.total_won, game_players.hole_card_1, game_players.hole_card_2, game.flop_1,
game.flop_2, game.flop_3, game.turn, game.river,
game.winning_hand, game_players.final_hand
FROM
game game, game_players game_players
WHERE
game_players.game_id = game.game_id
AND game_players.played_hand='Y'
AND game_players.player_id=
(select pref_value from prefs where pref_key = 'RP')
ORDER BY game.date_played
[/ QUOTE ]
7. On the query menu, select "Run".
8. Now you will have a window columns. The columns run Date, total bet, total won, etc.
9. Select the total bet and total won columns and copy them(Ctrl-C).
10. Open Excel. Select Cell B1 and Paste in the data you copied from Access(Ctrl-V). Now the B column will be total_bet, and the C Column will be total_won.
11. In cell D1 type "Net Won". In D2 type the formula [ QUOTE ]
=C2-B2
[/ QUOTE ]
12. Now drag the black box at the lower right hand corner of cell D2 all the way down to the bottom of your hands.
13. In Cell E1 type "Sums". In E2 type the formula [ QUOTE ]
=sum($E$2:E2)
[/ QUOTE ] Now Drag this down just as you did with the formula in D2.
14. Now select all of column E and hit the chart button. Select XY(Scatter Plot)and select the smoothed lines version. Put in any other information you want and you should get something like this.
http://www.geneseo.edu/~jap15/graph1.jpg
I've also made some other graphs that have to do with Preflop luck. The pink lines are how many times I SHOULD have gotten a hand, the Blue lines are how many times I DID get those hands, and the Yellow lines are the differences (Got minus Should have Got). So you can see i'm very Lucky with my aces, but not so much with the range of hands Aces-Nines. The three graphs are Pocket Pairs, Suited Players, and Offsuit Players according to SSH.
http://www.geneseo.edu/~jap15/graph2.jpg
http://www.geneseo.edu/~jap15/graph3.jpg
http://www.geneseo.edu/~jap15/graph4.jpg
I've been using pokertracker for a while and i've noticed the lack of graphs. So I went searching and figured out a way to make them.
For this to work you need.
1. Pokertracker
2. Microsoft Access
3. Microsoft Excel
Here's some instructions and my graphs.
1. Start by turning off Pokertracker so it doesn't interfere with any of your databases while you're doing this.
3. Make a copy of the database you want to make graphs for.
2. Start up Microsoft Access and open your copied database.
3. There should be a window that opens inside access with a menu on the left. Click Queries.
4. Double Click "Create query in Design view"
5. In the upper left hand corner just below the file menu there will be a button with "SQL" on it. Click this button.
6. Now you will have a window with the text "SELECT;" in it. Delete this text and paste in the following text.
[ QUOTE ]
SELECT
game.date_played, game_players.total_bet,
game_players.total_won, game_players.hole_card_1, game_players.hole_card_2, game.flop_1,
game.flop_2, game.flop_3, game.turn, game.river,
game.winning_hand, game_players.final_hand
FROM
game game, game_players game_players
WHERE
game_players.game_id = game.game_id
AND game_players.played_hand='Y'
AND game_players.player_id=
(select pref_value from prefs where pref_key = 'RP')
ORDER BY game.date_played
[/ QUOTE ]
7. On the query menu, select "Run".
8. Now you will have a window columns. The columns run Date, total bet, total won, etc.
9. Select the total bet and total won columns and copy them(Ctrl-C).
10. Open Excel. Select Cell B1 and Paste in the data you copied from Access(Ctrl-V). Now the B column will be total_bet, and the C Column will be total_won.
11. In cell D1 type "Net Won". In D2 type the formula [ QUOTE ]
=C2-B2
[/ QUOTE ]
12. Now drag the black box at the lower right hand corner of cell D2 all the way down to the bottom of your hands.
13. In Cell E1 type "Sums". In E2 type the formula [ QUOTE ]
=sum($E$2:E2)
[/ QUOTE ] Now Drag this down just as you did with the formula in D2.
14. Now select all of column E and hit the chart button. Select XY(Scatter Plot)and select the smoothed lines version. Put in any other information you want and you should get something like this.
http://www.geneseo.edu/~jap15/graph1.jpg
I've also made some other graphs that have to do with Preflop luck. The pink lines are how many times I SHOULD have gotten a hand, the Blue lines are how many times I DID get those hands, and the Yellow lines are the differences (Got minus Should have Got). So you can see i'm very Lucky with my aces, but not so much with the range of hands Aces-Nines. The three graphs are Pocket Pairs, Suited Players, and Offsuit Players according to SSH.
http://www.geneseo.edu/~jap15/graph2.jpg
http://www.geneseo.edu/~jap15/graph3.jpg
http://www.geneseo.edu/~jap15/graph4.jpg