The second code you gave me is not valid. You also need to include a value (or range of values) for the amount of big blinds you want as per the final example (which is for an adjusted bb amount greater than 50). Anyway I think what I need is the third one but doesn't work properly. Let me explain ...
That's a known issue as far as I am aware in a specific scenario. If you open a Support Ticket quoting reference #6606 we can follow up on this with you.
That will need an expression filter: Cash cash_hand_player_statistics.amt_expected_won / cash_limit.amt_bb Tournaments tourney_hand_player_statistics.amt_expected_won / tourney_blinds.amt_bb Bear in mind that in hands with no all-in adjustment the adjusted result will be the same as the actual resul...
Both queries can use the database cache so there shouldn't be any noticeable difference. Also the two expressions you've given don't do the same thing since lookup_actions_f.action = 'X' is specific to a player wheareas tourney_hand_summary.amt_pot_t = tourney_hand_summary.amt_pot_f is specific to t...
You can import that and then convert it to a tournament statistic by selecting the cash version in 'Configure -> Statistics' and then on the details tab choosing 'Options -> Convert'.
That statistic is for tournaments so if you are trying to add it to a cash game HUD you will not see it. You can convert this to a cash statistic by selecting the stat in 'Configure -> Statistics' and then on the details tab choosing 'Options -> Convert'.
This should be the same for you as it is for everyone else. Make sure you are searching 'Hero' without the quote marks otherwise please attach the sample of hands you are importing to a Support Ticket along with relevant screenshotsfrom PokerTracker 4. Thank you.
When you registered PokerTracker 4 Holdem you automatically receive a free 10 day trial for Omaha which you can access via the 'Help -> Register' menu item and then selecting the 'Begin 10 Day Omaha Trial' button. Omaha Hi/Lo is also supported.
If a player takes at least one action on the flop then they were not all-in preflop: lookup_actions_f.action LIKE '_%' You can add that to the column expressions used in the original statistics - this post covers how to make a new version of a statistic. For further information see this guide for th...