Page 1 of 1

Total Amount Wagered

PostPosted: Fri Dec 18, 2009 3:55 am
by Tract0rDan
Hi,
I'd like to be able to see the total amount I've wagered... ever.

This would I guess include all bets, raises and calls - basically the total sum of $ I've ever put in any pot.

Is this possible?

Re: Total Amount Wagered

PostPosted: Fri Dec 18, 2009 5:25 am
by WhiteRider
Yes, you will need to build a custom stat in the Holdem Cash Player Statistics section using a column like this:

amt_bet_ttl =
sum( holdem_hand_player_detail.amt_bet_ttl )

Tutorial - Custom Reports and Statistics

Re: Total Amount Wagered

PostPosted: Wed Jul 16, 2014 7:33 pm
by joeppiej
Hello,

Could you give me an update please if it's also/still possible in PT4?

Thank you

Re: Total Amount Wagered

PostPosted: Thu Jul 17, 2014 3:24 am
by WhiteRider
Yes, this is possible in PT4, but the database table name changed:

amt_bet_ttl =
sum( cash_hand_player_statistics.amt_bet_ttl )

Custom Stats Guide

The guide linked above is still relevant too, although the interface and some database table names changed.

Re: Total Amount Wagered

PostPosted: Sun Jul 20, 2014 11:24 am
by joeppiej
Thank you, seems to work good.

2 questions about this stat:

1: does it count uncalled riverbets as wagered?

2: If I play on euro sites, is the total amount wagered automatically in Euro, or should I convert this from Dollar to euro myself? (maybe there is a way to get it in euro's directly?)

EDIT: I did some counting by hand and it seemes that just $ = EURO in this stat, correct?

Thanks for your always awesome help!

Re: Total Amount Wagered

PostPosted: Mon Jul 21, 2014 7:43 am
by kraada
I believe that is considered wagered. Amount stored in this field is in Game Currency -- it can be converted to My Currency the same way as any other GC type column is -- see how My Currency Won is built; you'd want to do the same thing but for amt_bet_ttl instead of amt_won.