ev roi for all games (HELP)

[javippp]

Hi

I'm traying to do a ev roi for all the games I play.

I'm just using a simple formula

roi = (chips ev - rake chips)*100 / starting chips

I'm not sure if this is incorrect, but still I whant to do it with this formula.

So, to count starting chips, I'm using this colum (amt_starting_stack):

Code: Select all

select distinct first_value(thps.amt_before) over (partition by thps.id_tourney order by thps.date_played)
from tourney_hand_player_statistics as thps
join tourney_summary as ts on ts.id_tourney = thps.id_tourney
where thps.flg_hero
and ts.tourney_no = tourney_summary.tourney_no

and for the chipsEV/tourney I'm using the stat from the warehouse:

Code: Select all

amt_expected_won / cnt_tourneys

with the expression:

Code: Select all

format_number(amt_expected_won / cnt_tourneys, 0, true, true)

Now, here is what I cant understand: How can I use the expression in another stat?

Please help, when finished I will be uploading the stat.

[Flag_Hippo]

Unfortunately I don't know of a method to achieve this. A statistic like that would need to combine information from tournament data and from hands and there isn't a simple way to retrieve the total expected chips for a particular tournament and associate that with the starting stack.

[javippp]

Thanks for responding ...

I'm now traying in another way with this ... but don't undersand how the expressions work .. please help ..

Code: Select all

((amt_expected_won / cnt_tourneys)-((amt_fee / (amt_buyin + amt_fee))*100))/(500)

and the expression

Code: Select all

format_number(((amt_expected_won / cnt_tourneys)-((amt_fee / (amt_buyin + amt_fee))*100))/(500), 0, true, true)

but the result when after calcs give == 0

What should I write? and if you can explain how the expressions work

[Flag_Hippo]

The same issue I mentioned above applies here as well to the buyin. A statistic like that would still need to combine information from tournament data and from hands and there isn't a simple way to retrieve the total expected chips for a particular tournament and associate that with the buyin.