Request to check stat.

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

Request to check stat.

Postby DrKK » Fri Oct 24, 2008 9:38 am

Hi there,

I gave a shot at the M zone stat for MTT's. I'm quit a newbe in making costum stats so any help is welcome.

http://www.megaupload.com/nl/?d=HJP0T688 You can download the stat here.(dont know how to upload to this site).


Description:

in Holden_tournament_player_statistic ; columns:

name: M
explression: tourney_holdem_hand_player_detail.amt_before/(tourney_holdem_hand_player_detail.amt_blind+tourney_holdem_hand_player_detail.amt_ante)

Description: Mzone

grouped by sum

========================

in Holden_tournament_player_statistic ; statistics: Definition:

name: Mzone
Description: Mzone
Expression: M

in Holden_tournament_player_statistic ; statistics: Format:

Title: Mzone, With:45, right

format expression: /%.2f

note: hud updates every hand.


Thank you very much in advance,


cheers Kees
DrKK
 
Posts: 121
Joined: Mon May 05, 2008 10:13 am

Re: Request to check stat.

Postby DrKK » Fri Oct 24, 2008 9:40 am

btw: is it possible to count the number of players currently at the table( in previous hand obv)???
DrKK
 
Posts: 121
Joined: Mon May 05, 2008 10:13 am

Re: Request to check stat.

Postby WhiteRider » Fri Oct 24, 2008 10:20 am

This stat will not be any use in the HUD because it will sum up the M value for every hand you have ever played. It won't just related to the last hand.

You could build this stat in the holdem_tournament_hand section for use when analysing hands (e.g. once HUD stats are available in the Replayer).

A few notes on your Column.
1. tourney_holdem_hand_player_detail.amt_blind is the amount you paid in blinds in this hand; what you want is:
tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb

2. You can get the number of players in the hand, and multiply this by the ante:
tourney_holdem_hand_summary.cnt_players
(your DB field for the ante will be fine, since you pay the ante every hand)
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Request to check stat.

Postby DrKK » Fri Oct 24, 2008 3:59 pm

ok tx a lot, I had to try, I will continue with your suggestions for the replayer.
DrKK
 
Posts: 121
Joined: Mon May 05, 2008 10:13 am


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

Who is online

Users browsing this forum: No registered users and 0 guests