Nice post again, drilling it down even further, i like that the rules / ethics are becoming more clear especially around the splinterlands contest.
For myself i started a small application (opensource) where everybody can check it for them self.
This is in very early phase so expect some errors... but its free 🤣
Currently busy visualizing the SPL in game value.
Future extensions / TODO's
- Add hive engine as part of value overview.
- Cross check value again this post
Sneak peak can be found here any feedback is welcome.
Are using using a SQL query to calculate the rewards? I might be able to help.
just change to retrieval from hive to hive buzz api.
Started with directly from the hive beem library. But i do not understand how to calculate the author rewards and curation rewards without pulling all the history. So changed to hive buzz api to be inline with what azircon uses.
hope this is more accurate.
I really struggled to get it using python, whether it be via the Condenser API or the deprecated BEEM. All I got was bad figures and the documentation anD examples suck!
HIVE-SQL..
SELECT curation_rewards/1000.0, posting_rewards/1000.0 FROM accounts WHERE name = '{account}'It's periodically updated and added to the accounts table, so you are not trawling through data (which takes ages!).
You can call this via Python using the pypyodbc libary.
Cool will look into that library, i guess the stats from hive buzz are accurate enough for now.
Yeah, whatever works for you. Great to see a website, kudos for doing it!..and please do a post about this, your creation. I will make sure its seen.
Wow wow wow, what a great library much better than beem...
Jumping some hoops with odbc libraries but then 💪
For now only used for accounts but great experience, will be using this one more often😍
KE formula seems off
Its (Author HP + Curation HP)/Held HP
Thanks will look into that, i currently only have Curation HP / Held HP.
Author rewards are the rewards for the votes you place are they not?
Author HP is most important. For most content creators, that is usually the large number.
Look here:
https://hivebuzz.me/ranking
divided by
On that website, sort table by HP
Is that the gain in SPS or HIVE?
please check again change the calculations different source, this is in HIVE. thank for letting me know.
I think it is working!
Nice, thanks for the comparison.
WOW!
Is it possible for you to output a table with this headers please?!
A csv file will be enough.
HP Rank Account Creation Date Hive Power (HP) Curation Rewards (HP) Author Rewards (HP) Total Rewards (HP) Author + Curation HP (Author+Curation) / HP SPSP Balance CP DEC + DEC-B Validator Nodes Plots
Yeah that should be possible, i should be able to combine data in the end.
And i see is doe not do anything with DEC-B yet (for me this is already in the past 🤣)
yes, most people (except Vugtis) do not hold any DEC-B.
Please fix your KE formula though.
Should we add Collection Power in the monitoring? Who gets higher CP, means having more cards, has more commitment to the game than no CP at all.
since I am relentless! I like to have a button, that can let me download a CSV file on this data as a table! And then you are golden!
Do you know I copies 25 rows at a time manually for 100 pages of hivebuzz?!!
There is, but not yet your columns...
When this is working, it also should be no problem to give it a list of persons. Only the calculation time might increase to much todo it online, we have to see.
yes, but I like to have ALL persons
Extra columns are fine, I can delete or add, or make additional derivative calculation. But I want to download all users.
Define all users, all hive users 🙃?
For hive I do not expect any problems did not experiment it yet.
If I do a list of splinterlands users I will run in the backoff strategy of splinterlands and it will take a very long time.
Backoff strategy, when it kicks in i have to wait several minute before continuing, good API protection on SPL side.
i'm offline for while now 🛌
thank you for all your help!
You are a superstar!
PS. we can sort this tomorrow, next day, whenever!
LOL, yes
and I understand. If it not much of a problem for all hive users.
For SL users we can choose may be top 1000, 2000, 3000 SPS stakeholders?
New update this morning i have added the option to ask with multple users, then only a table is show... next is to add some spl data to the table this will probably makes it a lot slower but we will see :).
PS bee gentle i have not tested is yet with large list more than 10 🤣
it worked for 170 accounts!
took almost no time
can you do is space de-limited as well as comma?
because, if I copy from a spreadsheet column, and paste, they come in like this below
and obviously it fails.
I can obviously manually add comma, and then it works!