Two Plus Two Newer Archives  

Go Back   Two Plus Two Newer Archives > Internet Gambling > Software
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 02-26-2007, 04:00 PM
joker122 joker122 is offline
Senior Member
 
Join Date: Dec 2003
Location: raising for information again
Posts: 5,504
Default PokerTracker/Excel help needed

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.
Reply With Quote
  #2  
Old 02-26-2007, 09:36 PM
joker122 joker122 is offline
Senior Member
 
Join Date: Dec 2003
Location: raising for information again
Posts: 5,504
Default update

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?
Reply With Quote
  #3  
Old 02-26-2007, 11:16 PM
_dave_ _dave_ is offline
Senior Member
 
Join Date: Feb 2005
Location: UK
Posts: 2,628
Default Re: update

[ 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.
Reply With Quote
  #4  
Old 02-26-2007, 11:39 PM
joker122 joker122 is offline
Senior Member
 
Join Date: Dec 2003
Location: raising for information again
Posts: 5,504
Default Re: update

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

[/ QUOTE ]

precisely.
Reply With Quote
  #5  
Old 02-26-2007, 11:44 PM
_dave_ _dave_ is offline
Senior Member
 
Join Date: Feb 2005
Location: UK
Posts: 2,628
Default Re: update

[ 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.
Reply With Quote
  #6  
Old 02-27-2007, 01:52 AM
joker122 joker122 is offline
Senior Member
 
Join Date: Dec 2003
Location: raising for information again
Posts: 5,504
Default Re: update

[ 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!
Reply With Quote
  #7  
Old 03-05-2007, 10:14 PM
Klaudioz Klaudioz is offline
Member
 
Join Date: Sep 2006
Posts: 37
Default Re: PokerTracker/Excel help needed

http://pokertracker.com/forum/viewtopic.php?t=5503
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 09:30 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.