Optimize Your CUB Farming/Staking **UPDATED** **SECOND QUICK UPDATE** **FINAL UPDATE ADDED**

in LeoFinance4 years ago (edited)

Update

I've updated the spreadsheet to have more hours to compare, it turns out my optimal time is 3 hours for my Den stake and 2 hours for my Pool stake. Make sure you update your sheet after each compound to stay up-to-date. End Update

Quick Update

With today's (3/15/21) drop in Cub production, my timings have changed. Later tonight, I will update the sheet with more time-frames so that you can get a better feel for optimal time. End Update

Final update

I have expanded the sheet to calculate up to 36 hours. This should service the majority of users. Thanks for the positive feedback, guys! End Update

You know what's fun? Watching the gains that the early adopters of CUB Finance are claiming.

One of the old sayings I used to hear was "Compound early and often". But what if it turns out that's not true? How often should you harvest and stake? It turns out that the time-frame is different for everyone. Let's take a look at the tools you'll need to maximize your gains! Special Thank you to https://leofinance.io/@tradewatchblog for providing the spreadsheet and walking me through the process. Make sure to give him some love on his blog.

Tools Needed

Outside of having some tokens staked in either the Liquidity Provider pools or in the Den, we're going to need two things. The first is This website: https://howmuchismylp.com/. In the MasterChef address box you will need to enter 0x227e79C83065edB8B954848c46ca50b96CB33E16, connect your wallet and you'll have a display like so:

This will give us our somewhat current USD total that we have invested. (It seems to be off by ~5 minutes for me)

With these dollar amounts, we can now find what harvesting time-frame is optimal for us.


The second tool, and the one we're here for is this spreadsheet: NOTE: You will have to save as a copy to be able to edit the fields

https://docs.google.com/spreadsheets/d/18KfOZDGWT9N5MjhOxFff2YJ8PvTueXpTpYj_H4EdAX4/edit?usp=sharing

This defaults to some pre-filled numbers which we will have to change. We are looking at these three areas circled.

In Value Locked box, we need to change that number to our dollar amount from the howmuchismylp.com site. In the example above we have a Pool stake amount of 11226.52 and a Stake amount of 32164.73. For this example, we'll use the Stake amount.

After entering that into the first box, we'll need our daily return percentage. We can find that in the Farming/Den areas at https://cubdefi.com/

Since we are looking at straight staked CUB, we'll click on the little calculator as seen here:


20210313 10_16_03Cub Finance.png

It shows us that our current Daily Return rate is: 3.47% we'll pop that number into the Daily Return box, and since we're looking at a Den, we'll set that number to 0

Our output is this:

Now. Let's look at the results!

So Let's move our attention to the far left and right boxes to see our results!

The first box shows us if we're looking at Hourly compounding or 4, 8, or 12 hour intervals.

The far right box shows us the net gain or loss that we can expect if we compound at those times. Losses will be in parentheses (5.xx)

Going by the chart we can see that in this example compounding every 4 hours will be the most beneficial to us! If we compound every hour instead of hourly, we're leaving $2.90 on the table, if we wait until 8 hours, we've lost $2.40, and if we wait 12 hours, well, that just hurts even more.

And there you have it! The tools you need to make the best moves to increase your Cubbies! You may want to play around with the Avg TX fee to dial this in even further. Remember that these values are in US dollar, so the .3 in the screenshots represents 30 cents.

Good luck and Happy Staking!!!

Posted Using LeoFinance Beta

Sort:  

CUB inevitable! 🔥🚀

Posted Using LeoFinance Beta

Nice spreadsheet i will check this out

Posted Using LeoFinance Beta

Thanks for the info, Shane. Very useful!

Posted Using LeoFinance Beta

Interesting. When I fill out the fields (and I think I've filled them out right) it shows me in negative profit on all time frames (p.s. I'm working with less than $1000 Value Locked).

Does that sound right? Does it become more difficult to profit with smaller collateral over time?
Sry for newbie questions, this is my first time in Defi farming and I want to get it right, also get out now if it is no longer profitable with the levels of $value I can afford to stake.

Cheers Shane

Posted Using LeoFinance Beta

Hi o/
I made a new version for people with low value locked, checking when is it more efficient to compound compared to once per week. You can find it here:
(just modify the green box)
https://docs.google.com/spreadsheets/d/1nuU6VBUyb61CmhmYEIqsqPFn7dxLs3uzlLhNi_qdLWs/edit?usp=sharing

Posted Using LeoFinance Beta

Thanks for the updated sheet @tyrnis. I was just changing the hours manually on the original, but always nice to have a better formatted copy. 😃

Posted Using LeoFinance Beta

I'm glad this is useful :)

Posted Using LeoFinance Beta

Hi, what does Net Gain exacly mean?

Posted Using LeoFinance Beta

Net Gain is what you are going to gain over one day/week/month if you compound every X hours comparing to compounding once a day/week/month. This depends mostly on the gas fees and on the locked value you have in the dens/farm.

Posted Using LeoFinance Beta

It's definitely possible. If you want to send me your numbers in a DM on Discord, I can double check the, Shane#1517

Posted Using LeoFinance Beta

Thanks for the offer.

But tradewatchblog explained what I did suspect actually, that for smaller amounts it is better to just claim once/day.

:)

Posted Using LeoFinance Beta

Hey @raj808 yes that's probably right, it just means compound once per day - there's no advantage to compounding more frequently than that with your current holdings.

It's important to note that in any of those scenarios you're not actually making a loss, you just make slightly less money than if you compounded once per day.

The tool is not designed to tell you whether or not CubDefi is profitable - no matter how big your stake is, CubDefi is extremely profitable!

Posted Using LeoFinance Beta

Thanks for the update. I suspected that it was still profitable for lower amounts and this spreadsheet wasn't showing total end profit as it were.

Posted Using LeoFinance Beta

Wow, this is awesome! I have only been compounding like every 24 or 48 hours. Because of the $0.40 to $0.50 gas fee. But I have a lot less staked, only like 65 CUB.

Posted Using LeoFinance Beta

wow nice investment! :)

Posted Using LeoFinance Beta

toruk_washere_new3leo.jpg

More info why you see this.

Posted Using LeoFinance Beta

Oh Thanks! I was actually trying to figure this out. Very helpful!

Posted Using LeoFinance Beta

Awesome!

I was just wondering how I could work out how often I should compound my CUB. Thanks for this very detailed explanation!

Posted Using LeoFinance Beta

I can't seem to be able to edit the fields. Probably operator error. :) Any suggestions?

Posted Using LeoFinance Beta

I would bet that you need to save a copy first. I believe it's locked until then. I should add that to the post.

Posted Using LeoFinance Beta

Thank you! I will give that a try tomorrow. Looks like a great tool.

Posted Using LeoFinance Beta

When calculating this currently, does it go by current apr or the apr when you locked in the LP?

The APR is dynamic, so the current APR is what you're getting.

Awesome little tool! Doing nice in the den!

Posted Using LeoFinance Beta

So I just calculated out the best time to harvest and compound my earnings, this link should help anyone trying to figure out when , https://online-calculator.org/14-hours-from-now Just change the link to how many hrs away you need to harvest and it will tell you the time/date.

@swelker101 Hey hows it going? Can we chat about the spreadsheet, and how I can update it.

Damn, the tools you guys come up with are so awesome! If this were the real world, you'd have to pay like $49.99 for this stuff. Here's it's free for a few upvotes. And even those aren't actually "required". This is really helpful. Thank you!

Posted Using LeoFinance Beta

Cub is going well..... really enjoying it on there!

Posted Using LeoFinance Beta

Love it, thank you! For people like me who forget how often to harvest, I added a column "Harvest at" which shows what your CUB earned should be when you harvest. That way you can watch that rather than the time.

Only downside is that you need to set the CUB price on the sheet.

https://docs.google.com/spreadsheets/d/1ibSnGK9Z18_ar52ayT695zI71LXSguSfXu44vBMtMbw/edit?usp=sharing

Posted Using LeoFinance Beta

What a great tool!

It kind of confirms what my rough maths told me - which for me is harvesting about 3 times per day.

Cheers!

Posted Using LeoFinance Beta

Super helpful spreadsheet. I guess I compounded too often before. Time to make up for it now!

Posted Using LeoFinance Beta

This is great news.

Posted Using LeoFinance Beta

Thanks for the great tool!

Posted Using LeoFinance Beta

Excellent work. Well thought out and explained. We don't give much thought to the fact that we can lose value if we compound for "to long" Thank you.

Posted Using LeoFinance Beta

Just getting and staking CUB was a headache for me. This looks way too complicated, but thanks for sharing. How hard would it be to make an app with a little reminder sound when the best time to compound is?

Posted Using LeoFinance Beta

Nice, but maybe 4% fee is missing?

Posted Using LeoFinance Beta

Well thank you for this neat little tool.

Posted Using LeoFinance Beta

Does it make a difference if I only have 75 Cub ? Just hit compound once a day ? Or when I have accumulated 3 Cub or so...

Posted Using LeoFinance Beta

Congratulations @swelker101! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) :

You distributed more than 19000 upvotes.
Your next target is to reach 20000 upvotes.

You can view your badges on your board and compare yourself to others in the Ranking
If you no longer want to receive notifications, reply to this comment with the word STOP

Check out the last post from @hivebuzz:

A successful meetup and its commemorative badge