Exchange Rates

If you trade instruments denominated in a currency different from your account’s base currency, FTJ needs exchange rates to accurately convert P&L values. The Rates view is where you manage these rates.

Navigate to Rates in the sidebar to access the Exchange Rates and Lot Sizes panels.

When You Need Exchange Rates

Most users do not need exchange rates. If your account base currency matches the currency of the instruments you trade (e.g. a USD account trading USD-denominated stocks), all P&L values are already in the correct currency and no conversion is required.

Exchange rates are only needed when the trade currency differs from the account base currency.

Example: You have an account in NOK (Norwegian Krone) and you trade BTCUSD (denominated in USD). FTJ needs a USD-NOK rate for the trade’s close date (or entry date if the trade is still open) to convert the P&L into NOK.

If an exact-day rate is missing, the trade’s P&L will:

• Fall back to the original trade currency value and be silently summed with base-currency values, producing an incorrect total.

• Trigger a “Fix missing exchange rates” guidance item on the Dashboard.

When viewing All Accounts with a reporting currency, trades that cannot be converted are excluded from analytics entirely. The Dashboard will display how many trades were excluded.

Tip

The guidance panel on the Dashboard shows how many trades are affected by missing rates and provides a shortcut to the Rates view to fix them.

Managing Rates Manually

The exchange rates table shows all stored rates:

To add a rate manually:

1. Click + Add.

2. Select the Date (the date the rate applies to).

3. Choose the From and To currencies from the dropdowns.

4. Enter the Rate (e.g. 1 EUR = 1.18 USD means the rate is 1.18).

5. Click Save to persist.

To delete a rate, click the trash icon (🗑) next to it.

You can also edit a rate that was fetched from the API. Manually entered or edited rates are marked as Manual in the Source column, while rates downloaded via the API show API.

Fetching Rates Automatically

Note

Fetching rates requires an internet connection.

FTJ can fetch historical exchange rates powered by the European Central Bank.

1. Click Fetch Rates in the toolbar.

2. FTJ scans your trades for missing currency pairs and dates.

3. It automatically downloads and inserts the required rates.

4. A summary shows how many rates were fetched.

Note

The API provides rates published by the ECB. It covers most major currencies but does not include cryptocurrency rates (e.g. BTC, ETH). For crypto, you’ll need to add rates manually.

Filters

Click the Filters button to filter the rates table by currency pair or date range. This is useful when you have many rates and want to find a specific one.

Validation

The right-hand side of the view shows three status panels:

• Missing Rates - Lists currency pairs and dates that need rates but don’t have them. If this shows “No missing rates”, you’re all set.

• Recent Changes - Shows the last few rates that were added or modified.

• Validation Summary - An overall status (e.g. “All good.” means no issues).