Viewing a response to: @pairmike/re-kenny-crane-re-pairmike-attention-developers-i-need-help-with-openledger-json-trade-data-20180418t002249082z
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?
| 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 | 234,710,279,205,763 |
| 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 |
This data is from the bitshares api. See this link for the explorer to download - http://open-explorer.io/bitshares-account-exporter/index.php
| 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 |
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!
| 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 | 234,710,279,205,763 |
| 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 |
Cointracking.info has not created an import for any of the Bitshares decentralized exchanges.
| author | pairmike |
|---|---|
| permlink | re-pairmike-re-kenny-crane-re-pairmike-re-kenny-crane-re-pairmike-attention-developers-i-need-help-with-openledger-json-trade-data-20180418t011602574z |
| category | bitshares |
| json_metadata | {"tags":["bitshares"],"app":"steemit/0.1"} |
| created | 2018-04-18 01:16:03 |
| last_update | 2018-04-18 01:16:03 |
| depth | 5 |
| children | 0 |
| last_payout | 2018-04-25 01:16:03 |
| 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 | 93 |
| 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,452 |
| net_rshares | 0 |
hiveblocks