PDA

View Full Version : simple pokertracker question


threeonefour
04-14-2005, 07:18 PM
how do i export my earnings over time from pokertracker.

ie i want to have a column of data that i can put in excel or whatever that show my total profit from poker each day(culmulative). basically i want it to mirror was my online account balance at the end of each day i played.

OrcaDK
04-14-2005, 07:31 PM
Open your poker tracker database using Access. Create a new "View" using Design View. Switch to SQL mode (top left button below file menu) and paste the following:

SELECT session.player_id, session.session_start, session.amount_won
FROM [session]
WHERE (((session.player_id)=4))
ORDER BY session.session_start;

Replace the "4" with your own playerid, it can be found somewhere in the start of the players table. Now save the view, right click it and select "Export...". Then you can save it as an excel document and make all the graphs you want /images/graemlins/smile.gif