Import stat rakeback

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 stat rakeback

Postby Rain66ow » Tue Mar 27, 2012 10:47 am

Hello,

First, sorry for my bad english.
Here is the problem : I dowloaded 3 stats (rakeback, Total Won (Including Rakeback) and True Hourly including rakeback at http://www.pokertracker.com/custom) and I tried to import them.

The stats appears in the list (screenshot : http://nsa22.casimages.com/img/2012/03/ ... 401617.png) but I can't show them when I click on the little wrench.

I believe that it is possible to add a curve with these statistics, but one problem at the time :D

Thanks !
Rain66ow
 
Posts: 48
Joined: Thu Dec 29, 2011 11:13 am

Re: Import stat rakeback

Postby kraada » Tue Mar 27, 2012 11:28 am

It depends what kind of report you are trying to display them in - those stats will only work in Sessions reports - ie reports that show data grouped by entire sessions. You can't use it in any report that shows something like VPIP (for example), but you can use it on the top report on the General tab.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Import stat rakeback

Postby Rain66ow » Tue Mar 27, 2012 12:52 pm

Ok thanks.
I can now use it on the general tab :)

Is it possible to create 2 new curve on the graph tab ? Rakeback + Total won ?
Rain66ow
 
Posts: 48
Joined: Thu Dec 29, 2011 11:13 am

Re: Import stat rakeback

Postby kraada » Tue Mar 27, 2012 3:41 pm

Not using that stat - you'd need to create the stat in the Holdem Cash Player Statistics section in order for it to work there. Is your rakeback based on the weighted contributed method? If so I can link you to a stat you can download to use in the HCPS section.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Import stat rakeback

Postby Rain66ow » Tue Mar 27, 2012 4:00 pm

Thanks for answer.

Actually, my rakeback is 40% to MGR.I suppose that it is not too difficult to create a stat like that ? And another one amount_won + rakeback. I make a mistake?
Rain66ow
 
Posts: 48
Joined: Thu Dec 29, 2011 11:13 am

Re: Import stat rakeback

Postby kraada » Tue Mar 27, 2012 6:07 pm

Nope, you can use MGR - there's a built in column amt_mgr that you can use to start with.

All you'll need to do is create a stat that uses amt_mgr in the value expression - so 40% of MGR would be amt_mgr * .4

Total won + 40% of MGR would be amt_won + (amt_mgr * .4). Then you can fill in the name and description and title and width (on the format tab) however you like - so long as the stat is in the Player Statistics section it will be available for use on the graph.
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