Stat for amount of call on the river

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Stat for amount of call on the river

Postby sawwee » Sun Apr 14, 2013 7:07 pm

Is there a column in the database which tells me the amount of the call as a very last action on the river?

I mean: For example I bet the river with $200, my opponent raise to $600, I call. "tourney_hand_player_statistics.amt_bet_r" gives $600 for me as my total action. Is there a column which stores the amount of my last call only? ($400 in this case.)

If there isn't, how I can create that as a custom stat?

Thank you in advance!
sawwee
 
Posts: 513
Joined: Thu Dec 18, 2008 11:59 pm

Re: Stat for amount of call on the river

Postby sawwee » Sun Apr 14, 2013 7:10 pm

Moreover I would like to create the same stat with some other actions, too: amount of bet (as my very last move), amount of raise (as my very last move).
Thanks again...
sawwee
 
Posts: 513
Joined: Thu Dec 18, 2008 11:59 pm

Re: Stat for amount of call on the river

Postby WhiteRider » Mon Apr 15, 2013 3:13 am

The amount you have to call (specifically: the size of the last raise faced, but only the amount you would need to call) is stored in:
cash_hand_player_statistics.amt_r_raise_facing

The size of a bet is stored in:
cash_hand_player_statistics.amt_r_bet_made

The size of the first and last raises are stored in:
cash_hand_player_statistics.amt_r_raise_made
cash_hand_player_statistics.amt_r_raise_made_2
(If you only raise once then the _2 value will be zero.)
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Stat for amount of call on the river

Postby sawwee » Mon Apr 15, 2013 6:22 pm

Thanks a lot for your answer.
Actually I still have difficulties. I created a stat which contains only amt_bet_r and it works perfectly, I can display it in hand reports. However I'm unable to create a stat with amt_r_bet_made because a popup comes "Invalid Value Expression". Why does it happen?
sawwee
 
Posts: 513
Joined: Thu Dec 18, 2008 11:59 pm

Re: Stat for amount of call on the river

Postby WhiteRider » Tue Apr 16, 2013 3:01 am

Did you include the database table name in your column expression too?
If you post your expressions here we'll be able to help you find out what is wrong.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Stat for amount of call on the river

Postby sawwee » Tue Apr 16, 2013 6:06 am

My expression was simply 'amt_r_bet_made', I wanted to see this info in the hand listings report. (Later I wanted to create some more stats with it but first of all I wanted to see if this stat is what I need indeed.)
I tried to include the database table name, too, but it didn't help.
The strange thing is that I have no problem to create a stat with 'amt_bet_r and', but once I try to do the same with 'amt_r_bet_made' I fail.
sawwee
 
Posts: 513
Joined: Thu Dec 18, 2008 11:59 pm

Re: Stat for amount of call on the river

Postby kraada » Tue Apr 16, 2013 8:25 am

Did you put it in the Hand section? You'll want it in the Hand section to work like that. You will definitely want to refer to the table with the full cash_hand_player_statistics part in order for things to work properly.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Stat for amount of call on the river

Postby sawwee » Tue Apr 16, 2013 10:33 pm

Yes, I put it in the Hand section.
I tried to refer the table (tourney_hand_player_statistics actually, because I needed it for some tournaments) but it didn't help.

Here is a screenshot about it:

Image

What is the reason you think?

Thanks in advance.
sawwee
 
Posts: 513
Joined: Thu Dec 18, 2008 11:59 pm

Re: Stat for amount of call on the river

Postby WhiteRider » Wed Apr 17, 2013 3:22 am

You can't refer to database tables directly from Statistics. You will need to make a new Column with that expression, then have your stat use the new column.

Check out the Custom Statistics Guide for an introduction to working with custom stats.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Stat for amount of call on the river

Postby sawwee » Wed Apr 17, 2013 4:11 am

Thank you for your answer, yes, it works now!

However it doesn't give me the result I need.
I need the result to be the amount of my very last CALL on the river, whatever happened before. (If I check/call, the result should be the amount of my call. If I bet 400, my opponent raise to 1000 and I call his raise, the result should be 600, since this is the amount of my last CALL. If I bet and my opponent calls, the result should be 0 since I didn't do any call.)
Is there a column for that?

Thanks for your patient and for your help!
sawwee
 
Posts: 513
Joined: Thu Dec 18, 2008 11:59 pm

Next

Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 24 guests

cron