Stat for amount of call on the river

[sawwee]

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]

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...

[WhiteRider]

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.)

[sawwee]

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?

[WhiteRider]

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.

[sawwee]

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.

[kraada]

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.

[sawwee]

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:



What is the reason you think?

Thanks in advance.

[WhiteRider]

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.

[sawwee]

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!