Convert GBP/GBX when importing from Interactive Brokers

English Import/export
5

I’m not familiar with Interactive Brokers’ exports, but…

I’m just writing a guide on how to handle imports for GBX denominated securities. The main reference manual does contain a section now on importing with explanation of handling different currencies. It is possible to work it out from there but I must admit I took many twists and turns (even after getting it working).

It can be done in the CSV import however (assuming you don’t mind manipulating and adding some info. to the CSV). It does not need editing of the XML.

I’m nearly done on the guide although I still need to navigate getting that into PP’s manual format and contributing it for review via GitHub.

In the meantime, the short version which may help:

  1. Create your securities first before importing any transactions (otherwise your GBX securities will be created as GBP when you first import a transaction).
  2. Specify the currency of the securities as GBX where applicable
  3. Create the Portfolio Transactions import data (i.e. your buys and sells) with at a minimum:
    Date, Type, Value, Shares, Currency Gross Amount, Exchange Rate and one of Ticker Symbol, ISIN or WKN. And optionally Taxes and Fees.

I use Yahoo! Finance so I just have the YF Ticker Symbol.

Currency Gross Amount is the pricing currency of the security (e.g. GBP, USD, EUR, or GBX)

Exchange Rate is blank except for the GBX lines where it needs to be 100.

Import using type “Portfolio Transactions”

The following thread may also help (it helped me):