Cev vs Vilain

[lucky]

Hi!

Is there a custom stat that allows you to see your Cev against a particular opponent?
I'm looking for a stat to add to the HUD or the report.

Thanks in advance!

[Flag_Hippo]

There isn't a custom statistic for that but you could review data for hands where a named Villain was all-in with you in custom report with an expression filter:

Code: Select all

tourney_hand_player_statistics.val_equity > 0
AND (
    0 < (
        SELECT count(thps2.id_hand)
        FROM tourney_hand_player_statistics thps2
        WHERE thps2.id_hand = tourney_hand_player_statistics.id_hand
        AND thps2.id_player = (
            SELECT p.id_player
            FROM player p
            WHERE player_name='Villain'
        )
        AND (thps2.val_equity > 0)
    )
)

You can use this expression filter by clicking on the 'Filters' link and selecting 'Add New Expression Filters'. In a custom hand report you may need to change the hands dropdown to 'Max Hands' if the filter generates an error.

[lucky]

Hi,

In my report, my overall Cev is 24.8 and that of my main opponent is 9.7.

I had managed to create an "Add New Expression Filters" option that allowed me to see my Cev against each opponent.
I've tried everything and it's impossible to find anything that works.

Thanks.

[Flag_Hippo]

I had managed to create an "Add New Expression Filters" option

I'm not sure what you mean here. This just looks like you have created an 'All Players Report' and used the expression filter however the filter I provided is not for use in an 'All Players' report where the filter on active player option is turned off. The expression filter needs to be used on the active player only so you'll need to use it in a custom 'Player' or 'Hand' report instead that is specific to you.

that allowed me to see my Cev against each opponent.
I've tried everything and it's impossible to find anything that works.

As I mentioned in my original reply there isn't a statistic for that. I've provided you with a filter where you can review your data when you are all-in against a specific player. Also if you are expecting your adjusted results to be the opposite of villains then you are not going to see that if any of these hands are multiway. They will only be exactly opposite in hands where you and villain were the only two players dealt into the hand.