Help! Cash Game Results By Time of Day

[TrustySam]

Hi, so there's no sort by time of day feature available for cash games, eh?

And there's simple command in the reports section either? Because there's no time variable, only date?

So I wanted to write my own custom program, but I didn't see the commands I was looking for in the guide on this page: http://www.pokertracker.com/guides/PT3/ ... de#filters

The logic of the program I figured would be something like this:

for (2nl zoom)
for (date) between (beginning date) and (end date)
let (count=beginning date)
then (yes) if (date=(beginning date with time>=5pm)and(beginning date with time<=6pm))
end if
let (count=beginning date+1)
end for


I think being able to sort info by time would be incredibly popular because everybody's always looking for better times to play. And in doing a quick search of the net it seems like people have been making requests for this type of feature for years now. But if it doesn't exist, can somebody help me perfect the syntax be for creating a custom report that would output this type of report? Thanks so much!

[WhiteRider]

A report like this will be added but I don't know exactly when yet.

[TrustySam]

You wanna work on the program together? Because otherwise what good is having custom programming capabilities if nobody's going to use it, eh?

I've taken beginner programming, I just don't know this particular language. So I don't know the syntax for how to set up a loop by day, or to tell the program how to cull data by looking at the time.

[WhiteRider]

Thanks for the offer but I don't think now is the time to take on new developers! :)

[TrustySam]

Thanks for the offer but I don't think now is the time to take on new developers! :)

??? :/ Were you trying to let me know that while you put the manual together, you don't actually have a programming background, so helping write a program isn't something you'd be able to help me with?

Okay, that's fine. The only thing is that the manual - https://www.pokertracker.com/forums/vie ... 45&t=22599 - doesn't convey the info that people would need to write custom macros.

PT included this capability to program custom reports, but the info on syntax hasn't been presented in a way that people who are interested in creating custom reports can use.

Like when you study introductory programming, usually they present the basic commands, and then provide sample programs that use each command. And then they give more complicated sample programs that use all the commands together. That way people can copy and paste the working programs and modify them to suit their needs.

Do you guys have some sample custom report programs that you've written in long-form that you could post as stubs for us to use as a starting point? If you have info like that, that might be a helpful starting point. I mean like I'd be fine with waiting for you guys to implement the feature yourselves, but honestly, if it's been on your list of things to do for 6 or more years now, I mean like ... realistically ... :/

[kraada]

There are a wide variety of reports available for free download here. In most cases for most users all you need to do are add stats to see the data that you want to see, there's no special programming required.

For doing more complicated things, the custom reports interface can accept SQL code directly via the filter expression area. Whatever SQL is supplied there is put in the WHERE clause of the query that is generated. This can often be used to restrict reports to specific kinds of data (e.g. hands where Hero 3bet preflop despite looking at things from villain's perspective) which cannot be done in other ways.

In order to create custom groups though you'd need to create a custom column which uses the GROUP BY option. If you used PostgreSQL's date functions to extract the hour of the hands and then group based on that information you can then display things as one row per whatever time period you prefer. For more on how to use PostgreSQL please see their documentation.

[WhiteRider]

Sorry - I misunderstood your question. Of course we'll be happy to help you put together a custom report if you tell us exactly what you'd like to see.

[TrustySam]

There are a wide variety of reports available for free download here. In most cases for most users all you need to do are add stats to see the data that you want to see, there's no special programming required.

For doing more complicated things, the custom reports interface can accept SQL code directly via the filter expression area. Whatever SQL is supplied there is put in the WHERE clause of the query that is generated. This can often be used to restrict reports to specific kinds of data (e.g. hands where Hero 3bet preflop despite looking at things from villain's perspective) which cannot be done in other ways.

In order to create custom groups though you'd need to create a custom column which uses the GROUP BY option. If you used PostgreSQL's date functions to extract the hour of the hands and then group based on that information you can then display things as one row per whatever time period you prefer. For more on how to use PostgreSQL please see their documentation.

Okay, thx kraada - will have to check out the resources and see what I can put together :)