Filter to see how winrate as sessions get longer!!!!!!

[aestheticsbro]

Hi,

I think a really useful feature would be to be able to filter or see your winrate as your sessions get longer. To see if you play worse when you play longer sessions, and if so, where is the point that it gets really bad!

So, the filter would show:

30 minutes: 8bb/100
1 hour: 8bb/100
2 hours: 6bb/100
3 hours: 5bb/100
4 hours: 1bb/100
5 hours: -3bb/100
6 hours: -8bb/100

or something like this? Is there a way to run this filter, it would be extremely useful and interesting to me!

Similar to how it shows stats by days of the week, or hours of the day, except it is 'time into session'.

I also would really like it if you implemented a stop loss feature, just something that alerted you when you have lost 'x' amount of buyins. I don't like constantly looking at HEM while I am playing, but I also would like to use a stoploss, many people I have spoken to would appreciate just a small stoploss function that pops up with a message alerting you that you have reached your stoploss!

Thanks!

[2blave]

This SQL query I wrote for myself might help you. It's kind of slow and a bit hackish. I'm sorry it's so ugly - I am not very good at SQL. This is filtered by number of hands per day rather than length of session, but should give you a similar picture. It doesn't break it down the way you suggest, but I already had it and thought I'd share.

You may have to change your player_id, and you can also change any other data in there to fit the parameters you want, like number of days in the past and how many hands to define a long session.

select * from
(select date_trunc('day', handtimestamp) as "Date", sum(netamountwon)/100.0 as "Winnings", sum(1) as "Hands"
from playerhandscashkeycolumns

where player_id=1 and handtimestamp>(current_date - interval '50 days')

group by "Date" order by "Date") as dailyresults

where dailyresults."Hands">1000;