Page 1 of 2

Equivalent stats return different values

PostPosted: Wed Nov 14, 2012 11:57 am
by erdnase17
I made a simple column called cnt_p_face_minr to count the number times a player faced a minraise in heads up games, which has the definition:
Code: Select all
sum(if[tourney_hand_player_statistics.amt_p_raise_facing = tourney_blinds.amt_bb and tourney_hand_player_statistics.position = 8, 1, 0])

If I run this stat for a particular villain it will return some value.

Then I made another column called cnt_p_minr that counts the number of times a player minraised. The definition is:
Code: Select all
sum(if[tourney_hand_player_statistics.flg_steal_att and tourney_hand_player_statistics.amt_p_raise_made = 2 * tourney_blinds.amt_bb, 1, 0])


Now If I run a report for hero with a stat based on the latter column, filtering only for hands against this particular villain with:
Code: Select all
tourney_hand_player_statistics.id_hand in (SELECT chps.id_hand from tourney_hand_player_statistics chps, player p where chps.id_player = p.id_player and p.player_name = 'villain sn here')

it will return a different value.

Why the discrepancy? One of the columns must be incorrect, which is it?

Thanks

Re: Equivalent stats return different values

PostPosted: Wed Nov 14, 2012 12:05 pm
by erdnase17
I tried changing the cnt_p_faced_minr to
Code: Select all
sum(if[tourney_hand_player_statistics.flg_blind_def_opp and tourney_hand_player_statistics.amt_p_raise_facing = tourney_blinds.amt_bb and tourney_hand_player_statistics.position = 8, 1, 0])

and I got slightly closer results but still different.

Any ideas?

Re: Equivalent stats return different values

PostPosted: Wed Nov 14, 2012 12:38 pm
by kraada
There's a key piece of information you're missing here - that is that the amt_p_raise_facing value is based on how much the player needs to call - not the total amount the raise was to.

So when you open for a minraise the player in the big blind (assuming all others fold) has an amt_p_raise_facing of 1 BB - not 2BB.

That almost certainly accounts for your entire discrepancy (this affects the SB too, obviously).

Re: Equivalent stats return different values

PostPosted: Wed Nov 14, 2012 12:45 pm
by erdnase17
kraada wrote:There's a key piece of information you're missing here - that is that the amt_p_raise_facing value is based on how much the player needs to call - not the total amount the raise was to.

So when you open for a minraise the player in the big blind (assuming all others fold) has an amt_p_raise_facing of 1 BB - not 2BB.

That almost certainly accounts for your entire discrepancy (this affects the SB too, obviously).


I am not sure I am following you.
The definition of cnt_p_face_minr is using 1 bb as the amount amt_p_raise_facing:
Code: Select all
sum(if[tourney_hand_player_statistics.amt_p_raise_facing = tourney_blinds.amt_bb and tourney_hand_player_statistics.position = 8, 1, 0])


When you say it affects the SB what do you mean? The amt_p_raise_made should be 2 bb right? (I tried 1 bb and it won't work...)

Thanks.

Re: Equivalent stats return different values

PostPosted: Wed Nov 14, 2012 3:01 pm
by kraada
Sorry, I missed that we were talking about exclusively heads up.

I'm not sure why these wouldn't be identical then. How far off are they?

Re: Equivalent stats return different values

PostPosted: Wed Nov 14, 2012 3:35 pm
by erdnase17
kraada wrote:Sorry, I missed that we were talking about exclusively heads up.

I'm not sure why these wouldn't be identical then. How far off are they?


About 5-7 hands.

Re: Equivalent stats return different values

PostPosted: Wed Nov 14, 2012 5:03 pm
by kraada
Out of how many?

Re: Equivalent stats return different values

PostPosted: Wed Nov 14, 2012 5:08 pm
by erdnase17
kraada wrote:Out of how many?


The report is 1691 hands.

Re: Equivalent stats return different values

PostPosted: Wed Nov 14, 2012 6:23 pm
by kraada
I think the best way to figure this out might well be to make Hand reports and then compare the actual hand numbers from the two reports. If you include hole cards and hand numbers it might not take too long to find one hand that doesn't match - and once you find one, we'll be able to figure out what is going on here.

Re: Equivalent stats return different values

PostPosted: Wed Nov 14, 2012 6:30 pm
by erdnase17
kraada wrote:I think the best way to figure this out might well be to make Hand reports and then compare the actual hand numbers from the two reports. If you include hole cards and hand numbers it might not take too long to find one hand that doesn't match - and once you find one, we'll be able to figure out what is going on here.


I tried that but the Hand Reports won't accept custom stats...

highfalutin