Report to show security purchases

enich's Avatar

enich

25 Jan, 2021 11:07 PM

I am trying to find a way to print a report that shows all stock purchases for 3 different investment accounts. Any ideas?

  1. 1 Posted by Stuart Beesley ... on 25 Jan, 2021 11:15 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Are you after actual buys txns or to total the stocks held over several accounts?

  2. 2 Posted by -Kevin N. on 26 Jan, 2021 12:26 AM

    -Kevin N.'s Avatar

    Hi enich,

    Give the Investment Transactions Report a try.
    When setting the parameters, be sure that the 'Account' parameter is not ticked otherwise the report generated will be limited to only 1 account.

    -Kevin N. (not a member of MD support)

  3. 3 Posted by enich on 27 Jan, 2021 01:38 PM

    enich's Avatar

    Stuart,

    I am looking for a way to list all the buy transactions with their amounts as well as the total amount spent. This could be for one account at a time or all three.

  4. 4 Posted by Stuart Beesley ... on 27 Jan, 2021 01:40 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Have you tried the Investment Transactions Report?

  5. 5 Posted by enich on 27 Jan, 2021 01:42 PM

    enich's Avatar

    Yes but I don’t see a way to just get only the buys and not all of the other transactions.

  6. 6 Posted by -Kevin N. on 27 Jan, 2021 02:07 PM

    -Kevin N.'s Avatar

    Hi enich,

    In the Investment Transactions Report, set the 'Subtotal By' parameter to 'Subtotal by Action'.

    It will still report on all of the transactions but the 'Buy' transactions will be totaled separately.

    -Kevin N. (not a member of MD support)

    -

  7. 7 Posted by Stuart Beesley ... on 27 Jan, 2021 03:09 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    ... and another method... I have an extract that can dump your investment data to csv for opening in Excel... You can then filter on Buys... It's called extract_investment_transactions_csv - available here:

    https://yogi1967.github.io/MoneydancePythonScripts/

  8. 8 Posted by enich on 27 Jan, 2021 03:32 PM

    enich's Avatar

    Thank you both. I will give these a try this afternoon.

  9. Melissa closed this discussion on 12 Feb, 2021 10:36 AM.

Comments are currently closed for this discussion. You can start a new one.

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

Recent Discussions

04 Feb, 2023 03:06 AM
04 Feb, 2023 02:45 AM
04 Feb, 2023 02:41 AM
04 Feb, 2023 12:47 AM
04 Feb, 2023 12:36 AM