Filter for relative position?

[Donkey111]

Is there any filter to know if a player has the best relative position postflop, i.e. is seated just in front of a preflop raiser in a multiway pot? Many thanks.

[kraada]

You can filter for position relative to Lead/Aggressor in the Hand Details -> Player Position -> Flop page and that will tell you where you are relative to the last person to raise preflop.

[Donkey111]

Thanks for your answer but this seems to measure the absolute position and I am interested in the relative position. For example:
UTG open raises, BTN calls and BB overcalls. On the flop, if UTG cbets, BTN has obviously the best absolute position but BB has the best relative position because he is the one who is actually closing the betting (if he wishes so).

[kraada]

There is currently no filter for "Opportunity to Close the Action" but I'll make a note of it to see what can be done there going forward.

[Donkey111]

Excellent. Thank you. In case you are interested in the rationale of my query, it is explained in detail in No Limit Hold'em: Theory and Practice by Sklansky and Miller p91-97. You can check out most of the chapter on Google books.

[kraada]

I understand what you're going for, and since relative position is a tricky concept to handle from a programming standpoint we haven't historically added anything like that. I believe it may be possible to add this one specific filter but I'd have to think carefully about it to be absolutely certain, as it may not in fact be possible without additional information being added to the database.

[tennishepcat]

Hi there,

I wanted to follow up and see if a filter for Opportunity to Close the Action is being considered at all in the near future?

[kraada]

That would be very difficult to build given the way the database is currently set up, so I don't know if or when that would be added.

[BillGatesIII]

Try this Expression Filter (in a cash hands report).

Code: Select all

position = (select min(chps.position)
from cash_hand_player_statistics chps
join cash_hand_summary chs on chps.id_hand = chs.id_hand
where chs.id_hand = cash_hand_player_statistics.id_hand
and chps.flg_f_saw
and chs.cnt_players_f >= 3
and chps.position >= case when substring(chs.str_aggressors_f from '.$') = '9' then 0 else substring(chs.str_aggressors_f from '.$')::int + 1 end)

[kraada]

I don't think that's going to work quite right; first off position needs to be less to be in position so I think you want <= not >= -- otherwise when the SB is the aggressor you'll have every position count. If you're in the BB and the SB is the aggressor and there's a button behind you, you certainly don't have the opportunity to close the action.

We'd need to, at a minimum, test both aggressors and actors to figure who is on the flop so we know our position relative to everybody. Then we have to test that we are last to act after a bet or raise or it's checked to us. It's . . . more complicated than what you have here