average stake in currency

[philip77]

Hi,

I am using a custom stat called Total BB (amt_total_bb_amounts / cnt_hands) which permits me to know the average stake I am playing. But now I am also playing game at various currency, how can I modify that stat to reflect that. For example if I play 1000 hands at 1$ NL and 1000 hands at 1€, I will like to see my average BB around 1.16 (my standard currency is $).

Thanks

[WhiteRider]

You will need a new custom column for that - you'll need to multiply the BB amount by the currency conversion amount for each hand.
Check out the amt_bb and amt_won_curr_conv columns for the database fields and expressions you need.

[philip77]

Can you please be a bit more specific, I did not get it.
Thanks.

[WhiteRider]

I assume you want to use the size of the BB in every hand, not just when you personally pay the BB, so you'll want:

sum( cash_limit.amt_bb * cash_hand_player_statistics.val_curr_conv )

That will add up the BB amount in each hand multiplied by the currency conversion rate for that hand.

[philip77]

I'm sorry to insist with this one, but I cannot get it correctly.
I create a column amt_total_bb_amounts_cur with the formula you gave me, then I create my statistic which is simply amt_total_bb_amounts_cur / cnt_hands
but the result is a very large figure, and I cannot point what is wrong. The formula make sense to me, but I cannot get it right.
Thanks

[WhiteRider]

Do you want to calculate the BB amount in every hand, or the BBs that you personally paid?

[philip77]

I want to know the average stake I am playing at, converted to my currency.
Actually I use the custom stats Total BB=amt_total_bb_amounts / cnt_hands
with amt_total_bb_amounts = sum( cash_limit.amt_bb )

But the problem is that is does not compute the currency conversion. Basically I wanted to convert the total BB that were paid by everybody to my currency, sum them, divide by the number of hands I played.

To put an example: I played 100 hands at 1$, the 200 hands at 2€ (with a conversion rate of 1.31), and I want to have average BB=2.08
(100 * 1 + 200 * 2 * 1.31) / 300

Thanks

[kraada]

Ok then what you actually want is:

sum(if[cash_hand_player_statistics.id_hand > 0, cash_limit.amt_bb * cash_hand_player_statistics.val_curr_conv, 0])

That will add up the big blind amount once per hand in your database and convert it to your preferred currency.

Note: If you play any fixed limit, it will actually add up the big bet amount for those hands.

[philip77]

Thank you for your patience.
It works fine.

Regards