fraktool wrote:SB Fold (str_actors_p LIKE '0%' ensures that ?)
No, that only means the BTN was the first player to voluntarily put money in. The SB can still call or raise after the BTN. To make sure the SB folded, also check that the SB (position 9) didn't put money in straight after the BTN:
- Code: Select all
and tourney_hand_summary.str_actors_p NOT LIKE '09%'
fraktool wrote:BTN calls or raise
fraktool wrote:lookup_actions_p.action SIMILAR TO '%F'
fraktool wrote:BB anything that happens before and then Fold
Note that lookup_actions_p.action only contains the preflop actions of that player (in this case the BB), not the actions of the other players in the hand. So lookup_actions_p.action LIKE '%F' means any preflop action by the BB that ends with a fold, for example F, RF or CF. Can you explain what situation you want this statistic to measure? If the BTN limps (calls) the BB can check, so the BB can only fold if they raise and the BTN then re-raises, which is a different situation to folding against a BTN open raise. Please also post the opportunity column you are using with this, as that needs to match the situations where the BB actually has the option to fold.
fraktool wrote:I can create a quick filter to match that ,right ? to prove the stat is correct
Yes, you can test it with an expression filter in a hands report:
1. Go to
'My Reports' and create a new hands report.
2. Click the 'Filters' link in the report and select 'Add New Expression Filters'.
3. Paste the expression without the
sum(if[ at the start and the
, 1, 0]) at the end.
4. Click 'Validate', then 'Save'.
5. Open some of the hands in the replayer and check they are the situations you expect.