Import TER and vendor data for ETFs

English Import/export
1

how Can I import from CSV or online (e.g. justetf.com) the TER and Venddor data for 50+ ETFs?

2

That’s not possible, you could just set in manually in the attributes.

3

See Portfolio Performance database – ppxml2db import/export

4

Thanks. I will try this

5

Hello,

I tried, but the following error occured on Win 10:
PS D:\temp\ppxml2db-master> py ppxml2db.py kommer.xml kommer.db
Traceback (most recent call last):
File “D:\temp\ppxml2db-master\ppxml2db.py”, line 10, in
import lxml.etree as ET
ModuleNotFoundError: No module named ‘lxml’

6

py -m pip install lxml

7

Excellent! It works nicely. Do you any tool that can automatically categorize assets in this db using e.g. Morningstar definitions?

8

Here we go:

9

Thanks, this way it works with the sample xml.
Having my real data, I got errors:PS D:\temp\ppxml2db-master> py ppxml2db.py 20260320.xml 20260320.db
Traceback (most recent call last):
File “D:\temp\ppxml2db-master\ppxml2db.py”, line 584, in
conv.iterparse()
~~~~~~~~~~~~~~^^
File “D:\temp\ppxml2db-master\ppxml2db.py”, line 502, in iterparse
assert self.uuid2ctr_map[uuid].startswith(what), self.uuid2ctr_map[uuid]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^
AssertionError: referenceAccount
All accounts have different names in PP (neither deposit, nor securities account)

10

Solved here