Total Amount Wagered

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Total Amount Wagered

Postby Tract0rDan » Fri Dec 18, 2009 3:55 am

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?
Tract0rDan
 
Posts: 37
Joined: Tue Sep 09, 2008 9:02 am

Re: Total Amount Wagered

Postby WhiteRider » Fri Dec 18, 2009 5:25 am

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
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Total Amount Wagered

Postby joeppiej » Wed Jul 16, 2014 7:33 pm

Hello,

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

Thank you
joeppiej
 
Posts: 33
Joined: Sun Aug 04, 2013 3:05 pm

Re: Total Amount Wagered

Postby WhiteRider » Thu Jul 17, 2014 3:24 am

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.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Total Amount Wagered

Postby joeppiej » Sun Jul 20, 2014 11:24 am

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!
joeppiej
 
Posts: 33
Joined: Sun Aug 04, 2013 3:05 pm

Re: Total Amount Wagered

Postby kraada » Mon Jul 21, 2014 7:43 am

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.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 13 guests

cron