PokerTracker/Excel help needed

[joker122]

Is there any way to break down my PokerTracker results into *days*? Specifically, I'd like to export my daily results to an Excel spreadsheet just like I can export my results per session using the 'session notes' tab.

I asked the PokerTracker forum but Pat said pokertracker itself had no function that would do this, but I still think Excel might somehow be able to do it just from exported sessions. Any ideas? Thanks alot.

[joker122]

so Pat also says,
"You could probably use Excel to sum up the totals by day but I'm not all that familiar with Excel. There isn't anything in PT that shows totals by "day" just by session so you wouldn't be able to export from PT. If you have any SQL experience a database query could probably be written to do this as well."

Does anyone know where i can learn about SQL?

[_dave_]

[ QUOTE ]
Does anyone know where i can learn about SQL?

[/ QUOTE ]

Not a trivial thing to learn, but if you are keen, you won't go far wrong reading through this:

http://www.postgresql.org/docs/8.2/interactive/sql.html

What is it you want? just a net won/loss by date?

dave.

[joker122]

[ QUOTE ]
What is it you want? just a net won/loss by date?

[/ QUOTE ]

precisely.

[_dave_]

[ QUOTE ]
[ QUOTE ]
What is it you want? just a net won/loss by date?

[/ QUOTE ]

precisely.

[/ QUOTE ]

Shouldn't be too tricky, gimme a day or two, I'll have the SQL for ya [img]/images/graemlins/smile.gif[/img]

dave.

[joker122]

[ QUOTE ]
[ QUOTE ]
[ QUOTE ]
What is it you want? just a net won/loss by date?

[/ QUOTE ]

precisely.

[/ QUOTE ]

Shouldn't be too tricky, gimme a day or two, I'll have the SQL for ya [img]/images/graemlins/smile.gif[/img]

dave.

[/ QUOTE ]

awesome! thanks alot!

[Doink13]

Learning and using SQL to accomplish your need is akin to taking on Nuclear physics cause your a lil chilly [img]/images/graemlins/wink.gif[/img]

Export delimited anything and Excel can read it. Once in Excel, fool around with the pivot tables. This should take all of < 30 minutes.

[TheIrishThug]

Doink, I think you are overstating the complexity of SQL a little. The tutorial at w3schools can get you through most of the basic.

But yeah, with dave working on the task, you don't really need to worry.

[Doink13]

Maybe just a little.

Ofcourse it's the same question, do you want the data, or do you want to learn how to get the data.

Bottom line is he could have his data in <60 minutes with export and crosstabs.

However, if he wants to learn SQL, create SQL, run SQL, get data.... may take a little longer. [img]/images/graemlins/smile.gif[/img]

[_dave_]

[ QUOTE ]

But yeah, with dave working on the task, you don't really need to worry.

[/ QUOTE ]

Lol, unless I totally forget of course [img]/images/graemlins/blush.gif[/img]

Just been reminded via PM from the OP - sorry.

This seems to do the trick:

copy/paste into PGAdmin III's "Query Tool".

Obviously replace _dave_ with your screenname (the primary one, if you use aliases). And change the starting date as desired.

<font class="small">Code:</font><hr /><pre>

SELECT date_trunc('day', g.date_played) as Day, SUM( (gp.total_won - gp.total_bet) ) AS Winnings
FROM game g, game_players gp
WHERE gp.player_id = (SELECT player_id FROM players WHERE screen_name = '<font color="blue">_dave_</font>')
AND g.date_played &gt;= '<font color="blue">01-Feb-2007</font>'
AND gp.game_id = g.game_id
GROUP BY Day
ORDER BY Day ASC;

</pre><hr />

run it with the green "Play" button, check it looks OK, then do "File -&gt; Export" and save the results as a CSV file - you can then open this in Excel and do whatever [img]/images/graemlins/smile.gif[/img]

Enjoy,

dave.