Show Posts
Since, I couldn't find this anywhere, I put together simple spreadsheet that has a table that shows the yield (% returns) on tickets based on ticket price and fee rate.
https://docs.google.com/spreadsheets/d/1IE1gXeYoJHU_NDw-9YMfS-nihg0D4NBpK98ecRKe1Pk/edit?usp=sharing
As you can see you would have been better off paying 1.6 DCR fee rate in the last cycle than 0.01 DCR fee rate on this cycle at 68.51 ticket price. Copy the spreadsheet and have fun with it. Would be cool if someone creates a webpage like this.
https://docs.google.com/spreadsheets/d/1IE1gXeYoJHU_NDw-9YMfS-nihg0D4NBpK98ecRKe1Pk/edit?usp=sharing
As you can see you would have been better off paying 1.6 DCR fee rate in the last cycle than 0.01 DCR fee rate on this cycle at 68.51 ticket price. Copy the spreadsheet and have fun with it. Would be cool if someone creates a webpage like this.
I've added some extra granularity around the low fees to reflect what you would be paying at higher ticket prices and removed some of the really high fees that we haven't seen. It shows that there is a sweet spot around 35-40 where the return is higher given that fees will be lower. I've also added some extra data showing how many tickets you'll get for a given amount of DCR and what the absolute return is assuming that all tickets vote. The red cells are those that are highly unlikely ticket price / fee combinations while the yellow area is around where the minimum fees tend to sit for low prices. You may or may not get in at those fees.
This analysis also doesn't take into account missed or expired tickets, although it's low enough that it shouldn't be a problem.
https://docs.google.com/spreadsheets/d/1SlQ6eKoJVpesAp-CxUev0csig6rhgV3yRRLA6bCdMbc/edit?usp=sharing
