by dumbFred » Thu Nov 18, 2021 5:53 pm
Thank you Flag that solved the issue.
Now for a sample of 7 tournaments:
BUY IN NET WON ROI
1,00 € -1,00 € -100%
10,00 € -10,00 € -100%
20,00 € -15,50 € -78%
2,00 € 18,00 € 900%
5,00 € 11,26 € 225%
5,00 € 19,16 € 383%
10,00 € -10,00 € -100%
I manually calculate:
ROI 22,49%
Avg ROI 162%
While the result provided by the formula of amt_tourney_roi / cnt_tourneys is: 322,51% for the same sample.
The formula behind amt_tourney_roi is the following:
sum(if[tourney_summary.val_curr_conv!=0, (tourney_summary.val_curr_conv * (tourney_results.amt_won + tourney_results.val_bounty * tourney_summary.amt_bounty) - tourney_summary.val_curr_conv * tourney_summary.amt_buyin) / tourney_summary.val_curr_conv * tourney_summary.amt_buyin, if[currency_tourney_toglobal[tourney_summary.amt_buyin, tourney_summary.currency] != 0, (currency_tourney_toglobal[tourney_results.amt_won + tourney_results.val_bounty * tourney_summary.amt_bounty, tourney_summary.currency] - currency_tourney_toglobal[tourney_summary.amt_buyin, tourney_summary.currency]) / currency_tourney_toglobal[tourney_summary.amt_buyin, tourney_summary.currency], 0]])
Can you help to understand why the result is not the same between my calculation and the added statistic calculation ?
Thank you very much.