Feature Request: Extract ETF Asset Allocation (Countries, Sectors, Currencies) from ETF Holdings List

[fbuchinger]

In the sales prospectuses of ETFs there is never a comprehensive country / currency / sector classification, mostly it reads: "55% USA, 7% Japan, ..., 12% other". If you have several ETFs, these inaccuracies can build up and you start a rebalancing, although there is no need to do so. By parsing the fund holdings reports provided by the ETF emittents, we can provide an accurate and automatically updateable ETF/fund classification.

As the manager of an ETF portfolio using PP, I want an automatically updated asset classification so that I can rebalance my portfolio properly and make informed investment decisions

How could this feature work?

For each fund, the user has to configure the following attributes in the security properties (Ctrl+E):

• URL to the ETF fund holding list: can be obtained from the ETF issuer website, e.g. https://www.ishares.com/de/privatanleger/de/produkte/270051/ishares-msci-world-momentum-factor-ucits-etf -> Link to "Fondspositionen und Kennzahlen")
• Data Mapping for the CSV File (Value from dropdown list) defines the CSV column names needed for the classification (e.g. ISIN, Country Names, Currency,..) and other data transformation stuff.
• Rebalancing interval of fund: used to determine when the fund holding list needs to be downloaded again

In addition, the user needs to define in the global settings which classifications should be auto-generated for the portfolio:

• Country Allocation
• Currency Allocation
• Sector Allocation
• Top 10 Holdings (individual shares) in portfolio

After confirming these changes, the configured classifications are auto-generated and updated at the defined intervals.

Open Questions:

• how should the feature behave in mixed portfolios (funds + shares)?
• what if a user makes manual changes to an automatically generated classification? Are these preserved after an update or should the classification be read-only?