RE: Tutorial: Get the value of your steemit earnings, Part #2 - Calculate Steem Power

You are viewing a single comment's thread from:

RE: Tutorial: Get the value of your steemit earnings, Part #2 - Calculate Steem Power

View the full context

crokkon (68)in #steemdev • 7 years ago

Hi @schererf, 2017 my first year on taxing crypto income, so I'm following your tutorials closely! :)
The steem_per_mvest can also be queried from the blockchain. The fill_vesting_withdraw operations contain the numbers of [X] VESTs withdrawn into [Y] SP. However, this requires a query script, there's no ready to use API that I know of.

7 years ago in #steemdev by crokkon (68)

Sort:

schererf (64) 7 years ago

Thanks a lot, that sounds very interesting. Can you share an example for this query script?

$0.00

[-]

crokkon (68) 7 years ago

Sure, I did it for another application a day ago in python for the time span from Jan 1st 2018 to yesterday:

from steemdata import SteemData
import datetime as dt

s = SteemData()
timerange = {"$gt": dt.datetime(2018, 1, 1, 0, 0, 0)}
ops = list(s.Operations.find({'type':'fill_vesting_withdraw',
                                'timestamp': timerange}))
rates = []
dates = []
for r in ops:
    deposited = float(r['deposited']['amount'])  # Steem
    withdrawn = float(r['withdrawn']['amount'])  # Vests
    rate = deposited / withdrawn * 1e6
    date = r['timestamp']
    # [few filters hidden for simplicity here]
    rates.append(rate)
    dates.append(date)

The outliers are cases where withdraw vesting routes with less than 100% were used, so some of the Vests from one account went as STEEM or SP into another account. I think the upper limit of these values per day/hour/... should give a reasonably precise value.

$0.08

1 vote

[-]

schererf (64) 7 years ago

Cool, thank you.
But if I understand it right, SteemData is a MongoDB server and therefore the data not comes directly from the blockchain.
https://steemit.com/steemdata/@furion/getting-started-with-steemdata

$0.00

[-]

crokkon (68) 7 years ago

Yes, that's a MongoDB server. It contains the same information as on the blockchain, but it's magnitudes faster than streaming the blocks directly from the blockchain. If you want to get it directly from the blockchain, one could think about streaming a couple of full blocks around each reward claim to catch a fill_vesting_withdraw operation close by. But your steemdb API approach is in that case probably simpler...

$0.08

1 vote

STEEM 0.19

TRX 0.16

JST 0.034

BTC 64333.84

ETH 2760.35

USDT 1.00

SBD 2.65

RE: Tutorial: Get the value of your steemit earnings, Part #2 - Calculate Steem Power

Coin Marketplace