Pie chart for security account ratios

Hi there!

Is there a way to plot a pie chart showing share of individual accounts in the entire portfolio? Something like holdings chart but with accounts instead of securities.

Alternatively, is it possible to export list of security accounts together with their balances as CSV?

No.

Yes, almost every list has an export button at the top right. That should include the list of securities accounts.

Hey @chirlu, thanks for response!

well, I can not find it at the top of the view so I asked here :slight_smile: I’m able to export the transactions or list of securities within single account but what I’d like to do is to export list of all my securities accounts with their total values in format like this:

Account_A, 1000
Account_B, 1500
Account_C, 900

So if there is a way to do that, could you paste some screenshots showing how to do it?

Unfortunately, there is indeed no export button for the list of securities accounts. That will need to be changed at some point. (And the workaround of selecting the lines and copying them with Ctrl-C, for insertion into a spreadsheet, doesn’t work very well either because only one line can be selected and copied in this view.)

Workaround : plot your securities accounts on a dedicated Statement of Assets charts and export the data of the chart. You will then get your values per account, not only for the currentl values but days by days.

1 Like

Workaround for the pie chart : you may recreate the accounts in a Taxonomy with the accounts as first level node and then use the donut or pie chart ‘without the instrument’. Does not perfectoy work if you have the same securities in several accounts.

Thanks for tips @Veterini!

Yeah, that was the first thing I tried to play with, but in deed I have same security in multiple accounts. And still changing no. of shares so taxonomy would be pretty hard to maintain in my case.

Workaround : plot your securities accounts on a dedicated Statement of Assets charts and export the data of the chart. You will then get your values per account, not only for the currentl values but days by days.

That’s nice one! Didn’t thought about it and will play pretty nice for me until there is possiblity to do the accounts pie chart in the PP. Thanks!

I have written a small tool that - among other things - can export (securities and deposit) accounts as CSV or JSON (still early beta status though):

pp-terminal --file=depot.xml --format=csv list accounts --type=account

If you like to try it, I’m happy about feedback :slightly_smiling_face:

The pp-terminal repository explains the tool uses ppxml2db for the sql database which is discussed in Portfolio Performance database – ppxml2db import/export.