TypeError: Cannot read property ‘appendRow’ of null (line 156, file “Code”)
did you forget to do this?
read the comments in the code there are things that you need to change
Solved! My apologies, I had understood “replace c1 with the sheet name” as the document (or spreadsheet) name, not the individual sheet. Thanks for your help, Happy New Year!
Now the export to csv is available in iOS app.
Just tried it to export dividend data and able to export.
Transaction and order history can also be exported to csv.
Can’t make this work after some hours on it
My portfolio is EURO so I modified this is what happens
- The value is wrong when exporting instead of euros is thousands of euros (what do you put in the columns of portfolio performance, I think the value and gross amount are wrong in the col for me or something)
The iOS and Android apps have export functionality now. Will come to desktoop soon I think.
@kali Hi. Thank you for your elaborate post. I have been trying to use PP with CSV imported from T212 contracts as you had explained. It works well for most part. Only issue I find is when trying to get historical quotes from yahoo for stocks that have their prices mentioned in GBX and USD. PP considers the prices to be in GBP and messes up my entire portfolio. Any workaround for this ?
Set the currency as GBX 
@nickspacemonkey Thanks for your reply. I have imported the transactions from T212 contract CSV. So I am not able to change the currency now. I get a similar message as seen in your Screenshot saying that currency can’t be changed as transaction already recorded.
It would be nice to have a video on how you do it, even without sound it’s really interesting because I can make an import but the values are all wrong…
1 Like
I use Hotmail instead of Gmail even though I have a Gmail account. I created a rule to automatically forward the contract notes to my Gmail but the script doesn’t seem to work. I guess the problem is that it’s checking only the most recent messages in the conversation (ie. an empty message from my Hotmail) instead of the original email from Trading212.
Example, my forwarded message contains:
- Email from Hotmail to Gmail
- Email from Trading212 to Hotmail
Only the first one is being processed. The code checks all messages in the threads with the specified label so I thought it would work. Any thoughts?
It might be easier to use @Dougal1984’s Google Sheets Portfolio Tracker.
Have a look at the thread to see if it is of use:
Hello!
Can you explain this procedure in detail, because I am trying in various ways to replicate it but I always get errors?
Importing Trading212 csv files into Portfolio Perfomance is becoming a trauma for me!
When I try to use the json file I get a blank error message and then I try to bind the columns manually. Then in the next screen all the operations are not imported.
Thank you!
Can you explain to me how this file you created also works?
Where should I replicate it? How do i use it?
Thank you!
That’s awesome man 
2 Likes
Thanks again for this great work @kali
I have done some refactoring to the code and uploaded it to github for versioning
please have a look and let me know what do you think?
but this you have to do manually.
am interested to know if anyone managed to find a similar automated way to grab the CSV exports