You are viewing a single comment's thread from:

RE: 140 AWESOME FRACKING SAUCE PEOPLE - WITNESS UPDATE

in LeoFinance12 days ago

Awesome! Thanks for the daily posts

Some suggestions:

  • BBH price feed : add header in top row of Excel table to help readability.
  • BBH Miner add daily spot apy % to get people to understand how attractive it is right now (if appreciated I can help with the formula)
  • could you explain the value proposition of BBHO? I understand and see it for BBHM and BBH but am still searching for it with BBHO - got some idea’s what could add value but firstly I am very curious of your vision!

Keep it going!!

Sort:  

1 - I can do that.
2 - Please help, tell me how you would like it to look: example.
3 - BBHO value proposition. That is a hard one. Like the Leo token for InLeo, BBHO is the native token of www.thebbhproject.com Tribe. It is more of a value caputure token. I guess as the Tribe becomes more popular, the tokens get spread around more, the daily reward pools gets halfed (every Bitcoin halfing). I add move things to the Tribe, it can increase the value of BBHO.

Tnx for the reply! Below both the explanation of the formula & the formula that you can put in excel! Let me know if it works for you!

To calculate the spot apy:

  1. Price of a miner (2 hive)
  2. Price of the reward (5x price of BBH as reward batch is 5 BBH)
  3. Chance of winning a reward on a given draw; 20x 1/ BBHM staked (or X/ if you want to calculate individual more accurate reward | x = individuals staked miners)
  4. The spot apy assumes all future draws have the same statistics (same chance and same value of rewards) this is oké for a simple calculation but only relevant if it is updated frequently because if either the price or the number of staked miners moves the apy changes.
  5. 24 draws a day , 365 days => expected reward in a year = expected reward of 1 draw x 8760 (draws a year)
  6. Apy = expected annual reward value / investment value * 100%

Combining these together to a formula:
= (1/ total miners staked * 5 * hive value of bbh * 20 * 8760) / price of miner * 100%

Simplified:
= (1/ total miners staked * 876000 * hive value of bbh) / hive value of miner * 100%

So to update the simplified formula you just need to update the a. Number of staked miners, b. Hive value of bbh c. Hive value of miner (which for now is constant at 2)

=(1/A2876000B2)/C2*100

Do I need the % sign after the 100? As it makes a big difference. lol

Assuming a2 , b2 and c2 are linked to the requested values you could remove the “*100” and set the field value on %.

But yeah times 100 gets you percentage if the remainder of the formula is correct.

One check did you include the * after A2 and before B2? So rather than
=(1/A2876000B2)/C2100 i would expect; =(1/A2876000B2)/C2100

What numbers did you enter and what is your result? I will calculate it myself with your numbers to double check 👍

A2 = 3130 total stakes miners
B2 = 0.00317 price in hive of 1 bbh today - release price
C2 = 2 Price in Hive of 1 Miner

so with 3130 staked miners, 2 Hive each, bbh price today of 0.00317 Hive. What do you get? Just to make sure I got it done correctly ;)

spot APY 44.36%

image.png

Awesome, that is what I got. Not bad APY ;)

Exactly not bad at all! The dynamic are interesting

  • More miners staked would mean lower APY
  • Highwr BBH price would mean higher spot APY

So we could assume the higher the drip day rewards the higher the value of the BBH and thus more reason to buy miners

To the last part no. Drip day rewards is my giving back to BBH holders and the drip day reward is now based on what our @thebbhproject Witness makes in a week.
I set the price of BBH every morning. It is equal to 1 Satoshi. Always has been always will be. It is my idea of a stable coin. Started that almost 4 years ago now.
But the more BBH you own, the higher percentage of dripday you will earn.

Ahh makes sense! Tnx for explaining!

Can I assume that this in not your main Hive account?