Bitcoin Forum

I've been investing in casinos for quite a while, and during that time I've been opening and closing many investments with different amount and leverages, and now I would like to calculate my ROI percentage, but I just don't know how to do it. I have the log of all closed investments, which consists of starting amount, closing amount and leverage, but no dates. I also have the cumulative profit of all my investments. How do I calculate yearly/monthly ROI from this data?

May be the below article can help you to calculate ROI on leveraged investment.

https://financetrain.com/how-to-calculate-leveraged-returns/

The basic formula is as below,

ROI = Net income/Initial investment

But since you have used leverage, the calculation will become a bit more complex. However, to calculate leveraged return, dates are mandatory! Without that you can calculate simple ROI.

If you can share a screenshot of the data, I can prepare an excel file to automatically calculate your ROI.

Thank you for your advice, I'll check it!

One of my problems, aside from leverage, is that that my investments are varying in size - sometimes I was closing them and opening smaller investments while widthrawing the rest, in other cases I was adding additional funds to my investment. Also some of my investments were happening simultaneously, and it's impossible to know which ones, because there are no dates.

If you don't have the dates it's simply not possible calculate your yearly ROI, even your monthly ROI for that matter.

You will only be able to calculate your overall ROI by summing your bets and summing your winnings. Winning Sum / Betting Sum = ROI

You can't.

What you can calculate is your possible ROI throughout the entire time you made your investment, from start to now.

If you want to find dates, then check logs on the investment history page where you made your investment. Time consuming though.

there is no way to calculate it now since you don't actually know how much total you invested , right ?
I wouldn't care a lot about it if the data wasn't available , you should indeed calculate the ROI to see how you are overall doing but maybe start doing the calculation from today and forget about the past

unless the site offers a full data about your past transactions but it's a pain in the ass to even try reviewing all of these

best thing is to start fresh as I stated , and start noting every single transaction that you make

Perhaps there's a way to figure out all the dates,when you made those investments.
I'm not an expert in Crypto casino investing,but most of the legit crypto casinos should have customer support and the customer support representatives might help you with getting more data about your investments.

This in an old thread Bitcoin Gambling Investments (https://bitcointalk.org/index.php?topic=1585408.0) that I followed in the past, try to check, maybe you'll get some important information to help you track your casino investment.

If you invested in a casino site, I guess you need to keep a tab of your monthly profit and from that minus your expenses, Well you can surely compute the leveraged for every month's profit, In my opinion, every gambling site's profit is at random so you can not have the same profit every month or every year, you can always have random numbers, But I guess you can ROI from investing in certain gambling sites because of the house, But you can not have the exact computation for it.

Bets and winning is more on a gambler, maybe he’s talking about the money he can get if he invested on a gambling site/casinos, well pretty easy because you just need to less the total value of your money as of today minus to your initial investment, you can do that everyday but it will depend on your goal when to withdraw that.

Can you share how can you invest in such a casino? Like how it works and how risky it is?
Are you investing in their bankrolls? I would love to hear that, thank you so much.

I've been interested in investing in the casino since I have read some articles and posts here that it is much better to invest in the casino's bankrolls than gambling.

I think you can use simple accounting/bookkeeping as the base for calculating yearly ROI. If you still have all transaction records, then you can create a ledger (accounting), then calculate everything. However, your case is more like a commercial bank accounting, which differs from what I usually do (i.e., company accounting) in my small business.

A banker should be able to help you https://www.wallstreetmojo.com/bank-balance-sheet-vs-company-balance-sheet/

I am personally do not like to count money profit for playing games for sometimes I lose money and sometimes I win. The things that had been my culture is when I win and will be able to withdraw win and then buy food to celebrate as this is only life enjoyable playing in gambling at the same time sharing it with family or friends. It does not matter if I lose or win the important thing is that I manage to win games and share winnings.

Well, it also depends on the price the bitcoin was during the time of your investment. You should take that into account if you calculate values in Dollars or Euros instead of plain BTC. The price volatility will make a huge difference in your ROI. Other calculations are quite straightforward. If you want me to help you doing that, I can do it for a very small service charge and also show you formulas in excel so you don't have to pay anyone next time. :)

There is both a way to calculate it and there is also definitely no way to calculate it at all.

Now, one is having the bankroll and checking how much the bankroll is in total, some places gives this information while others may hide it (usually almost all of them gives it) then you can try to check and find how much is wagered on that website, if you can find the wagered amount you can calculate how much the house edge comes down to, which is usually 1% so find the wagered amount total and then calculate the 1% of it to find what the profit should be like.

After all that you calculate how much bankroll is and how much it earned and you divide it to each other and find how much you invested and calculate how much you should get. Of course, that is just wrong because this is casino and there could be wins and losses out of ordinary in big numbers plus the bankroll could change at any given day too.

Definitely the biggest profits from gambling are owners, not gamblers.  If you want to receive more, but you are not a gambler, then you can definitely invest your money in a specific resource and receive dividends from it.

Even though gambling owners are the ones who get maximum profit from gambling, but not everyone can become the gambling owners as it will involve a lot of setup and marketing cost.
We cannot make a new casino popular unless it is spread to the social media through marketing. You should have enough capital for all these expenses and then when there are good number of people wager on your site, the ROI will be good.

Due to the fact that there are no dates and exact numbers like the total amount invested its simply not possible.

I would take this as a starting point and write down everything in detail so you will ve able to calculate your statistics in the future. Excel is perfect for simple tasks like yours, you just need to prepare a sheet which contains columns for every relevant data, eg date of deposit, amount, played games, outcome, ...

Slightly off-topic, but this kind of thread reminds me that there currently isn't any sort of software that allows you to easily track gambling investment.
I mean, you have all these crypto portfolio apps, literally dozens of them, but not a single app to track investments on crypto casinos.

Excel is great, but it takes quite a lot of time to manually create and fill in the sheet.

Its depend on where you have invested and how they are going to return. ROI means return on investment, so when you have invested and after how many days they will return. Otherwise it can't be calculate. I think there is plan of ROI where you have invested. So calculate based on duration and interest.

However, I think this is best option for you mentioned by avikz,

Really? I'm a developer myself and could create such an app, but it's not something that I would do for free as a hobby project, because getting the precise stats of casino investments is just a slight curiosity for me (even though I'm investing in casinos for a long time, and plan to keep doing so).


I'm only interested in gains from casino, not from price changes (I also invest in alt bankrolls), that would be an unnecessary complication. Thanks for your offer, but I'm just looking for a general advice.

I think the problem in here are the casinos. I dont know any which allows you to get statistics (total investment, games played, ...) via an API. Such an access is crucial to be able to write a software for game trackings.