How to save contract notes into portfolio perfomance:
- Create some accounts: (one time only)
If you want to handle your portfolio like me, I recommend creating a “securities account” and a “deposit account” in portfolio performance for every pie you have on T212.
Alternatively you can create just one securities and one deposit account if you want to just save all your investments in one place.
- Create a template in portfolio performance for T212 contract notes (one time only)
go File -> import -> CSV Files
select the CSV file you saved from google docs
match the csv columns to the fields needed manually or:- save this following line as plain text file somewhere like
somefilename.json
- save this following line as plain text file somewhere like
{"delimiter":",","columns":[{"field":"ticker","label":"Column 1"},{"field":"isin","label":"Column 2"},{"field":"type","format":"BUY=Buy;SELL=Sell;TRANSFER_IN=Transfer (Inbound);TRANSFER_OUT=Transfer (Outbound);DELIVERY_INBOUND=Delivery (Inbound);DELIVERY_OUTBOUND=Delivery (Outbound)","label":"Column 3"},{"field":"shares","format":"0,000.00","label":"Column 4"},{"label":"Column 5"},{"field":"value","format":"0,000.00","label":"Column 6"},{"field":"date","format":"dd-MM-yyyy","label":"Column 7"},{"field":"time","label":"Column 8"},{"field":"taxes","format":"0,000.00","label":"Column 9"},{"field":"exchangeRate","format":"0,000.00","label":"Column 10"},{"label":"Column 11"},{"field":"currency","label":"Column 12"},{"field":"account","label":"Column 13"},{"field":"portfolio","label":"Column 14"}],"isFirstLineHeader":false,"skipLines":0,"label":"Trading212 PT","encoding":"UTF-8","target":"portfolio-transaction"}
- click the gear icon there and select import configuration
- use
somefilaname.json
- From now on you just go
File -> import -> Templates -> Trading212 PT
- will show you the fields like:
Click next and next again, enjoy your transactions in portfolio performance.