RE: Attention Bitshares Developers: I need help with JSON Trade Data. by pairmike

View this thread on: hive.blog | peakd.com | ecency.com

Viewing a response to: @kenny-crane/re-pairmike-attention-developers-i-need-help-with-openledger-json-trade-data-20180418t000352804z

bitshares · @pairmike · Apr 18 '18

$0.31

Hey Kenny,  

I know it not valid Json.  What I'm really looking for is to understand how to convert this info into something like this:

Type	Buy	Cur.	Sell	Cur.	Fee	Cur.	Exchange	Group	Comment	Date
Trade	4.46672378	LTC	978.90708337	USD	2.92793744	USD	GDAX			2018-02-15 09:00:44

👍 kenny-crane

`author`	pairmike
`permlink`	re-kenny-crane-re-pairmike-attention-developers-i-need-help-with-openledger-json-trade-data-20180418t002249082z
`category`	bitshares
`json_metadata`	{"tags":["bitshares"],"app":"steemit/0.1"}
`created`	2018-04-18 00:22:48
`last_update`	2018-04-18 00:22:48
`depth`	2
`children`	4
`last_payout`	2018-04-25 00:22:48
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.230 HBD
`curator_payout_value`	0.076 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	278
`author_reputation`	43,927,661,974,027
`root_title`	"Attention Bitshares Developers: I need help with JSON Trade Data."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	50,659,427
`net_rshares`	61,598,608,096
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
kenny-crane	0 B		61,598,608,096	16%

@kenny-crane · Apr 18 '18

Are you getting this data from a javascript program or are you using something else?

In js, the Buy Currency would be 

`arr[1].receives.amount + ' ' + arr[1].receives.asset_id`

I would think.  

cointracking.info says they have "Automatic import via APIs" so I would think there would already be some automatic way to do this, but I'm not familiar with BitShares/OpenLedger APIs.  I imagine they have APIs and they probably look like Steemit APIs, but I'd have to look into it.  I assume what you show here is the result of a BitShares API call, but maybe cointracking does not support this API?

properties (22)

`author`	kenny-crane
`permlink`	re-pairmike-re-kenny-crane-re-pairmike-attention-developers-i-need-help-with-openledger-json-trade-data-20180418t005139223z
`category`	bitshares
`json_metadata`	{"tags":["bitshares"],"app":"steemit/0.1"}
`created`	2018-04-18 00:51:39
`last_update`	2018-04-18 00:51:39
`depth`	3
`children`	3
`last_payout`	2018-04-25 00:51:39
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	598
`author_reputation`	235,849,011,712,652
`root_title`	"Attention Bitshares Developers: I need help with JSON Trade Data."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	50,662,691
`net_rshares`	0

@pairmike · Apr 18 '18

This data is from the bitshares api.  See this link for the explorer to download - http://open-explorer.io/bitshares-account-exporter/index.php

properties (22)

`author`	pairmike
`permlink`	re-kenny-crane-re-pairmike-re-kenny-crane-re-pairmike-attention-developers-i-need-help-with-openledger-json-trade-data-20180418t011209614z
`category`	bitshares
`json_metadata`	{"tags":["bitshares"],"links":["http://open-explorer.io/bitshares-account-exporter/index.php"],"app":"steemit/0.1"}
`created`	2018-04-18 01:12:09
`last_update`	2018-04-18 01:12:09
`depth`	4
`children`	2
`last_payout`	2018-04-25 01:12:09
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	143
`author_reputation`	43,927,661,974,027
`root_title`	"Attention Bitshares Developers: I need help with JSON Trade Data."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	50,665,041
`net_rshares`	0

@kenny-crane · Apr 18 '18

So when you use that form, you get a CSV file, and it looks like what you posted was the value for the "Operation History - Raw Operation" field.

Mapping from that, to what cointracking needs:

The Type will probably always be "Trade".

Buy Currency is probably the "receives" json data.

Sell Currency is probably "pays".

Fee Currency is probably "fee".

Exchange Group is Open Ledger.

Comment Date is probably the value in the CSV file under the "Block Data - Block Time" heading, for example 2018-04-11T11:27:57

So are you looking for a program to take the CSV file data and output data that cointracking can handle?  Or are you just trying to figure out what data in the CSV file corresponds to what cointracking needs?  I think what I stated above is the correct map of the CSV data and the data cointracking needs.

If you need some custom coding for something like this, we can talk more by email.  I'm at kenny [at] YouTubeStars.com

Best wishes!

properties (22)

`author`	kenny-crane
`permlink`	re-pairmike-re-kenny-crane-re-pairmike-re-kenny-crane-re-pairmike-attention-developers-i-need-help-with-openledger-json-trade-data-20180418t025720829z
`category`	bitshares
`json_metadata`	{"tags":["bitshares"],"app":"steemit/0.1"}
`created`	2018-04-18 02:57:21
`last_update`	2018-04-18 02:57:21
`depth`	5
`children`	0
`last_payout`	2018-04-25 02:57:21
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	958
`author_reputation`	235,849,011,712,652
`root_title`	"Attention Bitshares Developers: I need help with JSON Trade Data."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	50,677,541
`net_rshares`	0

@pairmike · Apr 18 '18

Cointracking.info has not created an import for any of the Bitshares decentralized exchanges.

properties (22)