Playing the Top 5 Hands

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

Playing the Top 5 Hands

Postby Th0rgal » Tue Nov 25, 2008 6:16 am

Hi All,

Not sure if it is possible but I was wondering if it was possible to report how a player plays certain hands.

For example:
AA

Position: UTG
Last hand Action: Limp
Average: 2.5BB bet

Position: Middle
Last hand Action Call 2BB
Average 3BB Bet

AKs/KK/QQ, etc
Something like this

Anyone knows how to do that?
This would give a good view of people's opening moves or how they play certain hands making it a much more easy to decide to get involved.

Thank you for the help
Th0rgal
 
Posts: 90
Joined: Sat Apr 19, 2008 7:45 am

Re: Playing the Top 5 Hands

Postby WhiteRider » Tue Nov 25, 2008 11:17 am

You can certainly build stats to count these kind of things, although to do it in a simple way would mean building several similar stats for each situation.
e.g. It would be easy to build a stat to count how often a player limps when then had AA; or to calculate their average raise size when they had AA.

If you want to add it to the HUD then you will need to build a stat for each specific case.

To add this kind of stat to a report is a bit easier, though.
You could build a stat to analyse first preflop action (count limps or raises for instance) and then add it to the Known Starting Hands Summary report which would split it into holecard categories.
This is quite a nice idea, now that I think about it.

Have a play around with it and see what you can come up with.
If you get stuck, or want to throw some ideas around, please post back.

Read the Custom Statistics and Reports FAQ to get you going, and you may find these kind of database fields useful..

holdem_hand_player_detail.amt_bet_p
lookup_actions_p.action (see the FAQ for how to use this to get the first preflop action)
holdem_hand_player_detail.amt_p_raise_made
holdem_hand_player_statistics.flg_p_open_opp
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 5 guests