| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | AR | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Author | hammerhart | Bitcointalk-acc | https://bitcointalk.org/index.php?action=profile;u=1181548 | ||||||||||||||||||||||||||||||||||||||||
2 | Last Update | 24/03/18 | ||||||||||||||||||||||||||||||||||||||||||
3 | no guarantee of the relevance, accuracy or completeness of this file and any of the generated data. | |||||||||||||||||||||||||||||||||||||||||||
4 | Donation address | Address | ||||||||||||||||||||||||||||||||||||||||||
5 | BTC | 1HkNGqe6zeoymNGKZNW9J9xhFzHL89hf4k | ||||||||||||||||||||||||||||||||||||||||||
6 | DOGE | D9cNPJk8NtvFyVQenp7VeaagRuG8oKMQdT | ||||||||||||||||||||||||||||||||||||||||||
7 | ETH | 0x4994661BBe8B0D6C5925b7103A5D62E8256e098F | ||||||||||||||||||||||||||||||||||||||||||
8 | Cointracking.com-ref linke | https://cointracking.info?ref=H662021 | ||||||||||||||||||||||||||||||||||||||||||
9 | Personal notes: -Pupopse of this document is to convert transaction data from exchanges/wallets, which can not be directly be imported to cointracking.com, into a format so it can be imported to cointracking.com via the "Excel Import". -Columns A-K contain the content which will be used to import the data into coinmarket.info. The example-data in the rows 12-14 is an example form their website. -Green marked fields are for our input. Please make sure you convert your data with the rigth decimal-separator („,“;“.“). It might be useful to use a separate document to copy each of your transactions in, especially for excahnes like coinsmarkets where you have to copy+paste your data from the website and then when you have everything copy it in the data-generation file. You might need to change/adpat the formula a bit but the basic structure should be a good starting point. -Grey fields generate data from the green fields in order to convert the data and provide the correct information into the fields of A-K for the import of cointracking.com. -I myself created a file for each wallet/exchange-website since it is much easier to handle like that in my opinion. When you are finished with your data, I at least did, copy the Columns A-K as a formated text into a new file and import the data and then use that file to upload to cointracking.com. -Please double check if the generated data makes sense! -Share and feel free to comment/improve/adapt the file to your needs. I do not guarantee the accuracy or completness of this file or any generated data. -I altered some of this example transactions. So no need to try to find me;) | |||||||||||||||||||||||||||||||||||||||||||
10 | ||||||||||||||||||||||||||||||||||||||||||||
11 | Example from Cointracking.com | |||||||||||||||||||||||||||||||||||||||||||
12 | Type (Trade, IN or OUT) | Buy Amount | Buy Cur. | Sell Amount | Sell Cur. | Fee Amount (optional) | Fee Cur. (optional) | Exchange (optional) | Trade Group (optional) | Comment (optional) | Date | |||||||||||||||||||||||||||||||||
13 | Trade | 1,5 | BTC | 400 | USD | 0,8 | USD | Poloniex | My first trade | 30-01-2016 15:20:25 | ||||||||||||||||||||||||||||||||||
14 | Deposit | 200 | ETH | Coinbase | 24-02-2016 17:45:00 | |||||||||||||||||||||||||||||||||||||||
15 | ||||||||||||||||||||||||||||||||||||||||||||
16 | Created data to be able to be imported to Cointracking.com. | |||||||||||||||||||||||||||||||||||||||||||
17 | Best to copy only the columns A-J into a seperate file and insert as a „formated text.“ | |||||||||||||||||||||||||||||||||||||||||||
18 | Coinexchange | |||||||||||||||||||||||||||||||||||||||||||
19 | Created data to be able to be imported from Cointracking.com | Coinexchange-raw data | Generated support data based on raw-data | |||||||||||||||||||||||||||||||||||||||||
20 | Best to copy only the columns A-J into a seperate file and insert as a „formated text.“ | Copy data from Coinexchange page by in the trade history. Take care to import with right decimal-separatorb („,“;“.“)- or convert if neccessary. | Depending on decimal separator adaptions might be neccessary | |||||||||||||||||||||||||||||||||||||||||
21 | Trade-data | |||||||||||||||||||||||||||||||||||||||||||
22 | Trade ID | Type | Related Order | Market | Time | Price | Amount | Total | Fee | Net Total | Splitname- Buy-coin | Splitname- Sell-coin | split time-Date | split time-time | Split-month/date | year | day | month | new date | |||||||||||||||||||||||||
23 | Trade | 1000 | BOAT | 0,0016024 | BTC | 0,0000024 | BTC | Coinexchange | 16-03-2018 06:42:39 | 11727400 | BUY | 128703831 | BOAT/BTC | 2018-03-16 06:42:39 | 0,00000016 | 1000 | 0,0016 | 0,0000024 | 0,0016024 | BOAT | BTC | 2018-03-16 | 06:42:39 | 03-16 | 2018 | 16 | 03 | 16-03-2018 06:42:39 | ||||||||||||||||
24 | Trade | 0,0021 | BTC | 3000 | BOAT | 0,00000324 | BTC | Coinexchange | 15-03-2018 03:04:17 | 11701632 | SELL | 2861295111 | BOAT/BTC | 2018-03-15 03:04:17 | 0,00000072 | 3000 | 0,0021 | 0,00000324 | 0,00215676 | BTC | BOAT | 2018-03-15 | 03:04:17 | 03-15 | 2018 | 15 | 03 | 15-03-2018 03:04:17 | ||||||||||||||||
25 | Deposits | |||||||||||||||||||||||||||||||||||||||||||
26 | Deposit | 82774,46 | BUZZ | Coinexchange | 21-02-2018 16:22:10 | 2018-02-21 16:22:10 | BUZZ | 82774,46 | confirmed | B9Mu92CU6TWjQQBTXpGBybdhkbVCuYmhVHicE 4f656703cd7aec1895b443fd8623a5c6dc3a6208a4f7dce2b8772895ae9 | cleared | 2018-02-21 | 16:22:10 | 02-21 | 2018 | 21 | 02 | 21-02-2018 16:22:10 | ||||||||||||||||||||||||||
27 | Deposit | 33468,93938 | BUZZ | Coinexchange | 15-02-2018 01:57:39 | 2018-02-15 01:57:39 | BUZZ | 33468,93938 | confirmed | B9Mu92CU6TWjQQBTXpGBybdhkbVCuYmhVHicE 4f656703cd7aec1895b443fd8623a5c6dc3a6208a4f7dce2b8772895ae9 | cleared | 2018-02-15 | 01:57:39 | 02-15 | 2018 | 15 | 02 | 15-02-2018 01:57:39 | ||||||||||||||||||||||||||
28 | Withdrawl | |||||||||||||||||||||||||||||||||||||||||||
29 | OUT | 86,15903714 | RAIN | 0,5 | RAIN | Coinexchange | 07-01-2018 15:37:07 | 2018-01-07 15:37:07 | RAIN | 86,15903714 | 0,5 | RDwrVkXonwYnio7AZ1Sv5VaaxWVAKq6PW1 E86410264b7d2ad83c5dd264e322d13ebce221711dd007eed480ccbb2sgfsdg4846b | Completed | 2018-01-07 | 15:37:07 | 01-07 | 2018 | 07 | 01 | 07-01-2018 15:37:07 | ||||||||||||||||||||||||
30 | OUT | 30935,84264 | ERA | 0,1 | ERA | Coinexchange | 11-11-2017 15:25:24 | 2017-11-11 15:25:24 | ERA | 30935,84264 | 0,1 | RDwrVkXonwYnio7AZ1Sv5VaaxWVAKq6PW1 E86410264b7d2ad83c5dd264e322d13ebce221711dd007eed480ccbb2sgfsdg4846b | Completed | 2017-11-11 | 15:25:24 | 11-11 | 2017 | 11 | 11 | 11-11-2017 15:25:24 | ||||||||||||||||||||||||
31 | ||||||||||||||||||||||||||||||||||||||||||||
32 | ||||||||||||||||||||||||||||||||||||||||||||
33 | Coinsmarkets.com | |||||||||||||||||||||||||||||||||||||||||||
34 | Deposits | |||||||||||||||||||||||||||||||||||||||||||
35 | Withdrawl data requires a matrix to identifiy the coinname with and coinid. Therfore columns AB-AC can be used as a basis for the matrix. The maxtrix can be fouind in the second sheet | |||||||||||||||||||||||||||||||||||||||||||
36 | Coin Name | Type | Amount | Time | Extract currecny | split time-Date | split time-time | Split-month/date | month | year | day | new date | ID-currecny | Coinname | Coin-id | |||||||||||||||||||||||||||||
37 | Deposit | 3000 | MUT | Coinsmarkets | 04-01-2018 01:01:50 | MutualCoin | receive | 3000 (MUT) | 01/04/2018 01:01:50 | MUT) | 01/04/2018 | 01:01:50 | 04/2018 | 01 | 2018 | 04 | 04-01-2018 01:01:50 | MUT | MutualCoin | MUT | ||||||||||||||||||||||||
38 | Deposit | 1,013 | LTC | Coinsmarkets | 16-12-2017 07:12:27 | Litecoin | receive | 1,013 (LTC) | 12/16/2017 07:12:27 | LTC) | 12/16/2017 | 07:12:27 | 16/2017 | 12 | 2017 | 16 | 16-12-2017 07:12:27 | LTC | Litecoin | LTC | ||||||||||||||||||||||||
39 | Deposit | 200 | RAIN | Coinsmarkets | 15-11-2017 07:12:51 | Rain | receive | 200 (rain) | 11/15/2017 07:12:51 | rain) | 11/15/2017 | 07:12:51 | 15/2017 | 11 | 2017 | 15 | 15-11-2017 07:12:51 | RAIN | Rain | RAIN | ||||||||||||||||||||||||
40 | ||||||||||||||||||||||||||||||||||||||||||||
41 | ||||||||||||||||||||||||||||||||||||||||||||
42 | ||||||||||||||||||||||||||||||||||||||||||||
43 | Withdrawl | |||||||||||||||||||||||||||||||||||||||||||
44 | Just change format of this colum to match with cointracking.com time-format. Coinsmarktes format is recogniced by libreoffice (excel?) | |||||||||||||||||||||||||||||||||||||||||||
45 | Coin Name | Address | Ammount | Time | Coinname- | split time-Date | split time-time | Split-month/date | day | year | month | new date | Test-date | |||||||||||||||||||||||||||||||
46 | Auszahlung | 60200,1 | MUT | Coinsmarkets | 19-11-2017 21:17:06 | MutualCoin | GRae35B5zxfdSpq2vjp4dcZfEJmYkkQ9LZ | 60200,1 | 19/11/17 21:17 | MutualCoin | 19/11/17 | 21:17 | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | 19-11-2017 21:17:06 | ||||||||||||||||||||||||||
47 | Auszahlung | 31800,1 | HIGHT | Coinsmarkets | 16-10-2017 07:19:27 | Highcoin | HV4z73dF4X4V4qBAGyEeVfa4x9rqtUMLAM | 31800,1 | 16/10/17 07:19 | Highcoin | 16/10/17 | 07:19 | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | 16-10-2017 07:19:27 | ||||||||||||||||||||||||||
48 | ||||||||||||||||||||||||||||||||||||||||||||
49 | ||||||||||||||||||||||||||||||||||||||||||||
50 | ||||||||||||||||||||||||||||||||||||||||||||
51 | Trade-data | |||||||||||||||||||||||||||||||||||||||||||
52 | Copy this data into new file as a formatted text- and sort for „#value/#wert“ fields and delete them. They only describe partially executed trades and mess up your balance otherwise | Withdrawl data requires a matrix to identifiy the coinname with and coinid. Therfore columns AB-AC can be used as a basis for the matrix. The maxtrix can be fouind in the second sheet | ||||||||||||||||||||||||||||||||||||||||||
53 | Type | Price | Amount | Total | Fees | Closed Time | TYPE | Valid trade | Market-temp | Splitname- Buy-coin | Splitname- Sell-coin | Raw-amount | Raw-total | Amount-Buy | Amount-sell | Fee-amount | Fee-currecny | split time-Date | split time-time | Split-month/date | month | year | day | new date | Coinname | Coinid | ||||||||||||||||||
54 | Trade | 0,300000000 | LTC | 0,004650000 | BTC | 0,00075 | LTC | Coinsmarkets | 03-10-2018 02:01:17 | Buy (BTC/LTC) | 0,015500000 Bitcoin | 0,004650000 Bitcoin | 0,300000000 Litecoin | 0,00075 LTC | 10/03/2018 02:01:17 | Buy | Valid Trade | BTC/LTC) | BTC/LTC | LTC | BTC | 0,004650000 | 0,300000000 | 0,300000000 | 0,004650000 | 0,00075 | LTC | 10/03/2018 | 02:01:17 | 03/2018 | 10 | 2018 | 03 | 03-10-2018 02:01:17 | Litecoin | LTC | ||||||||
55 | Trade | 0,004650000 | #VALUE! | 0,004650000 | #VALUE! | 1,74375E-6 | LTC | Coinsmarkets | #VALUE! | 01/02/2018 04:01:55 | 0,015500000 Bitcoin | 0,004650000 Bitcoin | 0,300000000 Litecoin | 1,74375E-6 LTC | 01/02/2018 | 0 | #VALUE! | #VALUE! | #VALUE! | #VALUE! | 0,004650000 | 0,300000000 | 0,004650000 | 0,004650000 | 1,74375E-6 | LTC | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | Litecoin | #VALUE! | |||||||||
56 | Trade | 0,000024000 | BTC | 2000,000000000 | 808 | 6,0E-8 | BTC | Coinsmarkets | 12-01-2018 10:01:17 | Sell (BTC/808) | 0,000000012 Bitcoin | 0,000024000 Bitcoin | 2000,000000000 808Coin | 6,0E-8 BTC | 01/12/2018 10:01:17 | Sell | Valid Trade | BTC/808) | BTC/808 | BTC | 808 | 0,000024000 | 2000,000000000 | 0,000024000 | 2000,000000000 | 6,0E-8 | BTC | 01/12/2018 | 10:01:17 | 12/2018 | 01 | 2018 | 12 | 12-01-2018 10:01:17 | 808Coin | 808 | ||||||||
57 | Trade | 0,000024000 | #VALUE! | 0,000024000 | #VALUE! | 7,2E-13 | 808 | Coinsmarkets | #VALUE! | 01/02/2018 06:01:01 | 0,000000012 Bitcoin | 0,000024000 Bitcoin | 2000,000000000 808Coin | 7,2E-13 808 | 01/02/2018 | 0 | #VALUE! | #VALUE! | #VALUE! | #VALUE! | 0,000024000 | 2000,000000000 | 0,000024000 | 0,000024000 | 7,2E-13 | 808 | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | 808Coin | #VALUE! | |||||||||
58 | Trade | 0,000016500 | BTC | 1500,000000000 | 808 | 4,125E-8 | BTC | Coinsmarkets | 03-01-2018 10:01:26 | Sell (BTC/808) | 0,000000011 Bitcoin | 0,000016500 Bitcoin | 1500,000000000 808Coin | 4,125E-8 BTC | 01/03/2018 10:01:26 | Sell | Valid Trade | BTC/808) | BTC/808 | BTC | 808 | 0,000016500 | 1500,000000000 | 0,000016500 | 1500,000000000 | 4,125E-8 | BTC | 01/03/2018 | 10:01:26 | 03/2018 | 01 | 2018 | 03 | 03-01-2018 10:01:26 | 808Coin | 808 | ||||||||
59 | Trade | 0,000016500 | #VALUE! | 0,000016500 | #VALUE! | 3,403125E-13 | 808 | Coinsmarkets | #VALUE! | 01/02/2018 06:01:54 | 0,000000011 Bitcoin | 0,000016500 Bitcoin | 1500,000000000 808Coin | 3,403125E-13 808 | 01/02/2018 | 0 | #VALUE! | #VALUE! | #VALUE! | #VALUE! | 0,000016500 | 1500,000000000 | 0,000016500 | 0,000016500 | 3,403125E-13 | 808 | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | 808Coin | #VALUE! | |||||||||
60 | Trade | 0,500000000 | LTC | 0,008055000 | BTC | 0,00125 | LTC | Coinsmarkets | 02-01-2018 08:01:49 | Buy (BTC/LTC) | 0,016110000 Bitcoin | 0,008055000 Bitcoin | 0,500000000 Litecoin | 0,00125 LTC | 01/02/2018 08:01:49 | Buy | Valid Trade | BTC/LTC) | BTC/LTC | LTC | BTC | 0,008055000 | 0,500000000 | 0,500000000 | 0,008055000 | 0,00125 | LTC | 01/02/2018 | 08:01:49 | 02/2018 | 01 | 2018 | 02 | 02-01-2018 08:01:49 | Litecoin | LTC | ||||||||
61 | Trade | 0,005046372 | #VALUE! | 0,005046372 | #VALUE! | 3,1539825E-6 | LTC | Coinsmarkets | #VALUE! | 01/02/2018 03:01:22 | 0,016110000 Bitcoin | 0,005046372 Bitcoin | 0,313244680 Litecoin | 3,1539825E-6 LTC | 01/02/2018 | 0 | #VALUE! | #VALUE! | #VALUE! | #VALUE! | 0,005046372 | 0,313244680 | 0,005046372 | 0,005046372 | 3,1539825E-6 | LTC | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | Litecoin | #VALUE! | |||||||||
62 | Trade | 0,003008628 | #VALUE! | 0,003008628 | #VALUE! | 1,8803925E-6 | LTC | Coinsmarkets | #VALUE! | 01/02/2018 03:01:22 | 0,016110000 Bitcoin | 0,003008628 Bitcoin | 0,186755320 Litecoin | 1,8803925E-6 LTC | 01/02/2018 | 0 | #VALUE! | #VALUE! | #VALUE! | #VALUE! | 0,003008628 | 0,186755320 | 0,003008628 | 0,003008628 | 1,8803925E-6 | LTC | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | Litecoin | #VALUE! | |||||||||
63 | Trade | 1500,000000000 | 808 | 0,000009000 | BTC | 3,75 | 808 | Coinsmarkets | 02-01-2018 04:01:18 | Buy (BTC/808) | 0,000000006 Bitcoin | 0,000009000 Bitcoin | 1500,000000000 808Coin | 3,75 808 | 01/02/2018 04:01:18 | Buy | Valid Trade | BTC/808) | BTC/808 | 808 | BTC | 0,000009000 | 1500,000000000 | 1500,000000000 | 0,000009000 | 3,75 | 808 | 01/02/2018 | 04:01:18 | 02/2018 | 01 | 2018 | 02 | 02-01-2018 04:01:18 | 808Coin | 808 | ||||||||
64 | Trade | 0,000009000 | #VALUE! | 0,000009000 | #VALUE! | 1,6875E-5 | 808 | Coinsmarkets | #VALUE! | 01/01/2018 08:01:29 | 0,000000006 Bitcoin | 0,000009000 Bitcoin | 1500,000000000 808Coin | 1,6875E-5 808 | 01/01/2018 | 0 | #VALUE! | #VALUE! | #VALUE! | #VALUE! | 0,000009000 | 1500,000000000 | 0,000009000 | 0,000009000 | 1,6875E-5 | 808 | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | 808Coin | #VALUE! | |||||||||
65 | Trade | 2000,000000000 | 808 | 0,000014000 | BTC | 5 | 808 | Coinsmarkets | 02-01-2018 04:01:14 | Buy (BTC/808) | 0,000000007 Bitcoin | 0,000014000 Bitcoin | 2000,000000000 808Coin | 5 808 | 01/02/2018 04:01:14 | Buy | Valid Trade | BTC/808) | BTC/808 | 808 | BTC | 0,000014000 | 2000,000000000 | 2000,000000000 | 0,000014000 | 5 | 808 | 01/02/2018 | 04:01:14 | 02/2018 | 01 | 2018 | 02 | 02-01-2018 04:01:14 | 808Coin | 808 | ||||||||
66 | ||||||||||||||||||||||||||||||||||||||||||||
67 | ||||||||||||||||||||||||||||||||||||||||||||
68 | Day-Wallet [Chronologic] | |||||||||||||||||||||||||||||||||||||||||||
69 | ||||||||||||||||||||||||||||||||||||||||||||
70 | Day-is staking every day in the eth-wallet. Since transactions are not tracked there. I used a prediction-model with my POS-rate to generate the raw-data myself for the tax declaration. DAY bought later in the progress (can just be added in column Q). Pupose is to track the value of the stacks when they appear. | DAY-income for tax reasons | ||||||||||||||||||||||||||||||||||||||||||
71 | Type (Trade, IN or OUT) | Buy Amount | Buy Cur. | Sell Amount | Sell Cur. | Fee Amount (optional) | Fee Cur. (optional) | Exchange (optional) | Trade Group (optional) | Comment (optional) | Date | Date | X-Tag | Balance | DAY-Timepower (POS-rate) | DAY-bought | DAY-staked for Tax | |||||||||||||||||||||||||||
72 | Einnahme | 0 | DAY | DAY-MINT-Wallet | Daily-Mint | 19-09-2017 00:00:00 | 19-09-2017 00:00:00 | 0 | 25,08 | 0,009 | 25,08 | 0 | ||||||||||||||||||||||||||||||||
73 | Einnahme | 0,22572 | DAY | DAY-MINT-Wallet | Daily-Mint | 20-09-2017 00:00:00 | 20-09-2017 00:00:00 | 1 | 25,30572 | 0,009 | 0,22572 | |||||||||||||||||||||||||||||||||
74 | ||||||||||||||||||||||||||||||||||||||||||||
75 | Rain-Wallet | |||||||||||||||||||||||||||||||||||||||||||
76 | Data is from Wallet-export | |||||||||||||||||||||||||||||||||||||||||||
77 | Confirmed | Date | Type | Label | Address | Amount | ID | Amount-In | Amount-Out | Split-date | Split-time | Split-month/date | year | day | month | New-date | ||||||||||||||||||||||||||||
78 | Einzahlung | 5614,579008 | RAIN | 0 | RAIN | 0,1 | RAIN | Rain-wallet | RHTATVKWmssfSdnV1JgrDckoLxY7vxyct | Rain incoming address | 15-03-2018 14:39:17 | true | 2018-03-15T14:39:17 | Received with | Rain incoming address | RHTATVKWmssfSdnV1JgrDckoLxY7vxyct | 5614,579008 | ffbf14fbeec02bd7a6aba01a5216ec87959c063241b39c8e23d6da839f8346bb-000 | 5614,579008 | 0 | 2018-03-15 | 14:39:17 | 03-15 | 2018 | 15 | 03 | 15-03-2018 14:39:17 | |||||||||||||||||
79 | Mining | 1056,043836 | RAIN | 0 | RAIN | 0,1 | RAIN | Rain-wallet | RHTATVKWmssfSdnV1JgrDckoLxY7vxyct | 3 | 12-03-2018 18:45:04 | true | 2018-03-12T18:45:04 | Mined | 3 | RHTATVKWmssfSdnV1JgrDckoLxY7vxyct | 1056,043836 | 4ea2d2197a66297baa3e5072cb17baaac075676b861b1fc36d09b6f7de058f98-000 | 1056,043836 | 0 | 2018-03-12 | 18:45:04 | 03-12 | 2018 | 12 | 03 | 12-03-2018 18:45:04 | |||||||||||||||||
80 | Auszahlung | 0 | RAIN | 22000,1 | RAIN | 0,1 | RAIN | Rain-wallet | RHD93wWQZKs4EVtszafjerhJtMxsKc2rcR | coinsmarket | 15-12-2017 19:22:42 | true | 2017-12-15T19:22:42 | Sent to | coinsmarket | RHD93wWQZKs4EVtszafjerhJtMxsKc2rcR | -22000,1 | 4e4mklm5bc72ea2cfbb87fd41f0ad6a02487f4b107da6c52c114bf3c1ab5102be56f-000 | 0 | 22000,1 | 2017-12-15 | 19:22:42 | 12-15 | 2017 | 15 | 12 | 15-12-2017 19:22:42 | |||||||||||||||||
81 | ||||||||||||||||||||||||||||||||||||||||||||
82 | Stocksexchange.com | |||||||||||||||||||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||||||||||||||||||||
84 | Trade ID | Type | Related Order | Market | Time | Price | Amount | Total | Fee | Net Total | Splitname- Buy-coin | Splitname- Sell-coin | split time-Date | split time-time | Split-month/date | year | day | month | new date | |||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||||||||||||||||||||
86 | Date | Buy Asset | Buy Amount | Price | Sell Asset | Sell Amount | Trade_OrderID | Trade_Operation | Fee | Fee Asset | Sell | |||||||||||||||||||||||||||||||||
87 | Deposit | 199999,99000000 | USA | 0,00000000 | 0,00000000 | USA | Stocks-exchange | 17-11-2017 17:00:14 | 2017-11-17 17:00:14 | USA | 199999,99000000 | 0,00000000 | 0,00000000 | 1234 | Deposit | 0,00000000 | USA | 2017-11-17 | 17:00:14 | 11-17 | 2017 | 17 | 11 | 17-11-2017 17:00:14 | ||||||||||||||||||||
88 | Trade | 0,00200000 | BTC | 199999,99000000 | USA | 0,00000399 | BTC | Stocks-exchange | 17-11-2017 17:07:43 | 2017-11-17 17:07:43 | BTC | 0,00200000 | 0,00000001 | USA | 199999,99000000 | 1235 | Order | 0,00000399 | BTC | 2017-11-17 | 17:07:43 | 11-17 | 2017 | 17 | 11 | 17-11-2017 17:07:43 | ||||||||||||||||||
89 | Trade | 10,12897366 | AERM | 0,00111520 | BTC | 0,02025794 | AERM | Stocks-exchange | 17-11-2017 17:08:40 | 2017-11-17 17:08:40 | AERM | 10,12897366 | 0,00011010 | BTC | 0,00111520 | 1236 | Order | 0,02025794 | AERM | 2017-11-17 | 17:08:40 | 11-17 | 2017 | 17 | 11 | 17-11-2017 17:08:40 | ||||||||||||||||||
90 | Deposit | 173999,99000000 | USA | 0,00000000 | 0,00000000 | USA | Stocks-exchange | 17-11-2017 17:15:11 | 2017-11-17 17:15:11 | USA | 173999,99000000 | 0,00000000 | 0,00000000 | 1237 | Deposit | 0,00000000 | USA | 2017-11-17 | 17:15:11 | 11-17 | 2017 | 17 | 11 | 17-11-2017 17:15:11 | ||||||||||||||||||||
91 | OUT | 0,00000000 | 1,68700000 | AERM | 0,00300000 | AERM | Stocks-exchange | 17-11-2017 19:28:22 | 2017-11-17 19:28:22 | 0,00000000 | 0,00000000 | AERM | 1,68700000 | 1238 | Withdraw | 0,00300000 | AERM | 2017-11-17 | 19:28:22 | 11-17 | 2017 | 17 | 11 | 17-11-2017 19:28:22 | ||||||||||||||||||||
92 | ||||||||||||||||||||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||||||||||||||||||||