stats for contributed 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

stats for contributed rakeback

Postby iven » Wed Sep 07, 2011 7:06 pm

hi,

i didnt find anything about this .. all i found was about weighted contributed rakeback.

to make it very clear: EVERY player that put money in the pot gets the same amount of rake back (here 30%)


here is my formula so far:

sum( if[holdem_hand_player_detail.amt_bet_ttl > 0 AND holdem_hand_summary.amt_rake>.001,
holdem_hand_summary.amt_rake * 0.30 / "number of players that contributed money to the pot",
0])


so, how do i get that "number of players that contributed money to the pot" ?


thank you
iven
 
Posts: 6
Joined: Thu Jul 17, 2008 10:02 pm

Re: stats for contributed rakeback

Postby kraada » Wed Sep 07, 2011 7:31 pm

That's not possible at this point in time - at best you can get the number of players who saw the flop. I'd been assured recently that no sites still used average contributed rake for rakeback purposes - which site is this at?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: stats for contributed rakeback

Postby iven » Wed Sep 07, 2011 7:34 pm

thanks for the answer, at least it saved me alot of time figuring this out ; )

the site is Terminal Poker; i use a selfwritten script to convert the handhistory to pokerstars hh
iven
 
Posts: 6
Joined: Thu Jul 17, 2008 10:02 pm


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

Who is online

Users browsing this forum: No registered users and 0 guests