Hi,
I’m trying to write a python file or files that will create an xlsx file for the whole of my T212 Stocks and shares ISA with the help of AI.
My portfolio started in April 2025 and I used a CSV downloaded from T212. The AI is telling me that T212 changed the API behaviour late 2025 and interest comes through as a Deposit with a UUID Reference so mistakes are now being made with my python file.
Can anybody help with this. I don’t want to go mad changing things that don’t need changing.
Thanks
I wish you the very best of luck with that but I don’t fancy your chances. You will have to get rid of all the redundant (duplicated) instrument API data introduced last November to satisfy users who wouldn’t know a database from a duck billed platypus.
Until then, it mirrored a very well structured underlying database. All of this change was done to a beta product. Beta products are widely accepted as being the final version except for changes resulting from testing by a wider community. These changes were wholesale.
Does it need to be live?
I just export all activity and then drop into google sheets. It then does its magic.
I have 118 stocks. I don’t think Google sheets will accept that many.
I tried (or rather Claude tried with my help) to start using a CSV file from T212 as a Bootstrap, and then a python file to update whenever. This caused problems because of the changes in November last year. I eventually sorted it by bootstrapping using a JSON. That seems to have solved the problems.
Apparently, Google sheets will take up to 10 million cells. I think 118 stocks is unlikely to exceed that.
1 Like