Creating Column of Total Winnings (Winnings+Rakeback)
Results 1 to 9 of 9
  1. #1
    Junior Member
    Join Date
    Jan 2009
    Posts
    5

    Default Creating Column of Total Winnings (Winnings+Rakeback)

    I've attempted to do this and failed. Just want a column/stat that adds two other columns together in the reports section.. any suggestions?

  2. #2
    Member
    Join Date
    Jan 2009
    Posts
    45

    Default

    <Stat GroupName="Default" ColumnName="TotalWin" ValueExpressions="Sum(PH.RakeAmount)/100.0*0.27 as RakeBackAmount;Sum(PH.NetAmountWon)/100 as NetWin" Evaluate="(RakeBackAmount+NetWin)" ColumnHeader="TotalWin" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="TotalWin" />


    You may need to adjust the 0.27 to be your rakeback percent if it isn't 27%.

  3. #3
    Junior Member
    Join Date
    Jan 2009
    Posts
    5

    Default

    awesome.
    Last edited by mgirdley; 03-28-2009 at 01:33 AM.

  4. #4
    Junior Member
    Join Date
    Jul 2010
    Posts
    2

    Default

    Work just with $ rake, but what to change to make correct value with pound and euro? What I should to write instead of PH.RakeAmount ?

  5. #5
    Junior Member
    Join Date
    Jul 2010
    Posts
    2

    Default

    I see 4 different stats : rake; rake in usd; rake in euro; rake in gbp. The script above took stats from rake, how to change it to rake in usd?

  6. #6
    Member
    Join Date
    Jul 2010
    Posts
    48

    Default

    can some some me how to change the rakeback to rakeshare (MGR) as to total rake paid.It's more accurate for keeping track like in pokertracker

  7. #7
    Member
    Join Date
    Jul 2010
    Posts
    48

    Default

    formula: (sum( holdem_table_session_summary.amt_mgr ))*.75
    this is from pt3.
    would something like this work. i want to calculate my rakeback using MGR instead of rake paid.Any help appreciated.

  8. #8
    Junior Member
    Join Date
    Feb 2010
    Posts
    6

    Default

    So I tried this and got an interesting result. I have a 30% rakeback, so .27 to .30 but it is exactly the same otherwise.

    Here are the results from a report after adding it:

    Game Type Description Game Size Hands Winnings Rake TotalWin
    $0.25/0.5 NL holdem 6 max 55 $105.31 $4.66 $106.40

    Unfortunately, if I have a rake of $4.66 then my Rakeback should be $1.398 which when added to $105.31 should be $106.71 and not $106.40 which is more like 23%.

  9. #9
    Junior Member
    Join Date
    Feb 2010
    Posts
    6

    Default

    Okay, so I figured this out. In the example given, "Sum(PH.NetAmountWon)/100" will round to the nearest whole dollar which will throw rakeback off on relatively small numbers like this.

    Change it to: "Sum(PH.NetAmountWon)/100.0" and all is well!

Similar Threads

  1. rake,winnings
    By pepp1 in forum Manager General
    Replies: 13
    Last Post: 08-09-2010, 01:54 PM
  2. Submitting rakeback winnings
    By zaigezunt in forum Manager General
    Replies: 10
    Last Post: 05-16-2010, 09:01 AM
  3. Adjusted Winnings Bug
    By K40N in forum Manager General
    Replies: 2
    Last Post: 03-15-2009, 04:00 PM
  4. Replies: 7
    Last Post: 01-29-2009, 11:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •