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

0 Members and 1 Guest are viewing this topic.

Online abit

  • Committee member
  • Hero Member
  • *
  • Posts: 3362
    • View Profile
    • Steemit Blog
  • BitShares: abit
  • GitHub: abitmore
Re: What is the best way to download all of my account history?
« Reply #15 on: February 25, 2018, 01:55:43 pm »
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.
BTS account: abit
BTS committee member: abit
BTS witness: in.abit

Offline Spady007

Re: What is the best way to download all of my account history?
« Reply #16 on: March 07, 2018, 01:36:50 pm »
I guess I'm the only one that feels an accurate transaction history should be one of the first priorities for an exchange??

Online pc

  • Hero Member
  • *****
  • Posts: 1392
    • View Profile
    • Bitcoin - Perspektive oder Risiko?
  • BitShares: cyrano
Re: What is the best way to download all of my account history?
« Reply #17 on: March 08, 2018, 02:12:22 pm »
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

Re: What is the best way to download all of my account history?
« Reply #18 on: March 09, 2018, 05:09:10 am »
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 Spady007

Re: What is the best way to download all of my account history?
« Reply #19 on: March 09, 2018, 05:33:40 am »
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.


Online abit

  • Committee member
  • Hero Member
  • *
  • Posts: 3362
    • View Profile
    • Steemit Blog
  • BitShares: abit
  • GitHub: abitmore
Re: What is the best way to download all of my account history?
« Reply #20 on: March 09, 2018, 11:37:14 am »
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.
I think you misunderstood. They ARE both sells or both buys. Paste more records here or somewhere else (e.g. pastebin), I can help find the records on the other side for you.

Perhaps there is a bug in the csv exporter.

Bottom line, accurate full history are on the chain.

I do agree that we do need good tools to export the histories, it's important (we do have many important things to be done). Perhaps you can setup a service for it and earn some money.
« Last Edit: March 09, 2018, 11:43:01 am by abit »
BTS account: abit
BTS committee member: abit
BTS witness: in.abit

Offline bench

  • Full Member
  • ***
  • Posts: 107
    • View Profile
Re: What is the best way to download all of my account history?
« Reply #21 on: March 10, 2018, 04:04:26 am »
I am also interested in improving the export function and UI.

Any suggestion which tools to use?

Offline darkf0rce

Re: What is the best way to download all of my account history?
« Reply #22 on: March 16, 2018, 10:19:46 pm »
I am trying to view my account activity
When I go to http://open-explorer.io/#/accounts/darkf0rce, I can see the first page of my activity but when I click on any other page, it comes back with a blank (it shows me total of 42 pages of activity)
Any suggestions?

Offline oxarbitrage

Re: What is the best way to download all of my account history?
« Reply #23 on: March 16, 2018, 11:13:31 pm »
I am trying to view my account activity
When I go to http://open-explorer.io/#/accounts/darkf0rce, I can see the first page of my activity but when I click on any other page, it comes back with a blank (it shows me total of 42 pages of activity)
Any suggestions?

seems there is a problem with the pagination . ill fix during this weekend among other things in the explorer. if you can pls submit an issue here as a reminder https://github.com/oxarbitrage/open-explorer/issues

thank you very much.

Offline oxarbitrage


Offline Spady007

Re: What is the best way to download all of my account history?
« Reply #25 on: March 17, 2018, 09:48:01 pm »
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.
I think you misunderstood. They ARE both sells or both buys. Paste more records here or somewhere else (e.g. pastebin), I can help find the records on the other side for you.

Perhaps there is a bug in the csv exporter.

Bottom line, accurate full history are on the chain.

I do agree that we do need good tools to export the histories, it's important (we do have many important things to be done). Perhaps you can setup a service for it and earn some money.

Hello Abit,
I've been doing more 'detective' work on the csv exporter. It seems recently (early February) that the exporter is correctly identifying the “pays” asset and the “receive” asset. However, the exporter misses a few actual transactions – about 10%!!
For instance, I purchased some BTS on March 6 (see below) but these transactions do not even appear on the CSV exporter data! I have found other missing data points as well.
PRICE   BTS   B   DATE
0.180000   400.00000   72.0000   03/6 12:22:42
0.190000   250.00000   47.5000   03/6 04:39:30

A couple of other questions
1. Where would I find a list of assets?
For instance - asset_id":"1.3.121 is bitUSD
 
2. How do I get on the BTS Chain? I’ve tried the URL below – but I almost always get a message that something went wrong – problem with a node?
https://www.cryptofresh.com/


3. The ‘operations’ section from the CSV exporter has 6 values 0-5
 
I believe they correspond to the following. Am I accurate?

0 – a transfer of some sort- it appears anyone can transfer a ‘new’ asset to a bts account holder
1 – limit order
2 – cancel order
3 – Unsure
4 – Executed order
5 – Start of a new account

You asked me if I would be interested in trying to help out with this service? I certainly would! I’m not much of a programmer at all, but I will put in the time if you will direct me…

Thanks again for your assistance. I want BTS to succeed because I believe it levels the playing field for everyone and I feel Stan Larimer’s character and integrity is first rate!

Offline oxarbitrage

Re: What is the best way to download all of my account history?
« Reply #26 on: March 17, 2018, 10:31:42 pm »
let me answer this @Spady007

in regards to the exporter, thanks for the notification. the elasticsearch server that the bitshares exporter uses to get data is at full disk so some of the last transactions are not getting inserted. i am requesting more disk at the server, then i need to replay the chain and will be working again, i'll update here.

1- for a list of assets if cryptofresh is down you can use http://open-explorer.io/#/assets(not complete list) or if you know the asset name or the id you can do http://open-explorer.io/#/assets/1.3.3027 or if you know the name do http://open-explorer.io/#/assets/NEXTCOIN

2- there are some problems pretty often with cryptofresh but there is a private project, we cant do anything for it. as an alternative you may use other explorers like the built in explorer of the reference wallet https://wallet.bitshares.org/#/explorer/blocks, the already mentioned open explorer(http://open-explorer.io/#/dashboard) or a new explorer project(https://bts.ai/?locale=en).

3- a list of operation number - operation name can be found at: http://open-explorer.io/#/fees

Offline oxarbitrage

Re: What is the best way to download all of my account history?
« Reply #27 on: March 21, 2018, 12:14:42 pm »
the exporter problem was fixed as more hd was added to the elasticsearch server.

please retry: http://open-explorer.io/bitshares-account-exporter/index.php

account ID: 1.2.493907
start date: 2018-03-01 09:00:22
end date: 2018-03-22 09:55:22

account page: http://open-explorer.io/#/accounts/1.2.493907

Offline Spady007

Re: What is the best way to download all of my account history?
« Reply #28 on: April 02, 2018, 04:42:24 pm »
Thanks Oxarbitrage! I will update my transactions. Hoping Bitshares 3.0 when released will be more user friendly and have a full (at least 1 year) transaction list. I figured my transactions using CSV, but quite an arduous process!!

Offline ZafarYaqoob

Re: What is the best way to download all of my account history?
« Reply #29 on: April 04, 2018, 09:46:25 am »
Thank You oxarbitrage Your answer solve my Problem.
Hi, I would love to share My knowledge with others I learned about crypto different websites.

Blog: www.coinkir.com