Exporting a statement of assets organized by securities account?

English Import/export
1

Hello, thank you all for the excellent software! I’ve been a user for about 2 years, and really love it.

I am attempting to export a comprehensive view of all securities I own segmented by account. Thus, if I have VTI in both a taxable brokerage and my 401k, the .csv file would have 2 entries.

From Reports > Statement of Assets> Arrow Up - I am able to export the complete balances of each security, but as far as I can tell, I’m only able to segment by taxonomy and there is 1 row per security.

From Securities Accounts > Name of Account (top panel) > Arrow up on bottom panel - I am able to export the list of securities… but only 1 account at a time.

Ideally I could export everything into 1 file. Please let me know if I’ve missed how to do this.

Thank you,

Anthony

2

Hello, I think maybe from the Trades view ? If you filter by Open Trades, it will list the trades still open, so the securities currently own, and trades are separated by securities account.
But the available columns are not exactly the same as in Statement of Assets.

1 Like
3

Hi @santhonys, I feel @Veterini made a good suggestion - the ‘Trades View’ may comprise all the information you require. However, some details don’t feature on this view. If you’re keen in also considering dividend payments, taxonomies and taxes/fees an SQL query that works with ‘Ppxml2db’ could potentially be a better fit - as set out here: Ppxml2db Taxonomy Query