Hi - I´m New on the platform and like to make a portefolio at PP, but I have difficulties with making an import to PP at data from Nordnet - anyone that have control of this and can give me a hint on HOW TO? - I have checked the advice allready in the forum and also on YouTupe, but without cracking the nuts 
I have added my mapping to this tread and also the error message I receive when I make the import.
Any help og advice is much appriciated.
Hi, it took me a while, but I figured it out. Are you struggling with figuring out which columns to assign to what, or do you have other questions?
I think I have solved how the colum is converted, but I get failure when I import - and I cannot find out what is wrong:
This is the version table:
| Nordnet | PP |
|---|---|
| Id | |
| Bogføringsdag | |
| Handelsdag | Date |
| Valørdag | |
| Depot | |
| Transaktionstype | Type |
| Værdipapirer | |
| ISIN | ISIN |
| Antal | Shares |
| Kurs | |
| Rente | |
| Samlede afgifter | Taxes |
| Valuta | |
| Beløb | Value |
| Valuta | |
| Indkøbsværdi | Gross Amount |
| Valuta | Currency Gross Amount |
| Resultat | |
| Valuta | |
| Totalt antal | |
| Saldo | |
| Vekslingskurs | Exchange Rate |
| Transaktionstekst | Note |
| Makuleringsdato | |
| Notanummer | |
| Verifikationsnummer | |
| Kurtage | Fees |
| Valuta | Transaction Currency |
| Middelkurs | |
| Oprindelig rente | |
| - | WKN |
| - | Ticker Symbol |
| - | Security Name |
Is it correct?
And this is also converted:
| Portfolio Performance | Nordnet | Beskrivelse |
|---|---|---|
| Buy | Køb | Køb af værdipapirer (aktier, fonde, osv.) |
| Sell | Salg | Salg af værdipapirer |
| Deposit | Indbetaling | Indbetaling til kontoen (kontant indsætning) |
| Dividend | Udbytte | Modtaget udbytte fra værdipapirer |
| Fees | Kurtage | Gebyrer for transaktioner |
| Fees Refund | Tilbageførsel af gebyrer | Refusion af betalte gebyrer |
| Interest | Renteindtægt | Modtaget rente (f.eks. på kontanter) |
| Interest Charge | Renteudgift | Betalt rente (f.eks. ved belåning) |
| Removal | Udfasning | Fjernelse af værdipapirer (f.eks. ved overførsel) |
| Tax Refund | Skatterefusion | Tilbagebetalt skat (f.eks. på udbytte) |
| Taxes | Skat | Betalt skat (f.eks. kildeskat på udbytte) |
| Transfer (Inbound) | Overførsel (Indgående) | Overførsel af værdipapirer til depot |
| Transfer (Outbound) | Overførsel (Udgående) | Overførsel af værdipapirer ud af depot |
Is it correct?
Suppose that you wish to import two portfolio transactions: a sell of 2 shares of BASF in EUR and a buy of 3 shares NVIDIA in USD. Since we are using the EUR cash account in both cases, the transaction in USD must be converted into EUR. In this case, PP will handle this automatically because the NVIDIA security is listed in USD and the security account in EUR. Alternatively, you can designate the
Currency Gross Amountcolumn asUSD. However, a more efficient workflow may involve defining theCash Account, and eventually theSecurities Account. This prevents the import from defaulting to standard accounts, such asbroker-Aandbroker-A (EUR)in this case.
Hope that helps (I’m not using csv-import often, and I’m not using different currencies)
It seems like you are in Denmark. I am in Norway, my csv might look a bit different. But here is how I assign it:
| NN | PP |
|---|---|
| Bokføringsdag | Date |
| Transaksjonstype | Type |
| Verdipapir | Security name |
| ISIN | ISIN |
| Antall | Amount |
| Totale avgifter | Fees |
| Beløp | Value |
| Vekslingskurs invers * | Exchange rate |
* So, the exchange rate in the nornet csv is the inverse of what PP wants… So I open it in a spreadsheet-app first (apple numbers in my case), add a new column where I calculate =(1/vekslingskurs), and export as a csv again. Unfortunately an extra step…
I speak german, so my PP is set to german - maybe I got some column names wrong in english here.
I don’t assign any others.
I don’t use buy/sell but the ones that don’t need a cash account (don’t know it in english… “Einlieferung” and “Auslieferung” in german) - I don’t keep track of the cash on my Nordnet account.
Remember to add all the instruments first, and make sure they are set to the correct currency. (Maybe you know this already - I made the mistake and didn’t.)
Thanks Urnzi for your help - I have tryed some of you suggestions, but without getting control. But, I think the problem is different currency as it gives some trouble as I can read in the manual. I’ll do some more thinking and getteing some help in my network and if I found out how to make it correct I will drop a message here in the thread. Thanks :-).
