Heater/Cooler report

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

Heater/Cooler report

Postby anyhero » Sun May 17, 2009 12:12 am

Is the postresql database set up so a "heater/cooler" report could be queried? Basically, I'm looking for a report that would return $ or BB lost/won in situations like:
AA vs KK aipf
KK vs QQ aipf
QQ vs AA aipf
AK vs AA aipf
AK vs KK aipt
Set over set
top two vs set

A report like this combined with the EV stuff would do a lot to try to flatten variance when analyzing a small sample of hands. I have no postgresql experience, but I might give this report a shot if it can be done. If someone who knew what they were doing wrote it, that would be even better.

Thanks
anyhero
 
Posts: 19
Joined: Wed Mar 05, 2008 11:18 pm

Re: Heater/Cooler report

Postby kraada » Sun May 17, 2009 9:43 am

This could be done with directly PostgreSQL queries, but this sort of thing can't be done at the moment in PT3. The joins required in order to get data about your hand and your opponent's hand is tricky. We do hope this sort of thing could be done eventually in PT3 but it will be a while before that happens.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 0 guests