For unsupported exchanges, you can still upload trade history by preparing for a custom file.
Please read the following instructions and create an Excel(.xlsx) or CSV (.csv) file, and upload it in "Custom" box at the upload screen of Cryptact.
Caution: Invalid trades
If you upload a custom file to fix invalid trades such as unsupported coins or missing prices, please be careful that those invalid trades might be rectified automatically in our future system enhancements. Before uploading a custom file, please ensure those invalid trades remain invalid; otherwise you might end up with double booking.
Table of contents
- The format of a custom file
- Custom file examples - case by case
- Trades at unsuported exchanges, dealing with hard forks
- Joined ICO
- Purchase goods or service by cryptocurrencies
- Mining
- Transaction fee
- Missing prices
- Unsupported coins
- Received coins by bonus, campaign, or AirDrop
- Interests from coin lending
- Staking reward
- Borrowing/Returning between individuals
- Give a tip / Decrease the position
- Expense paid in Fiat currency
- Derivatives
1.The format of a custom file
You don't have to upload cryptocurrency transfers in general.
You don't have to upload transfers between your accounts or addresses to calculate positions in Cryptact. If you want to reduce your position by transaction fee, however, please follow Transaction fee
Name | Description | Example |
---|---|---|
Timestamp |
Trade datetime in YYYY/MM/DD HH:mm:ss
Timezone can be specified in the upload screen later.
|
2016/12/23 12:23:34 |
Action | BUY/SELL/PAY/MINING/SENDFEE/TIP/REDUCE/BONUS/LENDING | BUY |
Source | data source name (exchange or shop name) | Happy Travel |
Base |
Base currency
Please choose from Supported Coins
|
ICN |
DerivType |
Type of derivaties. Choose among "fx", "forward", "future", and "option".
You can omit this column if you don't trade derivatives
|
|
DerivDetails |
Details of derivatives
You can omit this column if you don't trade derivatives
|
|
Volume | Amount of change of base currency (in absolute value) | 150 |
Price |
Base currency price in Counter currency If this field is empty, cryptact uses its own price |
550 |
Counter |
Counter currency
Please choose from the supported coins list
|
JPY |
Fee | Fee for the trade | 0 |
FeeCcy |
Fee currency
Please choose from the supported coins list
|
JPY |
Comment |
Optional. Please use this field for your own purpose as Cryptact doesn't use this.
|
2.Custom file examples - case by case
Please check the following files which contains all samples
2.1.Trades at unsuported exchanges, dealing with hard forks
Example 1: Buy ETHBTC ( i.e. pay BTC to get ETH) at an unsupported exchange
You bought 2 ETH and paid BTC when the price of ETH was 0.5 BTC. The fee was 0.01 ETH.Timestamp | Action | Source | Base | Volume | Price | Counter | Fee | FeeCcy |
---|---|---|---|---|---|---|---|---|
Trade datetime | BUY | your exchange name here | ETH | 2 | 0.5 | BTC | 0.01 | ETH |
Example 2: Got coins by hard fork
You got 10 BCH by hard forkTimestamp | Action | Source | Base | Volume | Price | Counter | Fee | FeeCcy |
---|---|---|---|---|---|---|---|---|
Trade datetime | BUY | any | BCH | 10 | 0 (*1) | USD | 0 | USD |
(*1) Please specify $0 if it is hard fork.
2.2.Joined ICO
Example: You joined ICO of XP by sending ETH. You sent 10ETH and got 500XP.
Timestamp | Action | Source | Base | Volume | Price | Counter | Fee | FeeCcy |
---|---|---|---|---|---|---|---|---|
The time when you sent ETH | BUY | any | XP | 500 | 0.02
=10ETH/500XP
|
ETH | 0 | JPY |
2.3.Purchase goods or services by cryptocurrencies
Example 1: You paid 0.01 BTC to get a product worth 5,000 JPY. Given the price of the product and the amount of BTC paid, the rate of BTC is 1BTC=500,000JPY.
Timestamp | Action | Source | Base | Volume | Price | Counter | Fee | FeeCcy |
---|---|---|---|---|---|---|---|---|
datetime when you bought the product | PAY | any | BTC | 0.01 | 500000
5,000/0.01 = 500,000
|
JPY | 0 | JPY
Should be the same as Counter
|
Example 2: You paid 0.01BTC for a service whose price is quoted only in BTC.
Timestamp | Action | Source | Base | Volume | Price | Counter | Fee | FeeCcy |
---|---|---|---|---|---|---|---|---|
datetime when you bought the product | PAY | any | BTC | 0.01 |
Blank
|
JPY | 0 | JPY (*1)
|
(*1)Should be the same as Counter
Example 3: Cryptocurrency XYZW was not in the supported coin list. You paid 5 XYZW for a product. You know 1 XYZW was 300 JPY at that time.
Timestamp | Action | Source | Base | Volume | Price | Counter | Fee | FeeCcy |
---|---|---|---|---|---|---|---|---|
datetime when you bought the product | PAY | Any | CTT2 (*1) | 5 | 300 (*2) | JPY | 0 | JPY (*3)
|
(*1)Please use the dummy symbol
(*2)Please find the rate by yourself.
(*3)Should be the same as Counter
2.4.Mining
Example 1: Mined a coin whose price is available in Cryptact
You mined ETH and got 1 ETH. The cost was 10 USD.Timestamp | Action | Source | Base | Volume | Price | Counter | Fee | FeeCcy |
---|---|---|---|---|---|---|---|---|
datetime when you mined | MINING | Any | ETH | 1 |
(Empty *1)
|
JPY | 10 | USD |
(*1)If you empty the price column, crypact will look up the price instead if we have the one.
Example 2: Mined a coin whose price is NOT available in cryptact.
You mined LSK and got 10LSK. The LSK price at that time was 1,000JPY per LSK. The cost was 1 USD.Timestamp | Action | Source | Base | Volume | Price | Counter | Fee | FeeCcy |
---|---|---|---|---|---|---|---|---|
datetime you mined | MINING | Any | LS | 10 | 1000 | JPY | 1 | USD |
2.5.Transfer fee
Example: You spent 0.001 BTC for transfer.
Timestamp | Action | Source | Base | Volume | Price | Counter | Fee | FeeCcy |
---|---|---|---|---|---|---|---|---|
Transfer datetime | SENDFEE | any | BTC | 0.0001 | (Emply *1) | JPY (*2) | 0(*2) | BTC(*2) |
(*1) If you empty the price column, crypact will look up the price instead if we have the one.
(*2)We don't use Counter, Fee, FeeCcy columns. Please follow the example above.
2.6.Missing prices at cryptact
Example: You bought 10ETH and paid 1BTC when 1ETH=0.1BTC. In Cryptact, that trade became invalid due to a missing price.
You researched by yourself and found 1BTC was 1,500,000 JPY at that time.
Timestamp | Action | Source | Base | Volume | Price | Counter | Fee | FeeCcy |
---|---|---|---|---|---|---|---|---|
trade datetime | SELL | any | BTC | 1 | 1500000
Please find out the rate by yourself.
|
JPY | 0 | JPY |
trade datetime | BUY | any | ETH | 10 | 150000
0.1(ETHBTC price) x (BTCJPY price above)
|
JPY | 0.01 | ETH |
2.7.Unsupported coins
Example: When 1BNK was 0.5BTC, you bought 2 BNK and paid 1BTC. Fee was 0.01BNK. In Cryptact, the trade became invalid becuase BNK wasn't supported.
Timestamp | Action | Source | Base | Volume | Price | Counter | Fee | FeeCcy |
---|---|---|---|---|---|---|---|---|
trade timestamp | BUY | any | CTT2 | 2 | 0.5 | BTC | 0.01 | CTT2 |
2.8.Received coins by bonus, campaign, or AirDrop
Example: You joined an exchange's trade campaign, and received 0.01BTC.
Timestamp | Action | Source | Base | Volume | Price | Counter | Fee | FeeCcy |
---|---|---|---|---|---|---|---|---|
datetime you received the coin | BONUS | Any | BTC | 0.01 |
(Empty *1)
|
JPY(*2)
|
0 | JPY |
(*1) If you empty the price column, crypact will look up the price instead if we have the one.
(*2)We only supports fiat currencies as Counter for this trade type.
Example 2: You received 500XYZW by AirDrop. XYZW was not in the supported coins list. You researched by yourself and found 1 XYZW = 10JPY at that time.
Timestamp | Action | Source | Base | Volume | Price | Counter | Fee | FeeCcy |
---|---|---|---|---|---|---|---|---|
timestamp of the AirDrop | BONUS | Any | CTT3
(*1)
|
500 | 10 | JPY (*2)
|
0 | JPY |
(*1)Use a dummy symbol as the currency isn't supported.
(*2)We only support fiat in trade type 'BONUS'
2.9. Interests from coin lending
Example: You lent 10ETH to an exchange, and received 0.1ETH as an interest.
Timestamp | Action | Source | Base | Volume | Price | Counter | Fee | FeeCcy |
---|---|---|---|---|---|---|---|---|
datetime of the interest | LENDING | Any | ETH | 0.1 |
(Empty *1)
|
JPY | 0 | JPY |
(*1) If you empty the price column, crypact will look up the price instead if we have the one.
2.10. Staking reward
Example: You got two LSK as a reward for staking.
Timestamp | Action | Source | Base | Volume | Price | Counter | Fee | FeeCcy |
---|---|---|---|---|---|---|---|---|
datetime of the interest | STAKING | Any | LSK | 2 |
(Empty *1)
|
JPY | 0 | JPY |
(*1) If you empty the price column, crypact will look up the price instead if we have the one.
2.11.Borrowing/Returning between individuals
Example: Borrowing 3BAT at compound, then returned.
Timestamp | Action | Source | Base | Volume | Price | Counter | Fee | FeeCcy |
---|---|---|---|---|---|---|---|---|
datetime of the borrowing | BORROW | Any | BAT | 3 |
(Empty *1)
|
JPY | 0 | JPY |
datetime of the returning | RETURN | Same one with borrowing | BAT | 3 |
(Empty*1)
|
JPY | 0 | JPY |
(*1) If you empty the price column, crypact will look up the price instead if we have the one.
※Please be noted: As there are no clear guidelines for DeFi, etc., there is a possibility that the content may change in the future.
2.12.Give a tip / Decrease the position
Example: Gave my friend 0.0001 BTC as a tip.
Timestamp | Action | Source | Base | Volume | Price | Counter | Fee | FeeCcy |
---|---|---|---|---|---|---|---|---|
datetime of giving a tip | REDUCE | Any | BTC | 0.0001 |
(Empty)
|
JPY | 0 | JPY |
※note: Decrease the position without affecting the profit and loss.
2.13.Expenses paid in a fiat currency
Example: There is 2,000JPY in expenses that can be included in the cost of mining.
Timestamp | Action | Source | Base | Volume | Price | Counter | Fee | FeeCcy |
---|---|---|---|---|---|---|---|---|
datetime of payment | CASH | Any | JPY | 0 |
0
|
JPY | 2000 | JPY |
※note: If you have an income in a fiat currency, please enter a negative number in the Fee.
※note: If you paid in USD or other fiat currency, please fill USD in Base, Counter, and FeeCcy.
3.Derivaties
Specify DerivType and DerivDetail. Positions and profit and loss will be calculated by using DerivType+DerivDetail as a key.