Report on daily % profit?

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Report on daily % profit?

Postby Chip Chayser » Thu Aug 20, 2009 8:16 am

Hi

Just new to PT.

Can anyone help with creating a report to show daily increase/decrease in profit as a % of previous days balance?

Thanks heaps
Chip Chayser
 
Posts: 3
Joined: Thu Aug 20, 2009 8:06 am

Re: Report on daily % profit?

Postby WhiteRider » Thu Aug 20, 2009 9:26 am

I don't think that sort of report is possible within PT3 - you can split a report up to show each days' results on its own line, but that would just sum the results of all the sessions for a given day - it wouldn't have any concept of the previous row/day in the report.
Also I'm not really sure how much use that report would be - poker results can be so inconsistant based on how you run that you won't really ever have a consistant increase in your winnings day to day over a long period of time (hopefully your winnings will increase over time, but it's unlikely to be a smooth rise if you plot every day's results).
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Report on daily % profit?

Postby Chip Chayser » Thu Aug 20, 2009 8:33 pm

I would have thought that as abalance of net profit is shown, it could be done dividing the current dates profit into total net profit at the begining of the day?

I understand there will be big swings though.
Chip Chayser
 
Posts: 3
Joined: Thu Aug 20, 2009 8:06 am

Re: Report on daily % profit?

Postby WhiteRider » Fri Aug 21, 2009 4:27 am

Yes, but the problem is getting those values separately - the current date's profit will be shown as part of the report, but you would have to generate the profit to the start of the day as a separate value in order to use it in a report on the "next" row and that can't be done using the nornal custom report framework.
Kraada has done some investigation into retrieving timed/dated information so he may have another idea - he'll be on later.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests