Exchange rate of transaction missing on reimport

English Import/export
1

I have the following setup.

Base currency: USD
Security: SXRV.DE, currency: EUR

  1. I make a test Transaction, Buy and Sell
  2. Export the transaction
  3. Delete all transactions
  4. Import the transaction

It returns an error about Exchange rates missing. It’s not possible, as it’s been there perfectly before.

Attached the exported test CSV.

test.csv (370 Bytes)

2

You don’t give the relevant information that would enable us to see what is going on. Did you select “portfolio transactions”? What column mapping did you use?

3

Hi,

  1. I register 2 test transactions:

image
image2352×224 61.3 KB

  1. Export it from File menu using this:

image
image1240×810 98.9 KB

4
  1. Then I delete the transactions
  2. Then I import using File menu using this:

image
image1024×418 103 KB

image
image2074×844 190 KB

Errors:

image
image2162×908 201 KB

5

I think I get it, the key is to select Portfolio Transactions instead of Account Transactions?

6

One thing I still cannot do, is to import transactions which were non-base currency.

The scenario is the following:
I have a list of historical transactions, both in USD and EUR. I know their opening and closing price, but only in the currency of the security, not in the converted base currency.

How can I import this?