4bet amount stat in database

[stevi3p]

I want to run some queries within the database re: 4bet preflop pots. I would like to find something that returns the value of the 4bet, but I can't see where this value is held.

In holdem_hand_player_detail there is a amt_p_raise_made_2. Will this return the 4bet amount if the player was the initial raiser (I presume that amt_p_raise_made holds the value of the first raise)? If so, does it hold the extra raise, or total bet (e.g., if the opponent 3bets to 24, and I make it 60 in total [so 36 extra], will this column hold 60 or 36]? I looked in the documentation, but it seems that amt_p_raise_made_2 has only been added recently since there's no reference to it.

If this is correct, where would a 6-bet value be held? Would it be held in amt_p_raise_made_2 and the 4-bet value gets "lost"? (Hardly a major concern since 6bet pots are so rare, but still useful to know.)

Finally, could I ask you to briefly explain how amt_p_effective_stack works? It seems to me that there are lots of different ways to interpret this value depending on who folds when. Ideally, I would like to create a custom stat that returns % fold to 4bet when the minimum stack of the 3bettor and 4 bettor is more than, say, 100BBs. But I believe this isn't possible; is that right?

Many thanks for your help.

Steve

[WhiteRider]

I believe that amt_p_raise_made_2 is the final raise made preflop. I don't know off the top of my head whether it is the raise-to or raise-by amount, but if you can't work it out please reply to this thread and I'll investigate later when I have some time.

amt_p_effective_stack is the smallest stack of anyone who is dealt cards.
I agree that this field is difficult to use, but it's hard to have a single 'effective stack' value.. If you have a suggestion of exactly what value you'd like to see, we'd like to hear it.

You're right, you can't find out information about a specific opponent, like their starting stack.

[stevi3p]

"(e.g., if the opponent 3bets to 24, and I make it 60 in total [so 36 extra], will this column hold 60 or 36"?)"

I have found out that it will actually hold the extra amount bet relative to the player's initial bet. So if I make it 7, get 3bet, and I then make it a total of 60, the amt_p_raise_made_2 field will contain 53.

Re: amt_p_effective_stack. Yeah, very difficult to make this useful. One option is to have two stats: so amt_p_effective_stack for the first decision preflop and amt_p_effective_stack2 for the final decision preflop, which takes into account all the folds and so on - this would be useful for examining 4bet stats. I want a useful fold to 4bet PF stat, and it's very hard to get something meaningful without knowing effective stacks. I don't see the need for equivalent fields postflop though.

Oh, and amt_p_effective_stack should be the value when the player makes his decision not just the minimum stack at the table, but again hard to see this being used often, so not a priority.

[WhiteRider]

Oh, and amt_p_effective_stack should be the value when the player makes his decision not just the minimum stack at the table, but again hard to see this being used often, so not a priority.

Yes, that was my suggestion exactly.
Thanks for your comments.