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:
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
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
Ok, thanks! Wrote about it and recomended your work: https://leofinance.io/@klausklaus/cubdefi-optimal-compounden-cubdefi-optimally-compound
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
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) :
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: