rakeback stat

General discussion of PokerTracker 3.

Moderator: Moderators

rakeback stat

Postby tsuneoka » Tue May 12, 2009 4:24 pm

i use the rake back stat but i would like to know how to use a different rakeback percent for each poker site.
thanks
tsuneoka
 
Posts: 64
Joined: Mon Aug 25, 2008 11:31 am

Re: rakeback stat

Postby WhiteRider » Wed May 13, 2009 4:13 am

You could do it all in one stat by checking the site ID using the database table lookup_sites; which has fields id_site, site_abbrev, site_name.

e.g.
lookup_sites.site_abbrev LIKE 'PS'
lookup_sites.id_site = 100

The sites' codes and abbreviations are:
site codes.png
(3.71 KiB) Downloaded 2378 times


You will need to add an if statement for each site you play at.
e.g. if [ lookup_sites.site_abbrev LIKE 'PS', (Stars rakeback formula), if [ lookup_sites.site_abbrev LIKE 'PTY', (Party rakeback formula), ... ] ]

Custom Statistics and Reports FAQ.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: rakeback stat

Postby tsuneoka » Mon May 18, 2009 10:33 am

sorry i need help
in amt_rb stat
amt_mgr * 0.27
i changed it to :

if [lookup_sites.id_site = '300', (amt_mgr * 0.27)], if [ lookup_sites.id_site = 'X', (amt_mgr *Y )]
where X=2nd site et Y rakeback %

PT3 tolds me unvalid SQL where is the problem

thanks
tsuneoka
 
Posts: 64
Joined: Mon Aug 25, 2008 11:31 am

Re: rakeback stat

Postby kraada » Mon May 18, 2009 12:47 pm

tsuneoka wrote:sorry i need help
in amt_rb stat
amt_mgr * 0.27
i changed it to :

if [lookup_sites.id_site = '300', (amt_mgr * 0.27)], if [ lookup_sites.id_site = 'X', (amt_mgr *Y )]
where X=2nd site et Y rakeback %

PT3 tolds me unvalid SQL where is the problem

thanks


Where are you putting this if statement: in the column or in the format tab of the stat? Its format slightly different depending on where you use it.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: rakeback stat

Postby tsuneoka » Mon May 18, 2009 4:05 pm

in cash sessions ; columns
tsuneoka
 
Posts: 64
Joined: Mon Aug 25, 2008 11:31 am

Re: rakeback stat

Postby kraada » Mon May 18, 2009 5:06 pm

Then what you want is:

if [lookup_sites.id_site = '300', (amt_mgr * 0.27), if [ lookup_sites.id_site = 'X', (amt_mgr *Y ), 0]]
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: rakeback stat

Postby tsuneoka » Tue May 19, 2009 11:55 am

sorry but it says no valid sql again ?§?
tsuneoka
 
Posts: 64
Joined: Mon Aug 25, 2008 11:31 am

Re: rakeback stat

Postby kraada » Tue May 19, 2009 12:14 pm

Apparently the issue is the multiplication in the 'then' part of the if statement, so you're going to need to break this up into multiple columns. (My apologies, I should've cought that the first time around.)

Call the first one ftp_mgr, with definition:
sum( if[lookup_sites.id_site = '300', holdem_table_session_summary.amt_mgr, 0])
The second one is site_X_mgr, with definition:
sum( if[lookup_sites.id_site = 'X', holdem_table_session_summary.amt_mgr, 0])

Then create a rakeback column, with definition:
ftp_mgr * 0.27 + site_X_mgr * Y
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: rakeback stat

Postby tsuneoka » Wed May 20, 2009 5:23 am

your last stuff i put it in holdem cash sessions ; statistics ?

when i add this stat that i called rakeback in my winnings the stat doesnt appear but all others (amount won , sessions ...) are *10
if i won 1000$ the amount won is 10 000$
crazy stuff!! what to do ?
is it because i put this 3 stuffs in holdem cash sessionS

and thanks for your time
tsuneoka
 
Posts: 64
Joined: Mon Aug 25, 2008 11:31 am

Re: rakeback stat

Postby WhiteRider » Wed May 20, 2009 8:39 am

You can do this with a single column as suggested before, but it needs a couple of changes.

This column works:
amt_rakeback =
sum( if[ holdem_table_session_summary.id_site = 300, holdem_table_session_summary.amt_mgr * 0.27, if[ holdem_table_session_summary.id_site = 400, holdem_table_session_summary.amt_mgr * 0.30, 0 ] ] )

Change your site IDs and MGR multipliers as you need, and add more IFs for more sites if you want too.

Then you just need a simple statistic to display the amt_rakeback column.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Next

Return to General [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests