SteemReports - Steem Financial Accounts Summary (more accurate fiat conversions)

in steemdev •  2 months ago

When I created the original 'Financial Accounts Tool', I had thought that daily average price data would be sufficient for fiat conversions (for tax purposes). It has since become clear to me that this probably isn't true though, especially since we're dealing with a blockchain that confirms transactions in just a few seconds.

The new version - which looks identical - uses hourly averages. This should instantly improve the accuracy of the fiat conversions, and from now on the database is now also collecting minutely data. Future transaction conversions should therefore be much more accurate.

As usual though, the use of this data is at your own risk, and I make no guarantees of its validity. Please let me know if you find any problems with it.


financial-tool-update.png
http://www.steemreports.com/financial-accounts-summary/

I plan to make a few similar tools, based around this data, which will hopefully make it easier to find and visualise the data you're looking for.

A more technical explanation follows, so feel free to skip if you're just a casual user of the tools. :)


I found a source of hourly and minutely data at cryptocompare.com. I would like to have simply collected and used the minutely data, but this is only available for the previous 7 days, so instead I'm using a combination of interpolated hourly averages (to create synthetic minutely data), and the true minutely data for recent days, and into the future.

Because VESTS are not traded on exchanges they don't have a direct fiat conversion rate. This needs to be created using the STEEM to VESTS ratio. In the previous version of the tool, I used the present ratio for transactions across all time, but I have also improved the way this is calculated, again by interpolating between historic and the current rate.

I found some a couple of historic rates (since January 2017), including this from @timcliff, and have assumed a linear gradient for this data.

EDIT: The linear assumption doesn't hold perfectly, so there are differences of a few pence in some large totals. I think this is within the bounds of acceptability, but will continue to improve the accuracy over time.

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  trending

Does it count the full year yet? I see transactions starting March but not earlier.

·

I'm afraid it doesn't. I had to decide a time to start based on storage requirements, and the time it takes to load the data and chose March/April 2017. I'm also still working on making some more useful views of the data, and by the time we have a year worth of data it should be easier to use.

·
·

Oh, okay... Do you have any idea how I could get the previous months' data out?

·
·
·

How far back do you need the data to go?

·
·
·
·

Sorry, I missed your reply.

I would be glad if I could get it for the whole past year. It would be way easier to make tax declarations if I had the whole history at hand.

·
·
·
·
·

Hi, If it's not too late for you, the report now shows all of 2017 as promised:
https://steemit.com/steemdev/@steemreports/improved-financial-accounts-tool

·
·
·
·
·

I plan on doing more work on this within the next month, and I might extend it to the start of 2017 then if it's not too hard. The only way I know is to use an API and download the data from cryptocompare.com, but there's quite a bit involved in getting hourly data for the entire period.

·
·
·
·
·
·

Hey that's good news! :) Thanks a million!

These tools are so damn handy, thank you for all your work.

Am I imagining things, or does it count the OUT as a positive. So 500 in + 500 out ends up being $1000 instead of 0?

·

Yes. Due to a limitation of the library I used, the totals don't really make sense (as you suggest). I could make the OUTs into negative numbers so the totals would be right, but unfortunately that would cause some confusion too.

·
·

Cool, thanks for replying and confirming that I want in fact losing my mind.

for what it's worth,I think negative numbers would be fine

I'm pretty sure @freebornangel hasnt transfered in that much, but the others numbers dont seem out of line.

·

Thanks for your continued help with getting these issues ironed out!

I see you've been powering up to other accounts which I hadn't provided for, could this be the cause of the difference, or is it something else too do you think?

·

It doesn't look like @freebornangel has transferred in much from the figures I'm looking at here:

Could you have filters wrong? They're quite confusing in this state, which is why I'll make some standard views in coming days/weeks.

·
·

Correct, some time long ago i transfered in 105sbd, and maybe brought some back from poloniex, but i havent put more than that in.
I will look again when i am on a desktop.

I own both accounts.

Those dollar amounts are current and not contemporary to the transfer?

·
·
·

The dollars amounts are contemporary to the respective transfers - based on the hourly historic conversion rates.

·
·
·
·

I should have time to number crunch this weekend.

·
·
·
·

So, tell me what transfers in is?

Perhaps I am reading it wrong?

·
·
·
·
·

Transfers In are all transfers (STEEM or SBD) that come into the account, and are worth more than 1 STEEM or 1 SBD. Transfers below this threshold are recorded as Messages.

Feel free to send any screenshots of possible contradictions you find.

·
·
·
·
·
·

Where would these transfers in come from?
I have transferred in only once, though I have sent some to exchanges and returned it a couple times.
Not near what these numbers are showing.

How do I read that 9,230 in the lower right corner?
If that is a total of the totals, and half equals what I should have, then it appears to be in line with my guestimate.

·
·
·
·
·
·
·

If you add the 'From Account' and 'To Account' filters to the left-hand side, and show only the transfers by editing the 'Type' filter, you get this:
See full size

Does this help to explain it?

The 9,230 is the total value of all transactions entering and leaving your account. The bottom totals aren't very useful, and are just shown because of the way the JavaScript library I used works.

Many thanks! Now I know exactly how much I have earned this year so far. Should be enough for tax purposes.

·

I decided to download the whole csv. Let them work it out...

·
·

In that case the result is highly unpredictable. I suggest you at least gently nudge them to the right path.

Your post has been resteemed to my 2800 followers

Get a free resteem using the Power Resteem Service #26

Upvote this comment if you like this service

i thing nic post brother....i love all steemit member,....