any card on any street

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

any card on any street

Postby tizlinda » Tue Jul 01, 2008 9:37 am

is there currently a way to see how many times an ace has fallen on the river to the winner of the hand? Or any particular card on any street for that matter. It would be interesting to see the percentages of each street, not helpful perhaps, but will statisfy one of my curiosities at Pokerstars.
tizlinda
 
Posts: 37
Joined: Mon Jun 16, 2008 10:06 pm

Re: any card on any street

Postby kraada » Tue Jul 01, 2008 2:58 pm

Yes, you would want to do this with a custom report and you would want to filter on id_river ; see the custom reports guide for general basics.

Specifically you want id_river % 13 = 0 .

This returns 0, 13, 26, and 39, the id numbers for the 4 different aces. (I think they're clubs, diamonds, hearts, and spades in that order, but I'm not 100% on that).
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 4 guests