TradeLog is currently working to support importing Cryptocurrency (Digital Currency) transactions directly from popular currency exchange/trading platforms. If you have an Exchange you like, ask them to support TradeLog Software!
Cryptocurrency (Digital Currency) transactions can be imported using the Excel/Text import filter:
The Excel/Text Import Filter supports Cryptocurrency (Digital Currency) transactions. Follow the instructions below to format and then import your transaction history.
Note: TradeLog allows for up to 5 decimal places. Anything above this will need to be rounded.
Step 1 - Format Your Transaction History
If your current exchange/trading platform provides a transaction history download, you can likely format that data for importing into TradeLog using the Excel/Text import filter.
Click here to download a sample Excel/Text file.
Format your transaction history using the guidelines below listed for each column in the sample file - which can be used as a template
Date - The date the transaction occurred (in M/D/YYYY format)
Time - (This field is optional) The time the transaction occurred (in HH:MM:SS format)
O/C - Any one of the following, in upper or lower case, are acceptable: Buy, Bought, B, Purchase, or P, or Sell, Sold, or S for stocks.
NOTE: if units of a Cryptocurrency (Digital Currency) were used to purchase/acquired goods or services, this should be listed as a Sell since you are exchanging the Cryptocurrency (Digital Currency) for a good/service.
L/S - Can be blank for Cryptocurrency (Digital Currency) transactions.
Ticker - Use a standardized symbol such as BTC (Bitcoin), ETH (Ethereum), etc. Consistent symbols must be used to properly match transactions. Click here for a reference listing common symbols.
Sh/Contr - The number of units of a Cryptocurrency (Digital Currency) used in a transaction.
Price - This would be the price/value at the time of the transaction for one (1) total unit of the Cryptocurrency (Digital Currency). This price should be listed in the base currency used for reporting, typically US Dollars (USD).
Note: if you are unsure of the Price, but have the total Amount of the transaction, simply subtract the Comm (see below) from the Amount, then divide by the Sh/Contr unit quantity, the result is the Price.
Comm - Any known fees associated with the individual transaction would be entered here. Must be decimal, positive or negative. (TradeLog converts the value to positive during the import process.) If left blank, the Comm will be calculated from the Amount (providing the Amount includes commission/fees).
Amount - The total value of the transaction in your base currency (typically USD). Can be positive or negative. (TradeLog converts the value to appropriate positive or negative amount during the import process.) If left blank, TradeLog uses the following calculation, depending on whether the transaction is a "buy" or "sell": Amount = (Sh/Cont x Price) +/- Comm
Type/Mult - Enter D or d for Digital Currency trades.
Step 2 - Import Using the Excel/Text Import Filter
After formatting your transaction history, use the steps below to import into TradeLog.
- The Excel import button should display on the toolbar as shown here:
- In the formatted spreadsheet, select all the data - Tip: hit Ctrl + A on your keyboard. This will highlight the entire table of data.
- In the formatted spreadsheet, click Edit, Copy from the main menu or hit Ctrl + C on your keyboard to copy the trade data to the Windows Clipboard.
- Return to your TradeLog file.
- Click the Excel Import button to begin the import.
- A Confirmation pop-up will appear, asking you to confirm the total number of records to be saved. Click YES to save the imported trades in the data file.
All transaction history should be imported and matched.
Please sign in to leave a comment.