Exporting to Microsoft Excel

Tabansi's Avatar

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?

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

    dwg's Avatar

    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.

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

    Stuart Beesley (Mr Toolbox)'s Avatar

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

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

    Tabansi's Avatar

    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.

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

    Stuart Beesley (Mr Toolbox)'s Avatar

    ED +1 😃

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Already uploaded files

  • Securities_detail.jpg 61.9 KB

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac