Automatic import of classifications

English Import/export
329

Hello, and thank you for your detailed reply. I hope someone can integrate the new features into your script, it wouldn’t be a bad idea also to do it directly in PP.

330

Hi @Alfons1Qvor12,

Thanks a lot for this tool!

It took me a while to get Python and Git set up, but it was totally worth it.
For me… it really adds a lot of value to PP!

Just tried it with the Top 100 holdings…
It’s great to have the information in PP, but as you said, it get’s a little messy. At least in the holding-charts.

Would the following be feasible without too much trouble?
With the argument “-top_holdings 100”, your classifier will create the following classifications in the XML file:

  • Holding [Top 10]
  • Holding [Top 25]
  • Holding [Top 100]

(from 10 to the number specified in the argument - in the steps allowed by the tool [10, 25, 100, 1000, 3200])

This way, all the information would be in PP and you can pick the level of detail you want to see.
e.g. you can analyse the details in the classification-definition (“Definition der Klassifizierung”) of “holding [Top 100]” and look at the charts (e.g. Kreisdiagramm) for “holding [Top 10].

Would be great!

But anyway… thanks again for the tool!

Cheers,
fdswe

1 Like
331

OK, now I understand the last part of the sentence.

With the Top 3200 holdings, PP doesn’t open the edit-dialog (Ctrl + E) for an World-ETF anymore (had to kill the PP-tasks).

I guess the tab “Taxonomies” in the edit-dialog would need to load too much data and just breaks (at least on my not very powerful Windows PC).

What a bummer! :frowning:

fyi - Some test results (% without classification for World ETF IE00B4L5Y983):

  • Top 3200 → 0,3% without classification → Edit dialog doesn’t open
  • Top 1000 → 3% without classification → Edit dialog doesn’t open
  • Top 500 → 14,4% without classification → Edit dialog opens but takes too long
  • Top 300 → 24,3% without classification → Edit dialog opens but takes too long
  • Top 250 → 28% without classification → Edit dialog opens but takes long
  • Top 100 → 45% without classification → works fine (on the slow side)
  • Top 10 → 72% without classification → works fine

(3 tiny code adjustments to test with 250, 300 and 500 holdings)

Edit:
To be fair… other tools also just show the top 100 holdings.
e.g.

  • https://app.holistic.capital/ (“x-ray” is a free feature)
  • Parqet X-Ray: Asset-Allocation unter Berücksichtigung von ETFs (not tested, as not free)
    (“Um die Übersichtlichkeit zu wahren, haben wir in der ersten Version von Parqet X-Ray ein Limit für die Top 100 Assets eingebaut. […] Für Nutzer, die sich vollständig in die Daten vertiefen möchten, bieten wir zusätzlich einen CSV-Export an, in dem alle Anteile ohne Einschränkung dargestellt werden.”)
332

Hi,

My experience: As long as you don’t open the edit-dialog (Ctrl + E), PP is able to manage large number of holdings. I use it regularly even with top 3200 holdings (e.g. in Statement of Assets or for exporting Statement of Assets), but aftwards I usually fall back to lower numbers again to keep the file manageable.

I undestand your idea and will consider such option in future, but for the moment, I would recommend that you run the script multiple times and after each run rename the taxonomy Holding into e.g. “Holding [Top 25]” to preserve the result of the previous run.

333

OK, thanks for considering!

I run the script with the various top-holding arguments and exported/imported the taxonomies in my main-Portfolio. Worked as well.

335

Thanks a lot for the answer and this tool. Now it works :grinning_face: .