How much are delegators earning on their investment in bid-bots? The Steem blockchain has most of the data needed to make the calculations so let’s follow the numbers!
But not so fast. First, we need some definitions and some code. Any Steem account can delegate its Steem Power to another one and undelegate anytime with no previous notice. The account that delegates is the delegator and the account that receives the delegated funds is the delegatee. There is no credit risk for the delegator as she does not depend on the delegatee’s actions to get her money (Steem Power) back. It takes 7 days to get the undelegated funds back in the delegator’s account so delegators have some incentive to not undelegate so often.
In this short-term credit market, the delegated funds are the bid-bot’s debt. It is common for bid-bots to pay interest on their debt every day. This reduces how much a delegator would not receive if a bid-bot were to default on its interest payments.
The query to get all delegations ever made to one bid-bot account (see previous posts to learn about getting and processing the Steem blockchain info) is:
bidbot <- 'your_favorite_bid_bot'
sqltxt <- paste("SELECT * FROM TxDelegateVestingShares WHERE delegatee IN ('",bidbot,"')",sep="")
delegations_to_bot <- data.table(dbGetQuery(conn, sqltxt))
delegators <- unique(delegations_to_bot[,list(to=delegator)])
delegators[,isdelegator := 'yes']
sqltxt <- paste("SELECT [from],[to],amount,amount_symbol,memo,timestamp,type FROM TxTransfers (NOLOCK) WHERE [from] IN ('",bot,"')",sep="")
transfers_out <- data.table(dbGetQuery(conn, sqltxt))
setkey(transfers_out,to)
setkey(delegators,to)
transfers_out <- delegators[transfers_out]
transfers_out[,isdelegator := ifelse(is.na(isdelegator),'no',isdelegator)]
interest_payments <- transfers_out[isdelegator=='yes',list(int_usd=sum(usd)),by=list(delegator=to,year,month)]
setkey(delegation_balances,delegator,year,month)
setkey(interest_payments,delegator,year,month)
cash_flow <- merge(interest_payments,delegation_balances)
cash_flow_monthly <- cash_flow[delegation_usd > 0,list(interest_usd=round(sum(interest_usd)),delegation_usd=round(sum(delegation_usd))),keyby=list(year,month)]
cash_flow_monthly[,mrr := round(100*interest_usd/delegation_usd,4)]
cash_flow_monthly[,arr := round(100*(((1+(mrr/100))^12)-1),4)]
You have some very nice skills!
I have been noticing the ROI's dropping on http://isteemd.com/
There is also minnowbooster where people can delegate.
https://www.minnowbooster.net/market?direction=asc&sort=effective_price
Thanks!
Great to know about http://isteemd.com/ !
Nice work. Hard pressed to get 11% from your friendly bank. The big telling analysis is when the degradation curve brings the returns below bank rates.
Hi, @carrinm, there was an error in the conversion of delegations from VESTS to USD in the first version of this post. Sorry. Getting 24% from your friendly bank is going to be tough!
Very well written article, definitely gave me some insight to returns etc. I'm new here so this article was a great source of information!
Very detailed analysis, thanks a lot. Was looking for this analysis already on the net, but did not find anything. Hopefully things will turn back around and return will reach its high back again.
those are some nice skills. you have me motivated to do some experimenting with steem blockchain queries too. profits have declined for sure but they are still better than the alternative investment options. i have faith in steem.
You got a 28.45% upvote from @th3voter thanks to: @verodato!
Image Source cloudinary.com
This post has upvoted from @th3voter !For more information, click here!
You can earn daily profit by delegating SP to our bot, 100% of earnings paid out to delegators. To do so, click below:
30SP, 50SP, 100SP, 250SP, 500SP, 1000SP, 5000SP, 10000SP,
Custom Amount
Make sure you have at least 15 SP left on your account.
Couldnt happen to a nicer group of folks.
You got a 27.64% upvote from @redlambo courtesy of @verodato! Make sure to use tag #redlambo to be considered for the curation post!
You got a 6.70% upvote from @brupvoter courtesy of @verodato!
This post has received a 20.75 % upvote from @booster thanks to: @verodato.
This post has received a 19.92% UpGoat from @shares. Send at least 0.1 SBD to @shares with a post link in the memo field.
Interested to earn daily? Delegate Steem Power to receive 95% payout rewards. Use this link https://on.king.net/shares to delegate SP to @Shares. Join us at https://steemchat.com/ discord chat.
Support my owner. Please vote @Yehey as Witness - simply click and vote.
You got a 17.48% upvote from @upmewhale courtesy of @verodato!
Earn 100% earning payout by delegating SP to @upmewhale. Visit http://www.upmewhale.com for details!
Ok, so I get $.04 from posting every day. and from a bot I get $5.00. What do you think I should do. I can put in hours to write and get nothing. or put in nothing and get money. Money that goes to help people who need.
Can someone explain to me why does the APR% return increases with increase in value of STEEM.
This would imply that the circulation/creation of STU increases with increase in value , doesn't this mean it gets highly inflated as the price goes up? and subsequently creating a downward price pressure on STEEM Price.
quite similar to how the US government keeps printing more money when they need to.
Actually it was because of the runup in SBD, not STEEM. The reward functions adjust for changes in STEEM price (using witness price feeds). There is no similar compensation for changes in SBD premium (SBD price in excess of $1 floor).
But whenever there is bull run SBD prices will run up...
That depends on the maturity of the market.
Excellent news
you're doing great i like you information thanks to sharing with us
You're doing great i
Like you information thanks
To sharing with us
- sujon05
I'm a bot. I detect haiku.
Congratulations @verodato!
Your post was mentioned in the Steemit Hit Parade in the following category:
Hello verodato sir,You have provided an image to your blog by very good ideas. Which is the praise of the people. I also hope to write a blog like you and be as good as you like. Please help me.
@verodato informative for me
Your post is nice