Contributed Rake

[WhiteRider]

Have a look at this thread - I've linked the specific post with the column that works, but you'll probably want to read the whole thread, it's only just over 1 page.

[Tenitsi]

Why can't u just upload this "Boss media Contributed rake" stat to the repository???
I struggled with this over an hour and still did not get this to work.
You shouldn't have to have unhuman computer skills to use this sw. *SIGH*

[WhiteRider]

I haven't actually built the stat myself - you could send the person who was building it a PM and ask him to upload it.
Alternatively tell me where you're stuck and I'll help you out - once you get your head round building custom stats it will really open up the possibilities of PT3.

[Tenitsi]

I haven't actually built the stat myself - you could send the person who was building it a PM and ask him to upload it.
Alternatively tell me where you're stuck and I'll help you out - once you get your head round building custom stats it will really open up the possibilities of PT3.

I want the Boss RB stat shown on the General tab so i guess the right place is "Holdem Cash Sessions - Summary of Sessions" on the statistics menu - right?

There, at Columns tab i created a column "Boss_rake" with this Expression: sum(holdem_hand_summary.amt_rake * holdem_hand_player_detail.amt_bet_ttl / holdem_hand_summary.amt_pot)
After that on Statistics tab i created a statistic called Boss RB which has this Value Expression: Boss_rake

I know this stat will show only generated RAKE ...not my rakeback, but i thought i will get this stat working first before putting the 0.3 multiplier (for 30% rb etc) on the stat.

Now...this doesn't work.

Here is what is shown before i add the Boss RB column on the Player Summary window at General tab:

http://img193.imageshack.us/img193/958/pt31.jpg

And here is after i add the Boss RB column: Wtf is going on there?

http://img67.imageshack.us/img67/9507/pt32.jpg



So what next?

[WhiteRider]

The Player Summary report is built as a summary of session results, not as a summary of hand results, so you would need to use "holdem_table_session_summary.amt_rake" (which is the total rake paid in each session) if you want to build it in this section, but that won't allow you to do the "holdem_hand_player_detail.amt_bet_ttl / holdem_hand_summary.amt_pot" part because that is based on each hand.

If you use your same column definition but create the column in the Holdem Cash Player Statistics section the stat should work.
You'll have to add it to the Player Statistics report instead, though.

[Tenitsi]

Yes i got it to work when i put the column & stats on "Holdem Cash Player Statistics".

Another question about the stats. I play on Boss Media so there is TRY,USD,GBP and EUR -games.
Now all the rake/rakeback-stats are in USD. My main account is in EUR so i need the RB-stats to show in EUR.

Is it possible to make stats Limit -dependant?

I mean i could fetch the correct multipliers for the currency conversion and insert them on the RB-stat. But this has no use if every limit has the same multiplier.

For example TRY -> EUR : multiplier 0.477
USD -> EUR : multiplier 0.702

Then i would have the rake/rakeback -stats shown in EUR (i don't care if the currency multipliers change a bit.)

[WhiteRider]

You could use a check like this:
holdem_limit.limit_name LIKE '€%'

You could either build a separate stat for each currency or combine them in one stat using multiple IF statements.
This kind of thing:

sum( if[ holdem_limit.limit_name LIKE '€%', euro-multiplier * holdem_hand_summary.amt_rake * holdem_hand_player_detail.amt_bet_ttl / holdem_hand_summary.amt_pot, if[holdem_limit.limit_name LIKE '£%', pound-multiplier * holdem_hand_summary.amt_rake * holdem_hand_player_detail.amt_bet_ttl / holdem_hand_summary.amt_pot, holdem_hand_summary.amt_rake * holdem_hand_player_detail.amt_bet_ttl / holdem_hand_summary.amt_pot]] )

[Tenitsi]

I entered that column and created a statistic to fetch the info.
PT3 said it would need the cache updated and so i started to update the cache. After a minute or so Postgres.exe crashed and the process never stopped. I forced (ctrl+alt+del) PT3 off and now it doesn't start at all.

EDIT: I forced every postgres.exe -process also to shut down (there was like over 10) and now it did start...i am trying the cache update again...

[Tenitsi]

sum( if[ holdem_limit.limit_name LIKE '€%', euro-multiplier * holdem_hand_summary.amt_rake * holdem_hand_player_detail.amt_bet_ttl / holdem_hand_summary.amt_pot, if[holdem_limit.limit_name LIKE '£%', pound-multiplier * holdem_hand_summary.amt_rake * holdem_hand_player_detail.amt_bet_ttl / holdem_hand_summary.amt_pot, holdem_hand_summary.amt_rake * holdem_hand_player_detail.amt_bet_ttl / holdem_hand_summary.amt_pot]] )

Could you PLEASE add TRY (named YTL in PT3 limits) and USD (named $ in PT3 limits (duh)) limits to this code? I have practically NO coding history so that code makes almost no sense to me.

[WhiteRider]

This expression:

sum( if[ holdem_limit.limit_name LIKE '€%', 1 * holdem_hand_summary.amt_rake * holdem_hand_player_detail.amt_bet_ttl / holdem_hand_summary.amt_pot, if[holdem_limit.limit_name LIKE '£%', 2 * holdem_hand_summary.amt_rake * holdem_hand_player_detail.amt_bet_ttl / holdem_hand_summary.amt_pot, if[holdem_limit.limit_name LIKE '$%', 3 * holdem_hand_summary.amt_rake * holdem_hand_player_detail.amt_bet_ttl / holdem_hand_summary.amt_pot, 4 * holdem_hand_summary.amt_rake * holdem_hand_player_detail.amt_bet_ttl / holdem_hand_summary.amt_pot]]] )

..checks for currencies in order: EUR (1), GBP (2), USD (3) - any other currency will use the final expression (4).
Replace the numbers with the appropriate multiplier for the currency conversions.

You may find it easier to swap the check of "$" for TRY but I don't have any examples to hand to see exactly what the limits are called, then you could use the final 'else' part of the expression for $ which wouldn't need a multiplier.

This is basically saying:

if a hand is EUR then use the "1 * ..." calculation, else if it is GBP use the "2 * ..." calculation, else if it is USD use the "3 * ...." calculation, else use the "4 * ..." calculation.