Shares owned as of a certain date

cary.lewis0409's Avatar

cary.lewis0409

16 Aug, 2018 12:09 AM

Is there a way to change or modify the register or Bank register on an investment account so that it will show howmany shares of a security the account has AS OF the date of the register entry? Is there a report that I can produce?

For example,

I buy 100 shares of security XYZ on June 1st, 2018 at 10 dollars per share.
I buy 52 shares of security XYZ on July 1st, 2018 at 9 dollars per share.
I buy 38 shares of security XYZ on August 1st, 2018 at 9 dollars per share.

How can I see that I owned 152 shares on July 15th, but owned 190 shares on August 10th?

Thanks

  1. 1 Posted by mhoggie on 16 Aug, 2018 04:24 AM

    mhoggie's Avatar

    I had to do something like that a few months ago. I used the Investment report, selected my investment account, set the date range as needed, and subtotal by security. Then I saved the report as comma delimited, and opened it up with spreadsheet software. Then I could delete all the extra junk and add a column to count the shares and subtotal for each transaction. I little convoluted, but it worked.

  2. System closed this discussion on 15 Nov, 2018 04:30 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 Mar, 2024 10:01 PM
04 Mar, 2024 08:05 PM
04 Mar, 2024 08:02 PM
04 Mar, 2024 03:16 PM
04 Mar, 2024 01:28 PM