Import cash stat in Tournament statistics?

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

Import cash stat in Tournament statistics?

Postby jaxx » Sun Dec 07, 2008 9:27 am

Hello
How can I import cash stat from the repository (for instance donk bet flop) into the Tournament section statistics so I Can use it on my hud in tournaments?
jaxx
 
Posts: 87
Joined: Thu Oct 09, 2008 3:37 pm

Re: Import cash stat in Tournament statistics?

Postby kraada » Sun Dec 07, 2008 10:29 am

You can't import it directly, what you'll need to do is recreate it.

For donk flop, that would mean:
Click Configure --> Configure Stats.

Click on Holdem Tournament Player Statistics, and switch to the columns tab.

Add a new column call it cnt_f_donk, and give it the following definition:
sum(if[tourney_holdem_hand_player_statistics.flg_p_face_raise AND NOT(tourney_holdem_hand_player_statistics.flg_p_3bet OR tourney_holdem_hand_player_statistics.flg_p_4bet) AND tourney_holdem_hand_player_statistics.flg_f_bet AND (tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos < tourney_holdem_hand_player_statistics.position),1,0])
with description:
Number of times a player has donkbet the flop

(This is the same as the cash game one, just with each column changed to the tournament column.)

Add another new column, call it cnt_f_donk_opp and give it the following definition:
sum(if[tourney_holdem_hand_player_statistics.flg_p_face_raise AND NOT(tourney_holdem_hand_player_statistics.flg_p_3bet OR tourney_holdem_hand_player_statistics.flg_p_4bet) AND (tourney_holdem_hand_player_detail.flg_f_open_opp) AND (tourney_holdem_hand_player_detail.val_p_raise_aggressor_pos < tourney_holdem_hand_player_statistics.position) , 1 , 0])
with description:
Opportunties a player had to donkbet the flop.

Then switch to the Stats tab.

Create a new stat, call it Donk Flop with description "Percentage of the time that a player has donkbet the flop" and value expression:
100 * cnt_f_donk / cnt_f_donk_opp

Go to the format tab (on the stat) and give it title Donk Flop with width 55 and format expression /%.2f You can add categories of Actions, Aggression, Bet type - Bet and Street Flop on the Categories tab, then save, update your cache(s) and you should be all set.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Import cash stat in Tournament statistics?

Postby jaxx » Sun Dec 07, 2008 6:12 pm

I managed to add it like that
However on the HUD in the hint of the stat I see only a number (for instance 33).
on the other default stats I see also the number of hands taken into account - for instance 33(1/3)
how can I add this also on my stat?
jaxx
 
Posts: 87
Joined: Thu Oct 09, 2008 3:37 pm

Re: Import cash stat in Tournament statistics?

Postby kraada » Mon Dec 08, 2008 10:25 am

This post goes into some of the fancier formatting tricks you can use for displaying stats.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Import cash stat in Tournament statistics?

Postby WhiteRider » Tue Dec 09, 2008 1:34 pm

jaxx wrote:I managed to add it like that
However on the HUD in the hint of the stat I see only a number (for instance 33).
on the other default stats I see also the number of hands taken into account - for instance 33(1/3)
how can I add this also on my stat?

I never managed to work out exactly what causes this problem, but I think it's to do with the way the format expression and/or value expression are written in the Statistic. Something to do with where the spaces are around brackets, for instance.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Import cash stat in Tournament statistics?

Postby jaxx » Tue Dec 09, 2008 2:05 pm

WhiteRider wrote:
jaxx wrote:I managed to add it like that
However on the HUD in the hint of the stat I see only a number (for instance 33).
on the other default stats I see also the number of hands taken into account - for instance 33(1/3)
how can I add this also on my stat?

I never managed to work out exactly what causes this problem, but I think it's to do with the way the format expression and/or value expression are written in the Statistic. Something to do with where the spaces are around brackets, for instance.


so I must not do any special formatting to get this additional info? It must appear by itself?
jaxx
 
Posts: 87
Joined: Thu Oct 09, 2008 3:37 pm

Re: Import cash stat in Tournament statistics?

Postby WhiteRider » Thu Dec 11, 2008 11:09 am

No, the additional information "33 (1/3)" should appear automatically in the tooltip (hint), but as I said, it doesn't always seem to work correctly if you don't have the formatting your expressions 'just so'.
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 1 guest