Raise First In BU with limps?

[Lakestone]

I am trying to build a stat that shows how often someone raises an unraised pot on the button.
I know there is a RFI but it doesn't work if someone is raising after limp(s) and it does not work for each position. This is the best I can do, is it possible to get closer?

(Opp)
sum(if[tourney_holdem_hand_player_statistics.position = 0
AND tourney_holdem_hand_player_statistics.flg_p_3bet_opp = false
AND tourney_holdem_hand_player_statistics.flg_p_4bet_def_opp = false
AND tourney_holdem_hand_player_statistics.flg_p_first_raise, 1, 0])

The problem that I can think of is that the opportunity will not filter hands that were 3Bet or 5Bet+/Jams before us?

[kraada]

You want to use the stat RWPC - it's built for this scenario. Just duplicate it and add holdem_hand_player_statistics.position = 0 to your modified times and opportunities columns and that should be all you need to do. RWPC stands for "raise with previous callers" so counts all situations where you raise limpers.

[Lakestone]

You want to use the stat RWPC - it's built for this scenario. Just duplicate it and add holdem_hand_player_statistics.position = 0 to your modified times and opportunities columns and that should be all you need to do. RWPC stands for "raise with previous callers" so counts all situations where you raise limpers.

But that is specifically when people did limp before, I want them both, basially how often we raise first in on a position.
I tried this but got an error:

Edit: Trying!

[kraada]

Ok so what you want to do then is make a custom stat that combines the two pieces of information - that and RFI as those are the only two times you make 2Bets. The Value Expression of your new stat will look like this:

((cnt_p_raise_first_in + cnt_p_raise_limpers) / (cnt_p_open_opp + cnt_p_facing_limpers)) * 100

[Lakestone]

Ok so what you want to do then is make a custom stat that combines the two pieces of information - that and RFI as those are the only two times you make 2Bets. The Value Expression of your new stat will look like this:

((cnt_p_raise_first_in + cnt_p_raise_limpers) / (cnt_p_open_opp + cnt_p_facing_limpers)) * 100

And the position right, so my custom column (limps and open_opp combined) for opportunity can look like...

sum(if[tourney_holdem_hand_player_statistics.position = 0
AND ((((NOT tourney_holdem_hand_player_statistics.flg_p_face_raise)
OR tourney_holdem_hand_player_statistics.flg_p_limp
OR tourney_holdem_hand_player_statistics.flg_p_first_raise)
AND NOT tourney_holdem_hand_player_statistics.flg_p_open_opp
AND lookup_actions_p.action <> '')
OR tourney_holdem_hand_player_statistics.flg_p_open_opp), 1 , 0 ])

Correct?

[kraada]

Yep that will do it.

[Lakestone]

Awesome, take care Kraada!

[DalTXColtsFan]

Out of curiosity is it possible to create reports against the cash_hand_player_statistics table from within the report writer in Poker Tracker 4 itself?

[WhiteRider]

I'm not sure exactly what you mean, but you can't display database information directly in custom reports - you would need to make a stat to display what you want.
A report in the Holdem Cash Player Statistics section can show stats using that table, and you can filter directly on information in that table using custom expression filters.

[DalTXColtsFan]

Thanks WhiteRider. What I mean is I can't seem to figure out how to create reports within the application that look at ALL players.

For example, suppose I want to create a report of all hands where ANY player limp-called and the hand went to showdown.

If I create a report where Any Limp is true, and the PF action is CC, I only get a report of the hands where *I* limp-called.

How do I create a report within the application where ANY PLAYER IN THE HAND limp-called?

Hope that made sense.