Bet365 Points

[Foxy79]

Hallo,

I want to make a custom Stat for calculate Bet365 Points.
Under 'Holdem Cash Hand' -> Colums, I have made a Column named 'amt_bet365points' and with Expression:

Code: Select all

if[holdem_hand_summary.amt_rake >= 0.04 AND holdem_hand_summary.amt_rake <= 0.09,  0.2,if[holdem_hand_summary.amt_rake >= 0.10 AND  holdem_hand_summary.amt_rake <= 0.24,  0.4,if[holdem_hand_summary.amt_rake >= 0.25 AND  holdem_hand_summary.amt_rake <= 0.50,  1,if[holdem_hand_summary.amt_rake >= 0.51 AND  holdem_hand_summary.amt_rake <= 0.75,  1.5,if[holdem_hand_summary.amt_rake >= 0.76 AND  holdem_hand_summary.amt_rake <= 1,  2,if[holdem_hand_summary.amt_rake >= 1.01 AND  holdem_hand_summary.amt_rake <= 1.25,  3,if[holdem_hand_summary.amt_rake >= 1.26 AND  holdem_hand_summary.amt_rake <= 1.50,  3.5,if[holdem_hand_summary.amt_rake >= 1.51 AND  holdem_hand_summary.amt_rake <= 1.75,  4.25,if[holdem_hand_summary.amt_rake >= 1.76 AND  holdem_hand_summary.amt_rake <= 2,  4.75,if[holdem_hand_summary.amt_rake >= 2.01 AND  holdem_hand_summary.amt_rake <= 2.25,  6,if[holdem_hand_summary.amt_rake >= 2.26 AND  holdem_hand_summary.amt_rake <= 2.50,  7.5,if[holdem_hand_summary.amt_rake >= 2.51 AND  holdem_hand_summary.amt_rake <= 2.75,  9,if[holdem_hand_summary.amt_rake >= 2.76 AND  holdem_hand_summary.amt_rake <= 3,  10,if[holdem_hand_summary.amt_rake >= 3.01 AND  holdem_hand_summary.amt_rake <= 5,  11, 0]]]]]]]]]]]]]]

and it worked great for each single hand.

But how can i summary the points from each Day together?
Can anyone help me please?

[kraada]

You'd need to do that in the Holdem Cash Player Statistics section, though you've already done almost all of the work that you'd need to do.

You'll need to create a new column there, but your definition is nearly there, just change it to:

sum(if[holdem_hand_summary.amt_rake >= 0.04 AND holdem_hand_summary.amt_rake <= 0.09, 0.2,if[holdem_hand_summary.amt_rake >= 0.10 AND holdem_hand_summary.amt_rake <= 0.24, 0.4,if[holdem_hand_summary.amt_rake >= 0.25 AND holdem_hand_summary.amt_rake <= 0.50, 1,if[holdem_hand_summary.amt_rake >= 0.51 AND holdem_hand_summary.amt_rake <= 0.75, 1.5,if[holdem_hand_summary.amt_rake >= 0.76 AND holdem_hand_summary.amt_rake <= 1, 2,if[holdem_hand_summary.amt_rake >= 1.01 AND holdem_hand_summary.amt_rake <= 1.25, 3,if[holdem_hand_summary.amt_rake >= 1.26 AND holdem_hand_summary.amt_rake <= 1.50, 3.5,if[holdem_hand_summary.amt_rake >= 1.51 AND holdem_hand_summary.amt_rake <= 1.75, 4.25,if[holdem_hand_summary.amt_rake >= 1.76 AND holdem_hand_summary.amt_rake <= 2, 4.75,if[holdem_hand_summary.amt_rake >= 2.01 AND holdem_hand_summary.amt_rake <= 2.25, 6,if[holdem_hand_summary.amt_rake >= 2.26 AND holdem_hand_summary.amt_rake <= 2.50, 7.5,if[holdem_hand_summary.amt_rake >= 2.51 AND holdem_hand_summary.amt_rake <= 2.75, 9,if[holdem_hand_summary.amt_rake >= 2.76 AND holdem_hand_summary.amt_rake <= 3, 10,if[holdem_hand_summary.amt_rake >= 3.01 AND holdem_hand_summary.amt_rake <= 5, 11, 0]]]]]]]]]]]]]])

Then it will add up all of your points. Create a new stat that displays your new column and you'll be able to show it in any report that uses the HCPS section.

[Foxy79]

thanks a lot, but can u tell me how i can group it by a day?

[kraada]

Add it to a report that has day by day lines; the Winnings For Month report (middle one on the Winnings tab) should work well.

[Foxy79]

The Bet365 Points-Stat is not under the available Stats in that report, that is my problem.

[kraada]

You raise a good point; unzip and import the attached MonthDayYear stat and use it in any report with your stat and it will break things into a day by day list.