Nobody is in position?

[Carcharias]

There's a flag called flg_f_has_position in the holdem_hand_player_detail table. It should be true when a player is in position (last to act) on the flop and false otherwise, but this data is not being set correctly. This applies also to the flags flg_t_has_position and flg_r_has_position for turn and river.

The way these flags get set, is that if a player is on the button and sees the particular street, then the flag is true, otherwise it's false. To me that makes the whole flag completely useless. Surely a player is in position also if he's under the gun and only the big blind calls and sees the flop with him. This is very important flag for data analysis, because it's completely different thing to check being out of position (and possibly plan to check-raise) than check when you're last to act. Also betting last to act in a multi-way pot, when everyone has checked to you and no one seems to want the pot, may very well be a positional steal, but betting out of position is never that.

I also think that having correct data in the database is a higher priority problem than any performance improvements or new features.


You can see for yourself how flg_f_has_position is set by running the following queries. The first one returns hands, where there's a flop but no one is in position and displays whether player on the button saw the flop or not (in all of the hands he didn't). The second query returns the hand's in which there is a player with has position -flag set to true and also whether or not the button saw the flop (in all of the hands he did).

select
pd.id_hand,
sum( case when ps.position = 0 and ps.flg_f_saw is true then 1 else 0 end ) as button_saw_flop

from
holdem_hand_player_detail as pd,
holdem_hand_player_statistics as ps

where
pd.id_hand = ps.id_hand and
pd.id_player = ps.id_player and
pd.id_hand < 10000

group by
pd.id_hand

having
sum( case when ps.flg_f_saw is true then 1 else 0 end ) > 0 and
sum( case when pd.flg_f_has_position is true then 1 else 0 end ) = 0;

------------------------------------------------------------------------------------------

select
pd.id_hand,
sum( case when ps.position = 0 and ps.flg_f_saw is true then 1 else 0 end ) as button_saw_flop

from
holdem_hand_player_detail as pd,
holdem_hand_player_statistics as ps

where
pd.id_hand = ps.id_hand and
pd.id_player = ps.id_player and
pd.id_hand < 10000

group by
pd.id_hand

having
sum( case when ps.flg_f_saw is true then 1 else 0 end ) > 0 and
sum( case when pd.flg_f_has_position is true then 1 else 0 end ) = 1;

[WhiteRider]

The 'in position' flag was fixed in Beta 15, but I think it required a re-import.
If you've found a hand which imports and gives an incorrect value for this flag in beta 15 please attach it to a ticket on the Support system.
Thanks.

[Carcharias]

No, it's not fixed. Quote from release notes of Beta 15: 'Import: Fixed "has position" database field when an invalid button is specified by the hand history'. I'm not talking about hand histories with invalid button. I made a fresh install of PokerTracker 3 Beta 15 and imported all my hands from the original hand histories, and I'm telling you, in all of the hands where the flop is dealt but the button doesn't see it (which is a big percent of all the hands), all the players have flg_f_has_position as false. But like I said, you don't have to take my word for it, it takes you about three seconds to make those queries I posted to verify that I'm right. But sure I'll send you some more hand histories.

[WhiteRider]

OK, it's a little while since I tested the 'in position' thing - I submitted a ticket about it too after I tried to build a custom stat using it, but I can't remember whether I retested it since Beta 15 - I'll retest it when I have chance.
By all means create a ticket about it.

[Carcharias]

Ticket created

[WhiteRider]

Thanks.

[WhiteRider]

I've just retested my old test report/stat, and as you say it's still wrong - I'll reopen my ticket too.
Thanks.

[Tommi]

It all seems to be correct in beta 16 now

[WhiteRider]

Great - yes, I just tested that yesterday too and the flag was right for every hand I tested.