Spreadsheet for income prediction

[Navara262]

Hi mista phi

Is it possible to make available your spreadsheet that populates income predictions?

Regards

[mistaPhi]

Hi mista phi

Is it possible to make available your spreadsheet that populates income predictions?

Regards

Hi Navara,

Are you referring to a spreadsheet that you've seen in a previous video? If so, what's the link to the video?

[Navara262]

Hi

Yes, I am still looking for the video with the link. Will send once I get hold of it.

Thanks

[Navara262]

Hi

This is the link to one of the videos with the spreadsheet.



Regards

[mistaPhi]

Ok, I see...

To clarify, that spreadsheet was used to document the history of how long it took for the Deposit Fee to be returned, followed by how long it took for the additional Credits to be returned. It wasn't used to forecast income, ROI, or APY; so the spreadsheet itself contained no internal calculations.

But the good news is that a lot (and I do mean a lot) has changed since the initial launch of the wallets, and some of these calculations are performed within the wallets and displayed on the dashboard. For example, the wallets now display the Annual Percentage Yield (APY). You'll see this percentage listed as Conv APY on your dashboard.

There's nothing available that provides income predictions because there are numerous ways to grow your Bitcoin and just about every wallet uses a different strategy. So it's not possible for the system to know beforehand what activities will occur within each wallet. It can only provide data & stats on what has occurred.

In that video, the purpose of the spreadsheet was to display how long it would take for all of the Credits to convert into Bitcoin based on the amount of Bitcoin deposited into the wallet. I was logging it in a spreadsheet just to display in future videos. But estimates of these numbers can now be calculated based on info that is readily displayed.

Let's say you have $10 in Credits and want to know how long it'll take for all of those Credits to convert. You can use the Conv Rate (which shows the amount of Satoshis that are converted into Bitcoin each hour), multiply that by 24 to get the amount converted per day, and divide that into the Credits balance. But the Conv Rate is quite dynamic and can change based on the a wallet's activities.

An easier way would be to view a history of the amount of Credits have occurred on a daily basis. You can view this by clicking on the icon next to BTC converted from Credits. This will display the amount of Credits (and the current fiat value) that have converted into Bitcoin each day. So if you have $10 in Credits and want to know how long it'll take to convert everything into BTC, consider some of the most recent Estimated Values listed (prior to the current day), and divide that number into the Credits balance. ie. If the Estimated Value is around 0.10 USD and you have $10 in Credits, it'll take about 100 days for all of the Credits to convert into Bitcoin ($10/0.10).

When considering these numbers to make future forecasts, know that many factors are used to determine the conversion rate for each wallet; and the calculations are based on both system-wide and wallet-specific resources and activities. Since the income received by the system (primarily through transaction fees) is used to generate returns for end users (through consistent Credit conversion), more transaction activity will naturally result in faster credit conversions and higher APYs; and vice versa. As such, wallets that perform activities that generate income for the system are rewarded while wallets that are only used to leech off of the system typically end up having slower credit conversions.

As you understand more of the built-in mechanics, you'll find that everything is designed to maintain a fair and balanced ecosystem. Regardless of WHEN a user enters or HOW MUCH Bitcoin is sent to a wallet, the system will never favor one wallet over another. So whales will never be able to exploit the system by depositing large amounts of Bitcoin. And as a result, the small fish, whales, and everyone in between are considered as equals in this protocol.

This may be information overload, but I hope it helps to give you a better perspective and understanding of the wallets. Keep the questions coming if anything is unclear.

[Navara262]

Well taken and understood. The explanation is helping a lot, greatly appreciated.

Regards

[DecentralEyes]

Just to add, my original wallet is converting 3 satoshis an hour.
Another is giving 2 and the rest 1.
I worked out that if I could get all 10 of my wallets converting 3 satoshis an hour, that's over £287 a month at current BTC prices !
So it is definitely worth the effort creating 10 wallets !!

Now, if I could get all 10 wallets converting 25 - 30 sats an hour, I could give up my day job and retire, but I don't see that happening ! LOL

[mistaPhi]

Just to add, my original wallet is converting 3 satoshis an hour.
Another is giving 2 and the rest 1.
I worked out that if I could get all 10 of my wallets converting 3 satoshis an hour, that's over £287 a month at current BTC prices !
So it is definitely worth the effort creating 10 wallets !!

Now, if I could get all 10 wallets converting 25 - 30 sats an hour, I could give up my day job and retire, but I don't see that happening ! LOL

You may want to check those number again DE. LOL

3, 2, and 1 sats per hour is a pretty low conversion that would typically apply to wallets with very small amounts of credits or to wallets that are being penalized for attempting to abuse permitted multi-wallet strategies.

So are you sure that's the rate that your wallets are converting? 3 sats an hour is 72 sats per day, which is around 0.05 pence per day at today's BTC price. And that's only £1.50 per month.

But the use of a multi-wallet strategy can be quite effective nonetheless... Which is why I try to share as much info about using the wallets as I can, like in this video:



But try running those numbers again to get an accurate depiction on how your wallets are actually performing... I don't want you quitting your job based on data that's not accurate :) And definitely buy Delayed Credits while this feature is available b/c that will help boost your BTC returns as well.

[DecentralEyes]

Yes, my mistake lol
I created my spreadsheet to convert everything to GBP !
My original wallet is converting 38.55 sats/hour

[Digi-Sol]

Yes, I'm getting 39.1 per hour on my original wallet. Lets hope we can crack the 40s

[mistaPhi]

Yes, I'm getting 39.1 per hour on my original wallet. Lets hope we can crack the 40s

There should be a gradual increase for the next day or two (at least) b/c there's more system revenue from the delayed credits that has to be fed into the Vault (which is sent once a day at the top of each morning). And since the system is always adjusting, these slight increases should continue for all wallets over the next couple of days.

Always a WIN