Is there a way to get a report on security values at a point in time ?

Question

I need to get a report listing all securities with their current values at a point in time.  I need to be able to export the report to CSV.  Is there a way of getting such a report ?

Garry@ · Answer

Sorry, yes, I only asked about security values - at that point I didn't realise the NWOT report can't be exported.  I've added my vote to a lot of the feature and report requests.  Most seem quite old which is a concern.

Off topic: I'm another Q2007 user (since 1997).  But, as macOS 10.15 is 64-bit only, I'm looking for an alternative.  It's been quite a shock – I can't find any tools that match the speed, data recording and reporting capabilities in Q2007.  It's also a surprise that Q2020 can't import/export QIF.  Even more oddly, I've tested the Q2007 import function in Q2020 and 4 other tools.  With my data, Q2020 came in second - it results in more extraneous transactions and takes more work to fix than the 1st place tool.

Cheers, and many thanks.

Garry@ · Answer

I've just realised that RickO's solution does not work for Banking and Property/Debt accounts.  I've looked at the Net Worth and Net Worth Over Time reports but they are [sorry] useless.  They can only be done for the end of each month, can't be exported to CSV and when printed or copied truncate long account names !

Is there a work around for non-Investment accounts ?

Garry@ · Answer

Many thanks.

Is there a way to get those amounts for time periods e.g. every half-year for the last 5 years ?