Documentation

Introduction

Trade Republic allows you to track your investments in detail. Three types of asset can be tracked: cash, stocks and cryptocurrencies.

Portfolio

Portfolios are logical grouping of transactions and investment. This grouping allows efficient tracking of financial positions and performance. With your account, you may create up to 3 different portfolios.

Each portfolio is assigned a reference (or base) currency. The performance (Profit & Loss) of your investments is converted to the reference currency when needed.

Transaction types

Cash Transfer

Cash Transfers correspond to the funding of your investments. Cash Deposit and Withdrawal operations are used for that purpose.

For this type of transaction, the amount, currency and direction (deposit / withdrawal) must be provided.

Please note that Trade Republic doesn't prevent you from entering trades resulting in negative cash balance. This means you could track your Profit and Loss (P&L) without booking a single cash transfer. However, this would result in a poor user experience as Trade Republic would report a negative cash balance. For this very reason, it is recommended to fund your portfolio with a deposit before adding your other transactions.

Stock Market

This type of transaction corresponds to the buying or selling of stocks on the stock market.

The stock code, shares quantity and price and direction (buy/sell) must be provided. The stock code can be searched with company name. You will be able to check the stock code details on websites such as Yahoo Finance. For companies listed on multiple stock exchanges, please ensure you pick the stock code corresponding to the correct exchange.

Foreign Exchange (FX)

This type of transaction corresponds to the buying or selling of a currency against another currency. Please note that the Profit and Loss of the trade is converted to the portfolio reference currency when needed.

The buy and sell currencies and respective amounts must be provided.

Cryptocurrency

This type of transaction corresponds to the buying or selling of a cryptocurrency. The cryptocurrency can be bought/sold with cash or against another cryptocurrency. As for the FX transactions, the Profit and Loss of the trade is converted to the portfolio reference currency when needed.

The buy and sell (crypto)currencies and respective amounts must be provided.

Transaction Fees

You can optionally include transaction fees in any of the transactions listed above. The fee currency and amount needs to be specified. The fee is deducted from your cash balance but not included in the Profit and Loss figures calculated.

Portfolio related pages

The main pages related to a given portfolio are presented in this section: Dashboard, Time Report, Transactions and Configuration.

Dashboard

The Dashboard page presents a daily update on your investments performance along with a summary of your financial positions. The sections composing the dashboard are described below.

Overview

The Overview section presents 3 summary figures for your portfolio:

  • Net Asset Value (NAV).
  • Total P&L. This is the Profit and Loss for all your investments and past trades since inception.
  • Daily P&L. This is the Profit and Loss for all your investments between yesterday and today.

Daily Profit and Loss

This is a breakdown of the daily Profit and Loss between Stock, FX and Crypto trades.

Profit and Loss detail

The Profit and Loss detail for each investment.

Stocks

For each company, the following information is presented:

  • Currency: the currency used to trade the stock.
  • Company name.
  • Last price: current or last known trading price.
  • Change: price change between yesterday and today.
  • Quantity: number of shares held.
  • Daily P&L: the profit and loss between yesterday and today.
  • Total P&L: the profit and loss since inception.

FX

For each currency or currency pair, the following information is presented:

  • Currency / Currency Pair
  • Last Exchange Rate: current or last known exchange rate.
  • Change: exchaneg rate change between yesterday and today.
  • Quantity: amount of the specified currency held.
  • Daily P&L: the profit and loss between yesterday and today.
  • Total P&L: the profit and loss since inception.

Crypto

For each cryptocurrency or cryptocurrency pair, the following information is presented:

  • Cryptocurrency / Cryptocurrency pair
  • Last Exchange Rate: current or last known exchange rate.
  • Change: exchange rate change between yesterday and today.
  • Quantity: amount of the specified cryptocurrency held.
  • Daily P&L: the profit and loss between yesterday and today.
  • Total P&L: the profit and loss since inception.

Portfolio Chart

A chart displays the evolution over time of below quantities, converted to the portfolio reference currency when needed:

  • Portfolio NAV: the Net Asset Value of the portfolio.
  • Net Cash Invested: the net amount of cash deposited to the portfolio with cash transfer transactions.
  • Cash: the total value of cash holdings.
  • Stocks: the total value of stocks holdings.
  • Cryptocurrencies: the total value of cryptocurrencies.

Balances
Portfolio composition

A piechart shows the repartition of your holdings between cash, stocks and cryptocurrencies.

Balance detail

The amounts and values of each individual asset (cash, cryptocurrencies and stocks) is listed here.

Historical Performance

Provides a detailed report of your portfolio performance and financial positions over a given time period. Default periods such as month-to-date, year-to-date, or since inception can be selected. Alternatively the period start end end dates can be specified.

Balances
Portfolio composition

Displays the repartition of your assets among cash, stocks and cryptocurrencies at the period start and end.

Balances detail

The value of each individual asset (cash, cryptocurrencies and stocks) in the reference currency at the period start and end is listed here. Hovering over the figures displays the quantity for each asset.

Mark-to-Market Profit and Loss

For each individual asset, reports the Mark-to-Market Profit and Loss and any dividends perceived over the period.

Realized and Unrealized Profit and loss

Reports the Realized Profit and Loss during the period for each asset class. Also reports the unrealized Profit and Loss at the end of the period.

Transactions

Transactions history

The list of transactions in chronological order. Transactions can be deleted or edited from this page.

Import transactions

Import transactions from a CSV file. Please refer to instructions in the CSV format section below regarding CSV file format.

Export transactions

Download your portfolio transaction in CSV format.

CSV format

The CSV file must contain one line per transaction. The format depends on the type of transaction and is described in section below. The CSV file must contain no special characters such as accented characters (ASCII characters only). The date format must follow your preferred date format (currently set to ).

In case you face difficulties creating a CSV file to import your transactions, you may want to first input a few transactions with the New Transaction button in the menu. Then, go to the Export transactions section below and export the transactions to CSV. Finally, modify the CSV file produced in order to include the remaining transactions to import and import the modified CSV file.

For any transaction type, a fee can be added to the transaction by adding two additional trailing fields: <fee currency>,<fee amount>.

Cash transfer

cash,<date>,<direction>,<currency>,<amount>
For example, a deposit of 1000 USD on 10 January 2018: cash,10/1/2018,deposit,USD,1000.
Another example: withdrawal of 800 USD on 2 March 2018: cash,2/3/2018,withdrawal,USD,800.

Stock

stock,<date>,<direction>,<stock code>,<quantity>,<price>
For example, buying 100 Microsoft shares for $USD 90.50 each on 1 February 2018: stock,1/2/2018,buy,MSFT,100,90.50.
Selling 10 Samsung shares on 7 May 2018 for KRW 47000 each, and paying KRW 4000 in transaction fee: stock,18/7/2017,sell,005930.KS,10,47000,KRW,4000

FX

fx,<date>,<direction ccy 1>,<ccy 1>,<quantity ccy 1>,<direction ccy 2>,<ccy 2>,<quantity ccy 2>
For example, if you paid USD 120 and received EUR 100. The transaction representation could be: fx,1/2/2018,buy,EUR,100,sell,USD,120.
Please note that the Profit and Loss currency for your transaction is always the second currency )(<ccy 2>).

Crypto

crypto,<date>,<direction ccy 1>,<ccy 1>,<quantity ccy 1>,<direction ccy 2>,<ccy 2>,<quantity ccy 2>
Cryptocurrency transaction format is the same as FX transaction format. The first currency (<ccy 1>) must be a cryptocurrency while the second currency can be a cryptocurrency. The Profit and Loss currency is always the second currency (<ccy 2>).
Here are some valid examples: Buy 1 BTC for 10000 USD: crypto,13/1/2018,buy,BTC,1,sell,USD,10000
Exchange 1 BTC for 15 ETH: crypto,14/1/2018,buy,ETH,15,sell,BTC,1

New Transaction

Opens a window to add a new transaction to the portfolio.

Settings

Portfolio level settings:

  • Short Description: an optional field to describe the portfolio purpose.
  • Reference Currency: the reference currency to calculate Profit and Loss.
  • Report P&L by currency: please refer to the next paragraph for this setting.

Report P&L by currency

For simplicity, it is recommended to tick this option.
When ticked, the P&L is attributed separately to each currency or cryptocurrency traded (e.g. GBP, EUR, BTC...). The P&L currency is the portfolio reference currency.
When unticked, the P&L is attributed to each currency or cryptocurrency pair traded. (e.g. EUR/USD, BTC/USD...). In this case, the P&L currency needs to be selected among the two currencies forming the pair for each trade, (e.g. EUR or USD).
When ticked, the P&L for any FX or cryptocurrency transaction not involving the portfolio reference currency is distributed equally on both currencies. For example, if your portfolio reference currency is USD and you buy GBP and sell EUR, half of the P&L (in USD) is attributed to EUR and the other half to GBP. The P&L figures are calculated as if you sell EUR to buy USD and immediately sell that same USD amount to buy GBP. The USD amount involved in the process appears in the transaction list under the price section when hovering the sign.

User Preferences

User preferences can be modified under your account page.

Date format

Date format can be set to DD/MM/YYYY or MM/DD/YYYY.