Stars VPP for EUR tables

[Goertsy]

Hi,

I'm using this custom stat for calculating Stars VPP: !Pokerstars VPP 2010 Holdem! by redeyes173.
It is almost perfect, my only problem is that it is a bit off due to the different multiplier of EUR tables.

It currently uses only the 6x multiplier for FR cash tables and the 5.5x for SH tables.
Is there a way to add a 8.5x multiplier for FR EUR cash tables and 8x for SH EUR tables?

I'm only interested in the FR part btw as I don't play any SH.

Also it would be awesome to have an other stat which shows the vpp/hand figure for every session, and for different limits also.

Unfortunately I have no clue how to create or edit stats so I'm looking for someone who is kind enough to do it for me. ;)

[WhiteRider]

I think that this should do it:

Code: Select all

if[holdem_limit.limit_name LIKE '€%', if[holdem_limit.limit_name LIKE '% max)', (holdem_table_session_summary.amt_mgr*8), (holdem_table_session_summary.amt_mgr*8.5)],if[holdem_limit.limit_name LIKE '% max)', (holdem_table_session_summary.amt_mgr*5.5), (holdem_table_session_summary.amt_mgr*6)] ]

If I break it up like this it should be more readable:

if[
holdem_limit.limit_name LIKE '€%',
if[holdem_limit.limit_name LIKE '% max)', (holdem_table_session_summary.amt_mgr*8), (holdem_table_session_summary.amt_mgr*8.5)],
if[holdem_limit.limit_name LIKE '% max)',
(holdem_table_session_summary.amt_mgr*5.5), (holdem_table_session_summary.amt_mgr*6)]
]

So: if the limit name starts with € do the middle IF statement, otherwise do the last one.

[Goertsy]

Thanks for the assistance.

I'm not sure I'm doing it right as I've never done this before.

So I copy&pasted the code you provided.
The good news: It is working on the "sessions" tab. It shows 4869.57 vs the actual 4874.20 for this month, but that is fine. (Any idea why is the small difference? I haven't played anything else all my HHs are in PT3)

The bad news: On the "general" tab I got an error message: ERROR: column "holdem_limit.limit_name" must appear in the GROUP BY clause or be used in an aggregate functionI tried to tick the group by box in the stat edit. If I do so the error message disappears, but in that way the player summary will show every table session separately instead of summarizing each limit. Also the VPP number is way off, showing 4100ish instead of 4874.
Any idea for this?

[WhiteRider]

Sorry, I should have said - that is the Holdem Cash Session section version. The columns in the other sections will need similar changes, but you won't be able to use exactly the same expression. The Holdem Tournament Tournaments version will need a SUM around it, for instance. Have a look at how the expression I gave you is different to the original, and change the others in a similar way. It should just be my expression inside a sum( ).

[Goertsy]

Thank you.
Now it's working fine.

I also created a stat which calculates rakeback from the VPPs earned.:)

[WhiteRider]

Nice one! If you want to share it you can upload it back to the "Get More" section. :)