Collusion detection ala NoahSD

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

Collusion detection ala NoahSD

Postby stigmata » Tue Apr 05, 2011 9:12 am

Essentially I would like to repeat a similar analysis to what NoahSD performed here:

http://forumserver.twoplustwo.com/19/hi ... dr-757267/

Towards this end, the most pertinent custom stat would be:
1) 3bet % of player A vs player B. This could then be filtered for A) other than the BB with no callers (i.e. not a squeeze) B) 4-6 players and C) stack size.

Other useful stats would include:
2) No of hands for a given player by stack size e.g. <25bb, >25bb
3) No of hands of player A vs player B

Any help or other ideas would be much appreciated.
stigmata
 
Posts: 1
Joined: Tue Apr 05, 2011 9:02 am

Re: Collusion detection ala NoahSD

Postby kraada » Tue Apr 05, 2011 9:17 am

I think something like this should be doable but it is not that easy to do because of all of the custom filtering you'll need. I'll make a note to take a look into it later and I'll get back to you if I succeed in putting a report together.
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 1 guest