How To Retrieve Historic Vote Payout Values From Steem? Anyone Know? by ura-soul

steem · @ura-soul · Jan 21 '18

$12.70

How To Retrieve Historic Vote Payout Values From Steem? Anyone Know?

***I am currently in the process of coding a proof of concept for the [generosity rank algorithm](https://steemit.com/utopian-io/@ura-soul/steem-improvement-a-generosity-rank-algorithm-a-method-of-increasing-post-quality-that-promotes-a-reduction-of-payout-pool) for Steem that I posted about recently.... But I'm stuck - how to calculate the value of votes historically?***

![steemsql](http://steemsql.com/wp-content/uploads/2018/01/steemsql-logo-transparent_100x100.png)

This first version of the algorithm is just for testing and it is likely that the finished article will be quite different to the version I originally posted about - however, I can't do much to improve it if I can't access the data needed to make it work. I am using the steemSQL system from @arcange to manipulate and access the Steem blockchain data and I have been able to do that successfully but I need to know specifically what formulas to use to calculate the value of any historic vote - the value it would have held at the time it was made.  As far as I can see, that data isn't easily available in the blockchain/database - although I could just be missing it.

I found [a post](https://steemit.com/bisteemit/@paulag/how-to-calculate-the-worth-of-any-steemit-vote-steemit-business-intelligence) from @paulag that clarifies the logic and fields used to calculate the value of a vote in the present moment (e.g. a vote that is about to be cast) - but nothing so far that explains how to calculate historic values. I know this can be done though since the Steemit browser extension by @armandocat does it - but that user profile has been inactive for 3 months (and the browser extension is broken too). Maybe the source code for the extension is on Github? I haven't found it as yet.

So in short - if you know how to access this data - whether using the TxVotes table in [SteemSQL](http://steemsql.com/database-diagram/) or though some other method - do let me know! Thanks!


Wishing you well,

Ura Soul

<center>
![signature](https://i.imgur.com/MusE9nI.gif)
</center>
<center>Vote @ura-soul for Steem Witness!</center>
<center>
[![vote ura-soul for witness](https://steemitimages.com/0x0/https://i.imgur.com/VxiJPlK.gif)](https://steemit.com/~witnesses)
[View My Witness Application Here](https://steemit.com/witness-category/@ura-soul/ura-soul-witness-application)
</center>
<center>
[![ureka.org](http://i.imgur.com/AzZb55n.jpg)](https://www.ureka.org)
</center>

👍 ausbitbank, teamsteem, ura-soul, surfyogi, majes.tytyty, cryptokeepr, drpuffnstuff, innerverse, pathforger, lewis831, jockey, amvanaken, jschindler, aaronmda, klevn, frmn, gurugnu, farkparck, muhammadbadawi

`post_id`	27,086,755
`author`	ura-soul
`permlink`	how-to-retrieve-historic-vote-payout-values-from-steem-anyone-know
`category`	steem
`json_metadata`	"{"format": "markdown", "links": ["https://steemit.com/utopian-io/@ura-soul/steem-improvement-a-generosity-rank-algorithm-a-method-of-increasing-post-quality-that-promotes-a-reduction-of-payout-pool", "https://steemit.com/bisteemit/@paulag/how-to-calculate-the-worth-of-any-steemit-vote-steemit-business-intelligence", "http://steemsql.com/database-diagram/", "https://steemit.com/~witnesses", "https://steemit.com/witness-category/@ura-soul/ura-soul-witness-application", "https://www.ureka.org"], "app": "steemit/0.1", "tags": ["steem", "steemsql", "steemdev", "steemit", "technology"], "users": ["arcange", "paulag", "armandocat", "ura-soul"], "image": ["http://steemsql.com/wp-content/uploads/2018/01/steemsql-logo-transparent_100x100.png"]}"
`created`	2018-01-21 17:28:54
`last_update`	2018-01-21 17:28:54
`depth`	0
`children`	13
`net_rshares`	1,109,699,533,123
`last_payout`	2018-01-28 17:28:54
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	11.167 SBD
`curator_payout_value`	1.528 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	2,450
`author_reputation`	374,397,838,982,381
`root_title`	"How To Retrieve Historic Vote Payout Values From Steem? Anyone Know?"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000
`author_curate_reward`	""

properties (23)vote details (19)

voter	rshares	pct
teamsteem	169,902,981,885	1%
ausbitbank	497,616,218,264	5%
jschindler	4,171,301,985	100%
ura-soul	131,817,849,333	100%
innerverse	22,859,220,774	100%
aaronmda	1,805,123,071	46%
surfyogi	109,489,454,085	20%
drpuffnstuff	25,585,406,215	21%
jockey	16,831,189,095	100%
amvanaken	4,312,824,453	22%
lewis831	17,443,914,828	100%
pathforger	17,617,375,259	100%
cryptokeepr	42,814,277,400	20%
majes.tytyty	44,868,070,722	7%
klevn	1,669,965,242	100%
muhammadbadawi	61,722,000	10%
farkparck	86,052,937	100%
frmn	556,098,971	100%
gurugnu	190,486,604	100%

@rockykhan · Jan 21 '18

you create a great post..i like it...i hope everybody like your post...thanx for shear it

properties (22)

`post_id`	27,087,120
`author`	rockykhan
`permlink`	re-ura-soul-how-to-retrieve-historic-vote-payout-values-from-steem-anyone-know-20180121t173107490z
`category`	steem
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steem"]}"
`created`	2018-01-21 17:31:03
`last_update`	2018-01-21 17:31:03
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2018-01-28 17:31:03
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	89
`author_reputation`	39,104,093,461
`root_title`	"How To Retrieve Historic Vote Payout Values From Steem? Anyone Know?"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@frmn · Jan 21 '18

$0.37

Should not we ask the person who made it?

👍 ura-soul

`post_id`	27,087,593
`author`	frmn
`permlink`	re-ura-soul-how-to-retrieve-historic-vote-payout-values-from-steem-anyone-know-20180121t173343964z
`category`	steem
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steem"]}"
`created`	2018-01-21 17:33:54
`last_update`	2018-01-21 17:33:54
`depth`	1
`children`	2
`net_rshares`	32,447,470,605
`last_payout`	2018-01-28 17:33:54
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.362 SBD
`curator_payout_value`	0.006 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	41
`author_reputation`	73,564,225,445
`root_title`	"How To Retrieve Historic Vote Payout Values From Steem? Anyone Know?"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
ura-soul	0 B		32,447,470,605	25%

@ura-soul · Jan 21 '18

SteemSQL is just a database version of the Steem blockchain. The documentation for the blockchain is not the best, so yes it is good to ask the people who created it all but they are very busy and hard to reach sometimes.

properties (22)

`post_id`	27,088,173
`author`	ura-soul
`permlink`	re-frmn-re-ura-soul-how-to-retrieve-historic-vote-payout-values-from-steem-anyone-know-20180121t173726241z
`category`	steem
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steem"]}"
`created`	2018-01-21 17:37:27
`last_update`	2018-01-21 17:37:27
`depth`	2
`children`	1
`net_rshares`	0
`last_payout`	2018-01-28 17:37:27
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	221
`author_reputation`	374,397,838,982,381
`root_title`	"How To Retrieve Historic Vote Payout Values From Steem? Anyone Know?"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@frmn · Jan 22 '18

Yes thanks for information 
Maybe I do not know yet because I'm new here

properties (22)

`post_id`	27,307,543
`author`	frmn
`permlink`	re-ura-soul-re-frmn-re-ura-soul-how-to-retrieve-historic-vote-payout-values-from-steem-anyone-know-20180122t154728035z
`category`	steem
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steem"]}"
`created`	2018-01-22 15:47:45
`last_update`	2018-01-22 15:47:45
`depth`	3
`children`	0
`net_rshares`	0
`last_payout`	2018-01-29 15:47:45
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	72
`author_reputation`	73,564,225,445
`root_title`	"How To Retrieve Historic Vote Payout Values From Steem? Anyone Know?"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@gurugnu · Jan 21 '18

$0.13

You do work hard :)

👍 ura-soul

`post_id`	27,089,212
`author`	gurugnu
`permlink`	re-ura-soul-how-to-retrieve-historic-vote-payout-values-from-steem-anyone-know-20180121t174357104z
`category`	steem
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steem"]}"
`created`	2018-01-21 17:43:57
`last_update`	2018-01-21 17:43:57
`depth`	1
`children`	1
`net_rshares`	11,491,812,505
`last_payout`	2018-01-28 17:43:57
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.126 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	19
`author_reputation`	136,283,865,883
`root_title`	"How To Retrieve Historic Vote Payout Values From Steem? Anyone Know?"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
ura-soul	0 B		11,491,812,505	9%

@ura-soul · Jan 21 '18

I am very busy, yes! At some point I will stop and rest :)

👍 gurugnu

`post_id`	27,089,810
`author`	ura-soul
`permlink`	re-gurugnu-re-ura-soul-how-to-retrieve-historic-vote-payout-values-from-steem-anyone-know-20180121t174741818z
`category`	steem
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steem"]}"
`created`	2018-01-21 17:47:42
`last_update`	2018-01-21 17:47:42
`depth`	2
`children`	0
`net_rshares`	175,124,781
`last_payout`	2018-01-28 17:47:42
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	58
`author_reputation`	374,397,838,982,381
`root_title`	"How To Retrieve Historic Vote Payout Values From Steem? Anyone Know?"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
gurugnu	0 B		175,124,781	100%

@fechaugger · Jan 21 '18

$0.39

I think you need to look at the **Steemd** source code.

From their you can scrape people's account history, and thus their posts. 

Filter out all of the 'follow', 'authored',  're-steemed' and 'replied' messages. 

At that point, you should be left with a list with only outgoing votes and author/curation rewards. 

____

*That would be the best strategy I can come up with right now.*

👍 ura-soul, fechaugger

`post_id`	27,092,576
`author`	fechaugger
`permlink`	re-ura-soul-how-to-retrieve-historic-vote-payout-values-from-steem-anyone-know-20180121t180328315z
`category`	steem
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steem"]}"
`created`	2018-01-21 18:03:27
`last_update`	2018-01-21 18:03:27
`depth`	1
`children`	1
`net_rshares`	33,834,423,038
`last_payout`	2018-01-28 18:03:27
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.326 SBD
`curator_payout_value`	0.060 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	388
`author_reputation`	442,135,671,869
`root_title`	"How To Retrieve Historic Vote Payout Values From Steem? Anyone Know?"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000
`author_curate_reward`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
ura-soul	0 B		24,335,602,953	19%
fechaugger	0 B		9,498,820,085	100%

@ura-soul · Jan 21 '18

As far as I am aware, the Steemd system doesn't record historic payout levels, relative to the reward pool at the time the post paid out - at least not visibly in the UI. The only place I've seen that data used so far is in the browser extension I mentioned - but I'll bare  in mind the idea of looking at the Steemd source too.

properties (22)

`post_id`	27,095,699
`author`	ura-soul
`permlink`	re-fechaugger-re-ura-soul-how-to-retrieve-historic-vote-payout-values-from-steem-anyone-know-20180121t182202617z
`category`	steem
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steem"]}"
`created`	2018-01-21 18:22:03
`last_update`	2018-01-21 18:22:03
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2018-01-28 18:22:03
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	328
`author_reputation`	374,397,838,982,381
`root_title`	"How To Retrieve Historic Vote Payout Values From Steem? Anyone Know?"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@farkparck · Jan 21 '18

Sinceramente estas haciendo un gran trabajo.

properties (22)

`post_id`	27,093,435
`author`	farkparck
`permlink`	re-ura-soul-how-to-retrieve-historic-vote-payout-values-from-steem-anyone-know-20180121t180832278z
`category`	steem
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steem"]}"
`created`	2018-01-21 18:08:33
`last_update`	2018-01-21 18:08:33
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2018-01-28 18:08:33
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	44
`author_reputation`	110,492,635,684
`root_title`	"How To Retrieve Historic Vote Payout Values From Steem? Anyone Know?"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@ura-soul · Jan 21 '18

$1.36

Well, I found [this post](https://steemit.com/steemdev/@jfollas/write-a-steemit-web-app-part-12-voting) that goes some way to answering the question, but the actual formula is still incomplete.. I continue!

👍 ura-soul, gurugnu

`post_id`	27,102,350
`author`	ura-soul
`permlink`	re-ura-soul-how-to-retrieve-historic-vote-payout-values-from-steem-anyone-know-20180121t190118567z
`category`	steem
`json_metadata`	"{"app": "steemit/0.1", "links": ["https://steemit.com/steemdev/@jfollas/write-a-steemit-web-app-part-12-voting"], "tags": ["steem"]}"
`created`	2018-01-21 19:01:15
`last_update`	2018-01-21 19:01:15
`depth`	1
`children`	1
`net_rshares`	119,121,532,385
`last_payout`	2018-01-28 19:01:15
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	1.358 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	206
`author_reputation`	374,397,838,982,381
`root_title`	"How To Retrieve Historic Vote Payout Values From Steem? Anyone Know?"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000
`author_curate_reward`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
ura-soul	0 B		118,974,058,885	100%
gurugnu	0 B		147,473,500	100%

@gurugnu · Jan 21 '18

Well above my pay grade.....Too technical for me but I do hope you find your answer :) BE LOVE BE TRUE FOR THAT IS YOU.

properties (22)

`post_id`	27,131,688
`author`	gurugnu
`permlink`	re-ura-soul-re-ura-soul-how-to-retrieve-historic-vote-payout-values-from-steem-anyone-know-20180121t221156116z
`category`	steem
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steem"]}"
`created`	2018-01-21 22:11:57
`last_update`	2018-01-21 22:11:57
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2018-01-28 22:11:57
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	119
`author_reputation`	136,283,865,883
`root_title`	"How To Retrieve Historic Vote Payout Values From Steem? Anyone Know?"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@paulag · Jan 21 '18

$0.29

this is the one piece of information I was not able to get my self.  I have found all of the data except the users voting power at time of vote.  let me know if you do find this.  But it has been confirmed to me that it is not in steemsql

👍 ura-soul

`post_id`	27,112,045
`author`	paulag
`permlink`	re-ura-soul-how-to-retrieve-historic-vote-payout-values-from-steem-anyone-know-20180121t200214693z
`category`	steem
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steem"]}"
`created`	2018-01-21 20:02:15
`last_update`	2018-01-21 20:02:15
`depth`	1
`children`	1
`net_rshares`	26,364,008,969
`last_payout`	2018-01-28 20:02:15
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.276 SBD
`curator_payout_value`	0.018 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	238
`author_reputation`	224,445,607,823,384
`root_title`	"How To Retrieve Historic Vote Payout Values From Steem? Anyone Know?"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
ura-soul	0 B		26,364,008,969	24%

@ura-soul · Jan 21 '18

I see, have you found a way of accessing reward pool values for specific timestamps? I think I have only seen the function so far that returns it for the present moment. 
[this post](https://steemit.com/steemdev/@jfollas/write-a-steemit-web-app-part-12-voting) appears to give some parts of the answer - I need to learn more about Rshares.

properties (22)

`post_id`	27,113,503
`author`	ura-soul
`permlink`	re-paulag-re-ura-soul-how-to-retrieve-historic-vote-payout-values-from-steem-anyone-know-20180121t201212215z
`category`	steem
`json_metadata`	"{"app": "steemit/0.1", "links": ["https://steemit.com/steemdev/@jfollas/write-a-steemit-web-app-part-12-voting"], "tags": ["steem"]}"
`created`	2018-01-21 20:12:06
`last_update`	2018-01-21 20:12:06
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2018-01-28 20:12:06
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	339
`author_reputation`	374,397,838,982,381
`root_title`	"How To Retrieve Historic Vote Payout Values From Steem? Anyone Know?"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000