T212 Contract Note Email Importer

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.
    image
  • 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
{"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 next and next again, enjoy your transactions in portfolio performance.

8 Likes