Import transactions from Nordnet using OpenRefine

I can import transactions from my brokers (Nordnet) transaction list if I amend the file. This required a bunch of minor changes, which I did using OpenRefine. It’s is an nice tool to transform a lot of data into the required CSV format. So if you have a broker file that you have to import try it out.

The process is:

  • Broker export file > Transform in OpenRefine > Export to CSV > import to PP

Transform required is mapping your brokers columns to PP expected columns:

  • Date
  • Time
  • ISIN
  • Ticker Symbol
  • WKN
  • Value
  • Transaction Currency
  • Type
  • Security Name
  • Shares
  • Note
  • Taxes
  • Fees
  • Cash Account
  • Offset Account
  • Securities Account

Save the OpenRefine transformation as a project, and can rerun it on a new export file later.

The hardest part I had was looking up the tickers in Yahoo.

An example JSON file of the operations taken to transform a Nordnet export CSV file into a PP import CSV file is attached (as a text file).NordnetOpenRefineOperations.txt (14,8 KB)

1 Like