Quote from: joter85 on July 21, 2019, 01:45:27 PM

Quote from: Timetwister on July 21, 2019, 01:12:02 PM

Quote from: joter85 on July 21, 2019, 08:22:44 AM

Quote from: Timetwister on July 21, 2019, 04:14:00 AM

Quote from: thenerdyone314 on July 21, 2019, 01:46:20 AM

If you look at the total bankroll over that time period, other than one initial spike a day or two after the investment start date, it is almost a flat line for the whole time period. You make it sound like it wildly fluctuates like some pump and dump coin value lol

We discussed this topic here some weeks ago, you can see my messages. Basically their graphs show "profits" before expenses, which I find misleading, they should indicate their that those are not real profits. You should expect to make more of less 70% of what the graphs shows (you must consider that bankroll keeps fluctuating as you were told, you can see the calculations I made in some previous messages in this thread).

Not really. Graph shows actual profit paid to investors (100%). But total bankroll size is shown wrong on graphs, need to fix that one.

That's not true, you even confirmed it when we talked about that here:

https://bitcointalk.org/index.php?topic=750760.msg51678418#msg51678418
https://bitcointalk.org/index.php?topic=750760.msg51678694#msg51678694

Then you understood me wrong. Once again, and I hope for the last time: profit on graph is actual profit paid out to investors. It is amount that investors got.

EDIT: I found one issue with graph... minesweeper data was not visible, have added that one to graph.

So logic is simple:
Profit in investment graph is: SUM(amount_dice+amount_slot+amount_blackjack+amount_videopoker+amount_roulette+amount_plinko+amount_mines-expenses) as profit

Data is taken from investments_details table, that has data of every single invesment profit paid to investors since the start of investment option on site. Data is grouped by dates, so each calculation that happens between 00:00:00 and 23:59:59 is grouped together.

Profit column is actual data that was paid to investors. So if all investors would sum their daily earnings on all of their invesments it would match with graph.

Expenses column is sum of referrer and faucet rewards, investors pay 70% and site pays 30% of those expenses (its has already 30% share cut as that happens in investments calculation).

amount_dice+amount_slot+amount_blackjack+amount_videopoker+amount_roulette+amount_plinko+amount_mines is profit or loss per game.

All data is visible on page:
https://www.crypto-games.net/details.aspx?type=investment&id=LONGID

Replace LONGID with your personal longid.

Either way I need to optimize this graph as investments_details table has grow big and calculations of graph takes a lot of computing power, and bankroll data is not calculated properly...

EDIT2: Ok found one more issue with graph

As you can see on investments_details page expenses are always in negative values, so there is a issue with upper formula. It should be:
SUM(amount_dice+amount_slot+amount_blackjack+amount_videopoker+amount_roulette+amount_plinko+amount_mines+expenses) as profit

Not

SUM(amount_dice+amount_slot+amount_blackjack+amount_videopoker+amount_roulette+amount_plinko+amount_mines-expenses) as profit

Sorry for that, my bad. But after all investments are calculated correctly, just there were two graph issues that are fixed now. Bankroll size issue on graph will get fixed soon as it requires more changes.

EDIT3: Bankroll size issue is resolved too. Now bankroll size won't change for old investments.

The graphs definitely look better now. I appreciate you fixing them