rakeback for different rooms

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

rakeback for different rooms

Postby sym25 » Mon Oct 18, 2010 3:18 am

Hi.
I have stat 'rakeback'.
But i play in different room and have different % of rakeback. Can I make stat to calculate my rakeback, considered depending on the room.
For example, FTP 27%, ongame - 30%, and others...
thanks
sym25
 
Posts: 208
Joined: Wed Nov 26, 2008 3:38 am

Re: rakeback for different rooms

Postby kraada » Mon Oct 18, 2010 9:16 am

Yes, though each room calculates rakeback differently so you'd need to know how each room does it. For example an FTP rakeback stat is available in this thread, but not everyone uses weighted-contributed to calculate rakeback.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: rakeback for different rooms

Postby sym25 » Mon Oct 18, 2010 10:07 am

so i need to create more rakeback stats, but i need one, which see what site is and then calculate %...
something like:
if FTP then rakeback = 27% of rake
if ongame then rakeback = 30% of rake.

Please, can you make so template stat for me?
sym25
 
Posts: 208
Joined: Wed Nov 26, 2008 3:38 am

Re: rakeback for different rooms

Postby kraada » Mon Oct 18, 2010 12:20 pm

It's not that simple. At FTP now they give you 27% back of your weighted-contributed rake. See the linked thread for a stat for FTP. OnGame does not allow rakeback last I heard so I don't know what kind of calculations would be needed there. At Stars you'd need to figure out how to value VPPs, and so on.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: rakeback for different rooms

Postby sym25 » Tue Oct 19, 2010 4:01 am

Kraada, i know that it will not correct, but I only need to change my "amt_rb" column.
Now is it: (amt_rake * 27)
I want to add here operator if...
Like so
if FTPsitecode then amt_rake * 27
if ongamesitcode then amt_rake*30
and ...
I don't know this language, write for me, please and provide codes for different rooms.
I add other sites by myself latter.
sym25
 
Posts: 208
Joined: Wed Nov 26, 2008 3:38 am

Re: rakeback for different rooms

Postby kraada » Tue Oct 19, 2010 8:51 am

If they all calculated based off of amt_rake, that would be easy, but they do not.

FTP calculations is based on this expression: (holdem_hand_player_detail.amt_bet_ttl / holdem_hand_summary.amt_pot) * holdem_hand_summary.amt_rake, but only in pots where you put in some bet.

Each room calculates differently and I need to know how they calculate before I can figure out what is the correct formula to give you - I will not build a formula that will give you inaccurate results.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: rakeback for different rooms

Postby sym25 » Wed Oct 20, 2010 1:13 am

ok, post, please site codes...
sym25
 
Posts: 208
Joined: Wed Nov 26, 2008 3:38 am

Re: rakeback for different rooms

Postby sym25 » Wed Oct 20, 2010 2:50 am

sym25
 
Posts: 208
Joined: Wed Nov 26, 2008 3:38 am

Re: rakeback for different rooms

Postby kraada » Wed Oct 20, 2010 8:50 am

Please note that the calculations for FTP RB in that thread are no longer valid, though, as they changed their rakeback mechanism effective October 1st.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: rakeback for different rooms

Postby sym25 » Wed Oct 20, 2010 10:05 am

i know.
Please post updated table with site codes, including all supported sites now.
sym25
 
Posts: 208
Joined: Wed Nov 26, 2008 3:38 am

Next

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

Who is online

Users browsing this forum: No registered users and 0 guests