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:
- Ticker Symbol
- Transaction Currency
- Security Name
- 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.
- OpenRefine is here: https://openrefine.org
- Some videos on how to use it (from when it was called Google Refine): https://www.youtube.com/watch?v=B70J_H_zAWM&list=PL737054C67FCC0741
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)