+ Reply to Thread
Results 1 to 3 of 3

Share Register

  1. #1
    Registered User
    Join Date
    12-11-2010
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Share Register

    I am looking for ways to improve our share register. Currently, we list for each parcel of shares, the date of purchase, cost, no of shares, market value of share at 30 June current year and also 30 June prior year (if share was held then). We total the investment in each share and calculate the movement in market value as at 30 June current year and where applicable the profit/loss on sales first using original cost, then using market values form year start.
    We have a separate range of cells for each investment and each time we acquire or sell we have to add a new line and all the appropriate formaulas then create sub-totals for each share and finally grand totals for all the shares.
    This seems very inefficient and I think we may be able to use the list functions and input using a form toachieve the same result but quicker. I don't quite know where to start.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Share Register

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Share Register

    @pike - technically the duplicate is locked down in so far as was posted to Tips & Tutorials and Teylyn asked OP to repost in correct forum - as such I've re-opened this thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1