It was great to see a lot of engagement in the post I wrote yesterday on the topic of Are Hive Reward Taxable Events. There was a lot information shared and interesting discussions in the comments. One of the interesting top comments was by @travelwritemoney, who described how certain rewards can be considered as taxable income as a counterargument. But also expressed how collecting this data may not be such an easy task if done manually.
All of the data is stored in the blockchain. There are also tools like HiveSQL that allows getting Hive blockchain data with few lines of SQL code. So I had to try. After a very busy day, I was motivated enough to dedicated few hours to some coding and add a new feature to Hive Librarian App - Hive Rewards. I just finished coding and deploying the updates. I can't guarantee it will be fully functional and all of the data will be accurate. I would recommend comparing the data manually before using any of it. The purpose of this was just to demonstrate it is possible to automate the process of collecting rewards data from Hive blockchain.
I used HiveSQL and hope to share the code in a near future if anyone is interested to get the data directly from HiveSQL. Since there aren't many HiveSQL users, I thought it would be better to add the feature to Hive Librarian. If you haven't used this app yet, you can do so by visiting the following link:
https://hivelibrarian.herokuapp.com
Click the Hive Rewards checkbox and it will show more input fields and buttons. You can choose the start and end dates for the needed data, account name, and how you would like the results ordered. While it is possible to get all rewards with a click of one button. I thought it could more useful if each reward type had its own button. We can get data for the following rewards:
- Claimed HBD: This is liquid HBD author claim for posts and comments.
- Claimed Hive: This is liquid Hive authors claim for posts and comments. It is rare that posts and comments get rewarded with liquid Hive, so for the most part it will not return anything. But liquid Hive does happen when the blockchain stops printing HBD due to the haircut and hbd/hive supply ratio rule.
- Claimed Hive Power: This is all claimed HP and includes both HP claimed for author's rewards and curations rewards.
- HBD Interest: This will return a list of HBD interest payments.
- Curation Rewards: Just as the name suggest, it will return list of curation rewards.
All values are in respective assets. The results will also display the dates for each reward payment. While I could have added a download as csv option, I intentionally didn't. I don't fully understand security measures for such situations, so I wouldn't want to ask anybody to download anything from this app. However, since results are displayed in a table format, they can easily be selected, copied and pasted to a spreadsheet. I tried and it worked just fine.
Give it a try, see if it works. If you find any errors please let me know in the comments or elsewhere. If you have suggestions to improve, feel free to share in the comments. Hive Librarian has other useful features too. If this is first time you are using it, feel free to try other features as well. Thank you.