Home → General Questions →

Exporting to Microsoft Excel

• Edit

Tabansi

05 Dec, 2023 09:45 AM

Hi Team,
When clicking on "Portfolio View" and then a particular "Securities Detail" you are presented with a list of historical actions including the date that it was bought/sold/dividend, how many shares, the price per share and the total cost.

I have been looking into the Graphs and reports menu's and am struggling to find a way to export this information for any particular security into an Excel spreadsheet, any suggestions please?

• Securities_detail.jpg 61.9 KB

1. 1 Posted by dwg on 05 Dec, 2023 10:00 AM

   

   You are looking at a security sub account.

   I believe the only thing I have seen in a report that is similar to this is the cost basis report for a selected security. It does not give the price per share but this is just a formula.

   • Edit

2. 2 Posted by Stuart Beesley ... on 05 Dec, 2023 12:32 PM

   

   extract data extension. Option. Extract investment accounts/registers.

   • Edit

3. 3 Posted by Tabansi on 05 Dec, 2023 01:20 PM

   

   Thanks Stuart,
   That worked Perfectly.

   I Installed the 'Extract Data' extension, chose 'Extract Data' from the Extensions menu, then after setting my extraction folder I chose the "Investment Transactions - extract to csv" option and clicked on 'Proceed', after this, the only thing I changed was the Start Date and under 'Filter for Security/Ticker containing text' I put AZN for Astrazeneca, then clicked 'CSV Extract'.

   This produced an Excel spreadsheet with exactly what I required.

   Much appreciated.

   • Edit

4. 4 Posted by Stuart Beesley ... on 05 Dec, 2023 04:34 PM

   

   ED +1 😃

   • Edit

5. System closed this discussion on 05 Mar, 2024 04:40 PM.