RE: Dtube in 2018 – Data on Activities, Posts, Votes, Payouts and Top Dtubers
Thank for the review @crokkon! You always trough some challenge in the comment :) I'm trying to keep up with those.
I must say doing this analysis in excel was quite a challenge since at occasions there were more than a million rows and excel was slow and lagging. Especially on the post data. Maybe I need to look at some different tool.
The number of comments went from around 300 daily average to a 700-800 in the end of the year. This increase happened on 21 and 22 second December. I really don't know what happened there. I double checked the data and it is accurate. Maybe the holidays made this happened, since this was the start of the weekend :).
About the daily vote values and payouts, I assigned the SP of Dtube for each date, and then calculate the individual votes, according to the weight. I used the daily SP of Dtube, multiplied with 0,00756447%, and multiplied again with the weight of the vote. The percent I used theoretically is for 95% of the Dtube vote. I went with assumption since not all the time Dtube votes with 100% that is for sure.
After this I made the daily sums of the votes. It isn't an 100% accurate way, since not all the time Dtube votes with 95%, and the rewards isn't just in STEEM, but it is close enough I think. Also when I think about it now, I should of removed the 25% curators reward. If you prefer I will make the correction.
haha, I'm just a curious mind - no need to edit the post :) I can image that this comes close the what Excel can handle. Paulag, abh12345 and others use PowerBI - maybe that's an option for you as well? I mostly script it with python.
I think the vote value calculation is not fully correct. The STEEM-equivalent value of the votes varies with several factors even if the SP and the VP is fixed. The most accurate value I can think of right now is to use the
author_rewardfield of the Posts/Comments where dtube voted on and calculate the tdube contribution thereof by the fraction of the dtube vote rshares wrt to the sum of all vote rshares on that post.