I’m new to Portfolio Performance. I think it’s a great tool and I am very interested in using it. I’ve added the securities I’m interested in and now I want to add my positions from my broker. Currently, my broker is Trading 212
I have a lot of positions open and while I don’t mind adding them manually, it will be very time-consuming.
Is there any way to import a csv or a pdf file from Trading 212. I’m not that proficient in Excel but when data is exported from Trading 212 into a .csv file, it has the following columns (from left to right) :
Action (Buy/Sell) Time ISIN Ticker Name No. of shares Price / share Currency (Price / share) Exchange rate Currency (Result) Total Currency (Total) Stamp duty reserve tax Currency (Stamp duty reserve tax) Notes ID Currency conversion fee Currency (Currency conversion fee)
Is there any way I can import this into Portfolio Performance?
Apologies if my question is very basic, I’m new and I’m still trying to understand how it works fully.
I’ve taken a look at the forum and searched through some questions but I couldn’t find any answer.
first, thank you for taking the time to respond to my request.
In theory, Trading 212 does not apply any fees to transactions, so there are only the FX fees to consider, however you are correct to point out that they should deduct tax at some point. I have not sold anything, so I do not know what that looks like.
I have also just re-read DA_BESTS request and I see that I can apparently generate a CSV export which contains a tax field. I was not aware of this feature and need to take a look how can can create the CSV export.
I presume that if the CSV export works, then there will be no need for a PDF import.
In the Trading 212 web interface, clicking the Hamburger menu → History → Download document symbol (Box with down arrow) allows one to select the transaction types and a time window for the transactions that one wants to download
I was able to import buy (GBP / USD) and dividend (GBP) transactions. I do not have any other transactions at the moment apart from interest.
I did not import the interest transactions as I did not want to clutter my account with daily transactions, instead I used the information from the monthly statement email which provides the “Interest on uninvested cash”
So for now it looks like no PDF import is required.
Once again thank you Alex for taking a look at my request and sorry for the “noise” on the board.