Author Topic: What is the best way to download all of my account history?  (Read 15103 times)

0 Members and 1 Guest are viewing this topic.

Offline Spady007

Where exactly do you think our history is incomplete or inaccurate?

Let me give you a clear example.
 
Code from CSV

[4,{"fee":{"amount":0,"asset_id":"1.3.0"},"order_id":"1.7.50478545","account_id":"1.2.493907","pays":{"amount":2335000,"asset_id":"1.3.121"},"receives":{"amount":50000000,"asset_id":"1.3.0"},"fill_price":{"base":{"amount":2335000,"asset_id":"1.3.121"},"quote":{"amount":50000000,"asset_id":"1.3.0"}},"is_maker":true}]

Shows I paid 233.5 BitUS to buy 500 bts, but in fact I did the exact opposite which is was copied from "My Trades" on the main BTS trading screen which only lasts for 2 weeks.

s   0.467   500   233.5   2018-01-26 1:12

This is the accurate trade - where I sold 500 BTS at a price of .467 to receive 233.5 BitUS. The only difference is the green (buy) or the red (sell) from "My Trades" which is not translated in the CSV script code.

I now hope this is clear.

Greatly appreciate your input and assistance on this. I just want an accurate picture for tax purposes.


Offline Spady007

OK.Ok.Ok

So I've spent 10 hours going over the csv script to figure out my transactions. Was making fabulous progress until I realized there appears to be no difference between a buy or sell order. So frustrating!! Can you tell the difference?? The top script is a sell from bts to bitUS. The bottom script is a buy from bitUS to bts.

Please help - I'm dying - just figuratively of course!

[4,{"fee":{"amount":0,"asset_id":"1.3.0"},"order_id":"1.7.49894451","account_id":"1.2.493907","pays":{"amount":66903,"asset_id":"1.3.121"},"receives":{"amount":1728763,"asset_id":"1.3.0"},"fill_price":{"base":{"amount":1935000,"asset_id":"1.3.121"},"quote":{"amount":50000000,"asset_id":"1.3.0"}},"is_maker":true}]
                                                                                 
[4,{"fee":{"amount":0,"asset_id":"1.3.0"},"order_id":"1.7.47254046","account_id":"1.2.493907","pays":{"amount":1126,"asset_id":"1.3.121"},"receives":{"amount":19263,"asset_id":"1.3.0"},"fill_price":{"base":{"amount":2750000,"asset_id":"1.3.121"},"quote":{"amount":47009350,"asset_id":"1.3.0"}},"is_maker":true}]

Both above are of same side, paid 1.3.121 which is bitUSD and received 1.3.0 which is BTS.
Take a look at other records.

That is my entire point Abit - they were NOT the same side! The top script is a sell from bts to bitUS. The bottom script is a buy from bitUS to bts. However the code makes them both look identical...and therefore impossible to reconcile from the csv script data.


Offline pc

  • Hero Member
  • *****
  • Posts: 1530
    • View Profile
    • Bitcoin - Perspektive oder Risiko?
  • BitShares: cyrano
Where exactly do you think our history is incomplete or inaccurate?
Bitcoin - Perspektive oder Risiko? ISBN 978-3-8442-6568-2 http://bitcoin.quisquis.de

Offline Spady007

I guess I'm the only one that feels an accurate transaction history should be one of the first priorities for an exchange??

Offline abit

  • Committee member
  • Hero Member
  • *
  • Posts: 4664
    • View Profile
    • Abit's Hive Blog
  • BitShares: abit
  • GitHub: abitmore
OK.Ok.Ok

So I've spent 10 hours going over the csv script to figure out my transactions. Was making fabulous progress until I realized there appears to be no difference between a buy or sell order. So frustrating!! Can you tell the difference?? The top script is a sell from bts to bitUS. The bottom script is a buy from bitUS to bts.

Please help - I'm dying - just figuratively of course!

[4,{"fee":{"amount":0,"asset_id":"1.3.0"},"order_id":"1.7.49894451","account_id":"1.2.493907","pays":{"amount":66903,"asset_id":"1.3.121"},"receives":{"amount":1728763,"asset_id":"1.3.0"},"fill_price":{"base":{"amount":1935000,"asset_id":"1.3.121"},"quote":{"amount":50000000,"asset_id":"1.3.0"}},"is_maker":true}]
                                                                                 
[4,{"fee":{"amount":0,"asset_id":"1.3.0"},"order_id":"1.7.47254046","account_id":"1.2.493907","pays":{"amount":1126,"asset_id":"1.3.121"},"receives":{"amount":19263,"asset_id":"1.3.0"},"fill_price":{"base":{"amount":2750000,"asset_id":"1.3.121"},"quote":{"amount":47009350,"asset_id":"1.3.0"}},"is_maker":true}]

Both above are of same side, paid 1.3.121 which is bitUSD and received 1.3.0 which is BTS.
Take a look at other records.
BitShares committee member: abit
BitShares witness: in.abit

Offline Spady007

OK.Ok.Ok

So I've spent 10 hours going over the csv script to figure out my transactions. Was making fabulous progress until I realized there appears to be no difference between a buy or sell order. So frustrating!! Can you tell the difference?? The top script is a sell from bts to bitUS. The bottom script is a buy from bitUS to bts.

Please help - I'm dying - just figuratively of course!

[4,{"fee":{"amount":0,"asset_id":"1.3.0"},"order_id":"1.7.49894451","account_id":"1.2.493907","pays":{"amount":66903,"asset_id":"1.3.121"},"receives":{"amount":1728763,"asset_id":"1.3.0"},"fill_price":{"base":{"amount":1935000,"asset_id":"1.3.121"},"quote":{"amount":50000000,"asset_id":"1.3.0"}},"is_maker":true}]
                                                                                 
[4,{"fee":{"amount":0,"asset_id":"1.3.0"},"order_id":"1.7.47254046","account_id":"1.2.493907","pays":{"amount":1126,"asset_id":"1.3.121"},"receives":{"amount":19263,"asset_id":"1.3.0"},"fill_price":{"base":{"amount":2750000,"asset_id":"1.3.121"},"quote":{"amount":47009350,"asset_id":"1.3.0"}},"is_maker":true}]                                                                                 

Offline Spady007

Don't get me wrong, I'm a huge bitshares fan. However, getting a complete an accurate account history should be an automatic for an exchange!

Offline Spady007

Just wondering if there has been some progress made on the transaction history?

Offline Spady007

Looking forward to the update. Thanks a lot!

Offline oxarbitrage

Hello. I'm also trying to download all of my transactions in order to reconcile my account. I followed the above steps and it appeared to work. The issue is the CSV file has plenty of data, but not the simple data I'm looking for - such as fill price and amount of bts purchased.

Appreciate any help!

I'll be writing some Python tools to parse the CSV file into human-readable data, if that's any help. I'll come back here with a github link when/if I get the tools working in a publicly accessible way.

that will be awesome, i plan to improve it a bit but don't have the time so any help is very appreciated.

Offline biophil

  • Hero Member
  • *****
  • Posts: 880
  • Professor of Computer Science
    • View Profile
    • My Academic Website
  • BitShares: biophil
Ok guys, sorry the delay. I had moved elasticsearch to a new node and now it is fully in sync and working. I changed the exporter to point to the new place, please try again:

http://open-explorer.io/bitshares-account-exporter/

I also increased the timeout to 60 seconds so big accounts can be downloaded without the need to go over it in chunks.

I confused at first with your account, thought it was biophil but i see now it is http://open-explorer.io/#/accounts/zebulon with 3782 operations.

I was able to download your account history now, sending the csv by email too but you can go ahead and try to download from the online tool.

thanks for the patience.

Fantastic, looks like the tool works fine now, and I also got the CSV by email. Thanks very much!
Support our research efforts to improve BitAsset price-pegging! Vote for worker 1.14.204 "201907-uccs-research-project."

Offline biophil

  • Hero Member
  • *****
  • Posts: 880
  • Professor of Computer Science
    • View Profile
    • My Academic Website
  • BitShares: biophil
Hello. I'm also trying to download all of my transactions in order to reconcile my account. I followed the above steps and it appeared to work. The issue is the CSV file has plenty of data, but not the simple data I'm looking for - such as fill price and amount of bts purchased.

Appreciate any help!

I'll be writing some Python tools to parse the CSV file into human-readable data, if that's any help. I'll come back here with a github link when/if I get the tools working in a publicly accessible way.
Support our research efforts to improve BitAsset price-pegging! Vote for worker 1.14.204 "201907-uccs-research-project."

Offline Spady007

Hello. I'm also trying to download all of my transactions in order to reconcile my account. I followed the above steps and it appeared to work. The issue is the CSV file has plenty of data, but not the simple data I'm looking for - such as fill price and amount of bts purchased.

Appreciate any help!

Offline oxarbitrage

Ok guys, sorry the delay. I had moved elasticsearch to a new node and now it is fully in sync and working. I changed the exporter to point to the new place, please try again:

http://open-explorer.io/bitshares-account-exporter/

I also increased the timeout to 60 seconds so big accounts can be downloaded without the need to go over it in chunks.

I confused at first with your account, thought it was biophil but i see now it is http://open-explorer.io/#/accounts/zebulon with 3782 operations.

I was able to download your account history now, sending the csv by email too but you can go ahead and try to download from the online tool.

thanks for the patience.

Offline oxarbitrage

it's the server issue, i am configuring new server right now. will put the chain to sync in a bit and in some hours i will have you guys try the exporter again, everything should work fine.