Bet amounts breakdown

[WhiteRider]

Is it possible to find out what size individual bets were, e.g. if I raise, get reraised and call, can I find out how much my original raise was? (NL, obviously)

I can see holdem_hand_player_detail.amt_bet_p and holdem_hand_player_statistics.cnt_p_raise so I know the total I bet and how many times I raised, but not what my original raise size was.
Edit: just found holdem_hand_player_detail.amt_p_raise_made which solves the above problem, but what if I 3-bet?
Is holdem_hand_player_detail.amt_p_raise_made the sum of all raises, or just the first raise?

I can also see holdem_hand_player_detail.amt_p_raise_facing which may be useful..

We need to be able to see individual bet sizes as people's behaviour will often be different after open-min-raising than opening for more. What I'd really like is access to each individual bet/raise. I don't know how you'd store this info as there are an unspecified number of bets - can you have an array as a DB field?
Even just a 'amt_p_first_raise' would be a start. If amt_p_raise_made is the first raise, then we need total raise too - e.g. for raise-call-reraise-call (etc).

Related subject: another useful stat would be total amount bet by all players on each street, so that we can work out pot totals at each street, and therefore compare bet sizes to the pot size.
I know we have holdem_hand_player_detail.val_f_raise_made_pct (=% of pot raised on flop), which is pretty-much what I want, but I can't help but feel that the total betting on each street would be useful.

[Josh]

The amt_X_raise_made fields hold the amount of the last raise made by the player. So if you raise, then re-raise, it will only contain your last raise. Fields like amt_pot_f, might be a good idea. I'll discuss it with Derek and see what we should do.

[WhiteRider]

Thanks.
I do think we need to be able to find the size of the original raise too, though.
There are a lot of people I play with who make a lot of minimum raises and I really want to be able to analyse what those min-raises mean compared to larger raises. If they 3-bet we'll lose that info.

[Josh]

I think the best we could do is have two amount fields: one for the first raise you make and one for the last raise.

[WhiteRider]

OK - that should be good enough. There aren't going to be many cases where there are more raises than that, so we won't need to analyse them en-masse. If the count of raises is more than 2 we can look at the hands individually.
Thanks.

[EinSIM]

are there 2 fields in the database, now ? i cant find them in the manual

[Josh]

Yes, there are now amt_<street>_raise_made_2 in the _player_detail tables.

[EinSIM]

ok found the second, but it will not be calced. all data is 0

[Josh]

Have you found a hand where it should have been set and wasn't?

[EinSIM]

Have you found a hand where it should have been set and wasn't?

not a special hand !! i made a select * from holdem_hand_player_detail where holdem_hand_player_detail.amt_p_raise_made_2 > 0
and got 0 results. in my database are million different hands, so i think there should be some